MICROSOFT EXCEL BASICS - References and R1C1 notation (consulting Excel skills)

Interested to learn Microsoft Excel basics for consulting? This introduction to Excel references and R1C1 notation covers fundamental consulting excel skills. It is an important primer to Microsoft Excel, specifically the reference styles in Excel. Do you want to learn the differences of A1 and R1C1 notation in Excel? This video shows you how Excel works on a technical level. It is key to understand how Excel references word. Are you asking yourself how does Excel work? Trust this Microsoft Excel tutorial for beginners and intermediate will provide important answers, delivered from a former McKinsey management consultant. Learn Excel for beginners with this video to master the Office 365 suite. Chapters 00:00 Introduction 00:53 Relative references 02:55 Introduction to R1C1 notation 06:50 R1C1 notation in practice 08:41 Absolute references 14:45 Wrap-up # MY ONLINE COURSES* Learn to make PowerPoint presentations like Top Management Consultants: "CEO-level Presentation Skills - Slide Writing for Consulting" https://link.firmlearning.com/slides Everything you need to know about Blockchain and Cryptocurrency: "The Complete Course on Blockchain and Bitcoin" https://link.firmlearning.com/blockchain Udacity - Learn the latest tech skills, great if you want to learn how to code without technical background (e.g., as a business student) - with this link, 50 USD discount on all courses https://link.firmlearning.com/udacity # CHANNEL MEMBERSHIP Become a member of Firm Learning to support my work and get access to perks: https://link.firmlearning.com/join # CV TEMPLATE* Get a CV template based on my current CV. With an earlier version of this CV, I successfully applied to McKinsey as consultant: https://link.firmlearning.com/cvtemplate # NEWSLETTER Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management: https://link.firmlearning.com/e-mail # BOOK RECOMMENDATIONS* The Hard Thing About Hard Things - Ben Horrowitz https://amzn.to/3aYseE8 Extreme Ownership: How US Navy Seals Lead and Win - Jocko Willink https://amzn.to/3d32sAE The McKinsey Way - Ethan Rasiel https://amzn.to/38SQarl Influence: The Psychology of Persuasion - Robert Cialdini https://amzn.to/2wUI4Bd How a Diet can be a Game Changer in Life - Marie Mirrlees https://amzn.to/2MUyfIh # AUDIOBOOKS* This is a link to the audiobook service Audible that I use every day. It helps me "read" 50+ books every year. The link gives you a free test month: https://link.firmlearning.com/audible # SOCIAL MEDIA Instagram: https://link.firmlearning.com/instagram Facebook: https://link.firmlearning.com/facebook * Links are Affiliate links. This means that I receive a revenue share whenever a purchase is made via the link. The price for you stays the same. Thank you for supporting my work at Firm Learning! All views expressed on this channel are private opinions of this channel's creator Heinrich. This is NOT an official channel of any consulting firm.