DON'T GET MAD...GET SKILLS!

THE HEARTBEAT OF EXCEL

Wednesday, 15 December 2021
08:45 AM PST

Class opens at 8:45 AM - Class starts at 9:00 AM - Class ends at 10:30 AM

Days

09

Hours

21

Minutes

38

Seconds

45

 LET'S CONTINUE LAYING A SOLID EXCEL SKILLS FOUNDATION.
LET'S START LEARNING THE HEARTBEAT OF EXCEL

Here is what you will learn in this session:

Step 3 - CALCULATIONS - Add Some Calculations
  • Please Excuse My Dear Aunt Sally! - Time To Remember Some 5th or 6th Grade Math. 
  • Formulas - The Heartbeat Of Excel - The Cells Remain The Same What Changes Is..? 
  • You Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend 
  • Example Of The Moment You Realize - It's Time To Start Thinking About Functions 
  • What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out! 
  • The Most Basic Function - The AutoSum - So Much More Than Just Sum. 
  • Learn To Delegate To Excel - Just Press Alt+= - The AutoSum Power Move! 
  • Quick Overview Of The Insert Function Tool - Your Search Engine For Functions 
  • Quick Tip - Zoom To Selection 
  • Introduction to 3D Referencing - Enter Data In One Cell, It Appears In Another
  •  3D Referencing In Action
  • 3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!
  •  Practice More 3D Referencing - Did You Know You Can Link Your Workbooks? 
Here Is What You Will Learn In The Next Class...

In the next class you will learn the 7 Steps To Excel Success, and we will cover Step 4 and Step 5.