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 -- DOWNLOAD YOUR WORKBOOK!
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?n
The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?lesson
Quiz 1 - Got Skills!
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 2 - 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 3 - Saving and Compatibility
The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
Quiz 4 - 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
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
Quiz 5 - BUILD
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 - 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?
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
Let's Keep On Learning - FORMATTING
7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly
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
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!
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?
Let's Keep On Learning - PRINTING
What's A Macro?
Recording Your 1st Macro - Yes, It's That Easy
Run Your Macro
Wrap Up
Untitled lesson
Excel Keyboard Shortcuts
193_EXCEL_2010_Shortcuts_WIN
200_EXCEL_2013_Shortcuts_WINDOWS
Excel_2007_Shortcuts
Excel_2011_MAC_Shortcuts
Excel_2016_MAC_Shortcuts
Excel_2016_Shortcuts
CONGRATULATIONS! -- WELCOME!
START HERE -- DOWNLOAD YOUR WORKBOOK!
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?n
The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?lesson
Quiz 1 - Got Skills!
Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!
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 2 - 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 3 - Saving and Compatibility
The QAT
The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
Quiz 4 - 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
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
Quiz 5 - BUILD
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 - 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?
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
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
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
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!
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?
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
Untitled lesson
ADDITIONAL RESOURCES
Excel Keyboard Shortcuts
193_EXCEL_2010_Shortcuts_WIN
200_EXCEL_2013_Shortcuts_WINDOWS
Excel_2007_Shortcuts
Excel_2011_MAC_Shortcuts
Excel_2016_MAC_Shortcuts
Excel_2016_Shortcuts
×
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