Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Productivity
First Section
Saving/Opening Files & Ribbon Menu (10:23)
Getting Started With Formulas (7:42)
Formulas
Formulas Introduction (10:47)
Concatenate (2:52)
A Common Multi Column Summation Done Very Quickly (2:28)
Calculating Time Spans (2:05)
vlookup Exposed (6:22)
Phone Numbers (12:45)
Making Your Data Make Sense
Sorting (6:06)
Removing Duplicates (3:44)
Conditional Formatting (7:51)
How Does Excel Know Which Data Format To Choose? (3:35)
Updating an Existing Chart's Data Source (4:42)
Productivity 10x Features
Quick Analysis (3:15)
Multi-Sheet View (3:59)
Freezing Panes (4:17)
Ninja Shortcuts
Power of the Alt Key (3:57)
Selecting Only Relevant Data (3:46)
Shortcut Keys (2:35)
Shortcut Key Listing
Locking Cells & Showing All Formulas (4:13)
Excel Overdrive
Create an Organizational Chart Fast (then add it to PowerPoint) (3:26)
Building A Functional Database (project file attached) (6:42)
Customizing Your Workspace
Hiding/Unhiding Single And Multiple Columns (3:19)
Coloring Tabs For Better Grouping (2:57)
Extending Excel
Solving Complex Problems Easily (project file attached) (11:23)
Sourcing Data Directly From The FED Into Excel (7:07)
Power Query (8:22)
Saving/Opening Files & Ribbon Menu
Complete and Continue