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.
This website uses cookies. Using this website means you are ok with this but you can learn more about our cookie policy and how to manage your cookie choices here