Advanced Excel

Advanced Excel

Formulas make Excel smart. With out them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion (and they also know few alternatives for any given formula problem).

Resources to learn Advanced Excel Formulas

• SUMIFS
• SUMPRODUCT
• VLOOKUP | XLOOKUP
• INDEX + MATCH
• Handling Formula Errors
• Array Formulas
• Circular References
• Formula Auditing

Resources to learn Advanced Charting

• Selecting Right Chart
• Interactive charts in Excel
• Combine two chart types – demo
• In-cell charts
• Budget vs. Actual data – Advanced Chart
• Sparklines
• More

Pivot Tables & Pivot Reporting

Pivot tables & pivot reporting allows us to analyze massive amounts of data & answer questions with just a few clicks. Advanced users of Excel are very familiar with various features of Pivot tables & can use them really well. Some of the advanced pivot table features are – relationships, multi-tale pivots, grouping, slicers, measures (Power Pivot) & summary by different type of metrics.

Resources to learn Conditional Formatting

• Introduction
• 5 Tips on CF
• Highlighting Duplicates
• Hourly goals tracker – Advanced CF demo
• More

VBA & Macros

Excel’s own language – VBA, allows us to give instructions to Excel to get things done. This is a simple, but extremely powerful way to extend Excel’s functionality. Advanced users of Excel are familiar with VBA & can write macros to automate their day to day work, thus saving countless hours of time & money.

• Introduction to VBA
• Understanding VBA Variables, Conditions & Loops
• Find and extract matching values with VBA – Example
• VBA Examples
• VBA Online Course
• More

Excel Pivot Table Topics:

In this guide, you can learn the following topics. Click on relevant link to access the information.
1. What is a Pivot Table?
2. How to Create a Pivot Table in Excel?
3. Pivot Tables – Top 5 Tips & Tricks
4. Advanced Pivot Table Techniques

1. Grouping Data in Pivot Reports
2. Using Report Filters
3. Using Pivot Table Slicers

5. More Pivot Table Examples & Techniques
6. Training Programs on Pivot Tables
7. Books on Pivot Tables
8. Additional Resources on Excel Pivot Tables