Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel - Top 10 Excel Tips & Formulas (Excel 2010)
Introduction, Scope & Excel Files
Advanced Excel - Introduction & Scope (6:48)
DOWNLOAD these Files First (2:03)
Course Outline for Quick Reference
Top 10 Excel TIPS to Save You Time
Overview of Top Excel Tips (2:19)
Tip 1 - Become Faster with Excel's Keyboard Shortcuts (9:35)
Tip 2 - Master the Simpler Tasks: Part 1 (18:12)
Tip 2 - Master the Simpler Tasks: Part 2 (9:23)
Tip 3 - Quickly Navigate Larger Files (11:38)
Tip 4 - Inspect Workbooks for Hidden Information (10:00)
Tip 4 BONUS - Unhide Hidden Names with VBA
Tip 5 - Use Protection Appropriately (16:36)
QUIZ 1 - Top 5 Tips (Don't Skip)
Tip 6 - Import Text, CSV & Web Data Properly (11:55)
Tip 7 - Audit & Debug Formulas (8:41)
Tip 8 - Improve Presentation with Customized Number Formatting (17:23)
Tip 9 - Solve Problems With Goal Seek (6:33)
Tip 10 - Use Excel PivotTables for Super Fast Analysis (16:20)
Tip 10 - PivotTables: Calculated Fields, Slicers & Helpful Tricks (16:16)
Tip 10 - PivotTables: Valuable Design Tips (23:12)
QUIZ 2 - Top 10 Tips (Don't Skip)
Bonus Tip - Methods to Speed up Your Excel Files (5:36)
Bonus Tip - The Possibilities & Limitations of Excel (6:48)
PDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail)
Top 10 Excel FORMULAS for Quick & Dynamic Analysis
Overview of Top Excel Formulas (3:26)
Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Criteria (14:03)
Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple (12:00)
Formula 3 - IFERROR for Credible Reports (5:53)
Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups (11:27)
Formula 5 - INDEX & MATCH for Flexible Lookups (16:23)
Formula 5 - INDEX & MATCH for Complex Real-Cases (18:45)
QUIZ 3 - Top 5 Formulas (Don't Skip)
Formula 6 - The Most Useful Text Functions (12:38)
Formula 6 - Advanced TEXT functions (17:27)
Formula 7 - Excel's Top Date Functions (20:24)
Formula 8 - OFFSET for Dynamic Calculations (14:47)
Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank (15:26)
Formula 10 - SUMPRODUCT For the Gurus (14:55)
QUIZ 4 - Top 10 Formulas (Don't Skip)
PDF to Download: Top 10 Excel FORMULAS to Work Smarter
Formula Combinations for Real Cases
YTD Calculations - SUM, SUMPRODUCT & OFFSET (13:14)
3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX (11:34)
Sum Alternate Columns based on Selection - SUMIFS & INDEX (10:38)
Sum Alternate Columns - SUMPRODUCT (10:00)
Wrap Up
Final Words (2:22)
🚩 Share Your Certificate
You'd Like to Learn More?
My Favorite Resources
Overview of Top Excel Formulas
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login