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
YTD Calculations - SUM, SUMPRODUCT & OFFSET
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock