In this lesson we review how use absolute & mixed cell references when writing formulas in Microsoft Excel. Locked cell references are probably the most important skill in formula writing.
This is video 3 of our course, below is a link to lesson 4 and a playlist of the full Module 1.
👉 Check out my courses to help you master Excel in a weekend: www.ericandrewsstartups.com/courses
🚀 If you want to master the finance skills & frameworks to successfully scale technology startups, secure your spot in my "Finance for Startups" program, today: www.ericandrewsstartups.com/financeforstartups
Communities:
💼 Linkedin: www.linkedin.com/in/eric-andrews-1624b656/
☑️ Twitter/X: twitter.com/eric__andrews
🌟 Instagram: www.instagram.com/ericandrews_startups/
🔥 Discord: bit.ly/discord_eric
💻 Newsletter: bit.ly/joinericnewsletter
🎥 Clips: / @ericandrewsclips7818
Related Videos:
► Next Lesson: Freeze Panes in Excel: • How to Freeze Panes in Excel
► Preview the first six lessons of the course: • Become an Excel Power User in 2.5 Hou...
____________________________________________
To access the entire course, take a look at the above link.
In this lecture we will learn about locking cell references in specific ways (to create mixed cell references) so that we can copy & paste the formulas without having to rewrite them.
Absolute and mixed cell references are one of the foundations of writing formulas in Excel. Without learning this skills, you will waste endless amounts of time re-writing formulas.
If you have any questions about locking cells or absolute references, just leave me a comment and I'll get back to you!
If you'd like to learn more, I built a business-focused Excel course on Udemy that is stripped down to the core functions for being an analyst (link above).
The course is 2.5 hours and includes things like:
-completely abandoning the mouse to increase speed 3X
-data manipulation & visualization
-conditional statements & pivot tables
► Subscribe for more finance videos: bit.ly/EricAndrewsSubscribe
Eric Andrews