Zenler Player
Your course is loading. Hang tight.
7 Steps To Excel Success - Excel Skills And Power Tips
Back to curriculum
0% Complete
0% Complete
START HERE!
QUIZ 1 - IMPORTANT - Please Start Here! -- This Is The Worlds Easiest Quiz!
Elements of the Excel Screen - Click This Do What? Ever hear of the Ribbon? Tab?
Did Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?
Can't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?
The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?
Quiz 2 - Got Skills!
Microsoft 365 - The Latest Version
Open Da Maka-Look At The Ribbon. The Simplest Way To Know The Version You're In.
Who Made This Workbook? Get Into The File Tab and Learn The Backstage View.
Quiz 3 - So What's The Difference?
F12 - Save As - I Prefer The "Old School" Save As.
Saving and Compatibility. What Happened To The Sparklines? Save As What Version?
Quiz 4 - Saving and Compatibility
The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
Quiz 5 - The Secret Features - QAT
Begin With the End in Mind - 7 Steps To Excel Success
Templates - Learn how to to tame the "World's Most Dangerous Program."
Five Things That Can Go Into An Excel Worksheet - F2 Is Your Friend
Minimize Repetition - Learn The Auto Fill Handle.
Learn How To Create A Create Custom Fill Series - No More Typing That List!
How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You
Navigation Shortcuts
Quiz 6 - BUILD
Insert Rows and Columns Like A Professional
Selecting Cells And Ranges Like a Professional
Universal Shortcuts - You Probably Already Know Them And Did Not Realize It.
Insert A Worksheet, Name It, Rename It, Move It
Move Worksheets To Another Workbook - Make Worksheet Names Standout With Color
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!
Quiz 8 - Skill Snack - CALCULATIONS
Learn To Delegate To Excel - Just Press Alt+= - The AutoSum - More Than Just SUM
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?
Quiz 9 - Let's Keep On Learning - CALCULATIONS
Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A
Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts
Formatting Money - Should You Pick The Currency Method Or The Accounting Method?
Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)
The Format_Painter
Quiz 10 - Let's Keep On Learning - FORMATTING
7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly
Quiz 11 - Quick Skill Snack - The 7 Habits of Effective Lists
Organize And Display Data - Sort It Out- But Avoid Merged Cells
Continue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together
The BIG Sort Buton
Sometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease
Quiz 12 - Skill Snack - REPORTING
The Filter That Lives A Healthy Lifestyle - Auto Filter
Want To See What Your Numbers Are Saying? How About A Graphical Representation?
Visualize Your Data With Charts - Insert Charts And See What Your Numbers Say
Different Charts For Different Reasons - Change Chart Types - Make Them Pretty
Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
Quiz 13 - Let's Keep On Learning - REPORTING
Print Correctly - Start With a Print Preview - There Is More Than One Way
Tell Excel What You Want To Print - Set The Print Area
Now That Excel Knows What To Print Let's Make It All Fit To One Page
Now That We Can Print Properly - How About Some Headers And Some Footers?
Quiz 14 - Let's Keep On Learning - PRINTING
What's A Macro?
Recording Your 1st Macro - Yes, It's That Easy
Run Your Macro
Wrap Up
Quiz 15 - Let's Keep On Learning - MACROS
338 EXCEL KEYBOARD SHORTCUTS - 2022
227 MAC OS EXCEL KEYBOARD SHORTCUTS - 2022
200+ Keyboard Shortcuts
July Live Class
August Live Class
September Live Class
October Live Class
November Live Class
December Live Class
CONGRATULATIONS! -- WELCOME!
START HERE!
QUIZ 1 - IMPORTANT - Please Start Here! -- This Is The Worlds Easiest Quiz!
Elements of the Excel Screen - Click This Do What?
Elements of the Excel Screen - Click This Do What? Ever hear of the Ribbon? Tab?
Preview
Did Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?
Can't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?
The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?
Quiz 2 - Got Skills!
Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!
Microsoft 365 - The Latest Version
Open Da Maka-Look At The Ribbon. The Simplest Way To Know The Version You're In.
Who Made This Workbook? Get Into The File Tab and Learn The Backstage View.
Quiz 3 - So What's The Difference?
Saving and Compatibility
F12 - Save As - I Prefer The "Old School" Save As.
Saving and Compatibility. What Happened To The Sparklines? Save As What Version?
Quiz 4 - Saving and Compatibility
The QAT
The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
Quiz 5 - The Secret Features - QAT
Begin With The End In Mind - 7 Steps To Excel Success
Begin With the End in Mind - 7 Steps To Excel Success
Preview
Step 1 - DESIGN - It's So Easy In The 21st Century
Templates - Learn how to to tame the "World's Most Dangerous Program."
Step 2 - BUILD - Building Your Worksheet
Five Things That Can Go Into An Excel Worksheet - F2 Is Your Friend
Minimize Repetition - Learn The Auto Fill Handle.
Learn How To Create A Create Custom Fill Series - No More Typing That List!
How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You
Navigation Shortcuts
Quiz 6 - BUILD
Insert Rows and Columns Like A Professional
Selecting Cells And Ranges Like a Professional
Universal Shortcuts - You Probably Already Know Them And Did Not Realize It.
Insert A Worksheet, Name It, Rename It, Move It
Move Worksheets To Another Workbook - Make Worksheet Names Standout With Color
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!
Quiz 8 - Skill Snack - CALCULATIONS
Learn To Delegate To Excel - Just Press Alt+= - The AutoSum - More Than Just SUM
Preview
Quick Overview Of The Insert Function Tool - Your Search Engine For Functions
Quick Tip - Zoom To Selection
Preview
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?
Quiz 9 - Let's Keep On Learning - CALCULATIONS
Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A
Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts
Formatting Money - Should You Pick The Currency Method Or The Accounting Method?
Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)
The Format_Painter
Quiz 10 - Let's Keep On Learning - FORMATTING
Step 5 - REPORTING - Garbage In...Garbage Out - What About Charts?
7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly
Quiz 11 - Quick Skill Snack - The 7 Habits of Effective Lists
Organize And Display Data - Sort It Out- But Avoid Merged Cells
Continue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together
The BIG Sort Buton
Sometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease
Quiz 12 - Skill Snack - REPORTING
The Filter That Lives A Healthy Lifestyle - Auto Filter
Want To See What Your Numbers Are Saying? How About A Graphical Representation?
Visualize Your Data With Charts - Insert Charts And See What Your Numbers Say
Different Charts For Different Reasons - Change Chart Types - Make Them Pretty
Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
Quiz 13 - Let's Keep On Learning - REPORTING
Step 6 - PRINTING - Learn Where The "Fit-to-One-Page" Button Is Located
Print Correctly - Start With a Print Preview - There Is More Than One Way
Tell Excel What You Want To Print - Set The Print Area
Now That Excel Knows What To Print Let's Make It All Fit To One Page
Now That We Can Print Properly - How About Some Headers And Some Footers?
Quiz 14 - Let's Keep On Learning - PRINTING
Step 7 - MACROS - Delegate to Excel
What's A Macro?
Recording Your 1st Macro - Yes, It's That Easy
Run Your Macro
Wrap Up
Quiz 15 - Let's Keep On Learning - MACROS
ADDITIONAL RESOURCES
338 EXCEL KEYBOARD SHORTCUTS - 2022
227 MAC OS EXCEL KEYBOARD SHORTCUTS - 2022
200+ Keyboard Shortcuts
LIVE CLASSES - 7 Steps To Excel Success
July Live Class
August Live Class
September Live Class
October Live Class
November Live Class
December Live Class
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson