IIRF Online > Office Productivity > Microsoft > Excel Formulas and Functions > Advanced Excel - Top Excel Tips & Formulas
Advanced Excel - Top Excel Tips & Formulas by Udemy
Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)
Course Highlights
- Be a Confident & Advanced Microsoft Excel user
- Able to solve complex problems in Excel
- Learn new techniques and formulas to tackle tasks faster and better in Excel
- Apply the right tools for a given task instead of going to your go-to tools and making them work for every situation
- Reduce complexity of your spreadsheets
Skills you will learn!
Curriculum
3 Topics
Advanced Excel - Introduction & Scope
DOWNLOAD these Files First
Course Outline for Quick Reference
20 Topics
Overview of Top Excel Tips
Tip 1 - Become Faster with Excel's Keyboard Shortcuts
Tip 2 - Master the Simpler Tasks: Part 1
Tip 2 - Master the Simpler Tasks: Part 2
Tip 3 - Quickly Navigate Larger Files
Tip 4 - Inspect Workbooks for Hidden Information
Tip 4 Extended - Unhide Hidden Names with VBA
Tip 5 - Use Protection Appropriately
Test Your Knowledge - Top 5 Tips (Don't Skip)
Tip 6 - Import Text CSV & Web Data Properly
Tip 7 - Audit & Debug Formulas
Tip 8 - Improve Presentation with Customized Number Formatting
Tip 9 - Solve Problems With Goal Seek
Tip 10 - Use Excel PivotTables for Super Fast Analysis
Tip 10 - PivotTables: Calculated Fields Slicers & Helpful Tricks
Tip 10 - PivotTables: Valuable Design Tips
Test Your Knowledge - Top 10 Tips (Don't Skip)
Bonus Tip - Methods to Speed up Your Excel Files
Bonus Tip - The Possibilities & Limitations of Excel
PDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail)
16 Topics
Overview of Top Excel Formulas
Formula 1 - SUMIFS COUNTIFS AVERAGEIFS to Account for Exceptions
Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple
Formula 3 - IFERROR for Credible Reports
Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups
Formula 5 - INDEX & MATCH for Flexible Lookups
Formula 5 - INDEX & MATCH for Complex Real-Cases
Test Your Knowledge - Top 5 Formulas (Don't Skip)
Formula 6 - The Most Useful Text Functions
Formula 6 - Advanced TEXT functions
Formula 7 - Excel's Top Date Functions
Formula 8 - OFFSET for Dynamic Calculations
Formula 9 - FREQUENCY SMALL & LARGE to Organize and Rank
Formula 10 - SUMPRODUCT For the Gurus
Test Your Knowledge - Top 10 Formulas (Don't Skip)
PDF to Download: Top 10 Excel FORMULAS to Work Smarter
4 Topics
YTD Calculations - SUM SUMPRODUCT & OFFSET
3 Ways to Lookup within Boundaries: SUMIFS SUMPRODUCT & INDEX
Sum Alternate Columns based on Selection - SUMIFS & INDEX
Sum Alternate Columns - SUMPRODUCT
2 Topics
Final Words
SPECIAL BONUS: Discover Exciting Offers!
Advanced Excel - Top Excel Tips & Formulas
Related Excel Formulas and Functions Courses
Thank You!
Your review has been submitted successfully.