Advanced Excel Skills
Based on my experience of training more than 3,000 students in various online & physical training programs, the following 9 areas form the core of advanced Excel skills.
Resources to learn Advanced Excel Formulas
Tables & Formatting
Resources to learn Tables & Formatting
Resources to learn Advanced Conditional Formatting
- Knowing how to pick right type of chart for any situation
- Ability to combine various charts in to one
- Use features like in-cell charts & conditional formatting charts
- Ability to set up dynamic & interactive charts
- Use sparklines
Resources to learn Advanced Charting
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 – grouping, slicers, calculations & summary by different type of metrics.
Resources to learn Pivot Tables & Pivot Reporting
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.
Resources to learn Excel VBA & Macros
Using Excel Productively
It is not enough to know various features of Excel. An advanced user knows how to use Excel productively. This includes knowing important keyboard shortcuts, mouse shortcuts, work-arounds, Excel customizations & how to make everything looks slick.
Resource to use Excel productively
Data Tables, Simulations & Solver
Data tables: help us model practical problems & analyze massive amount of data for a solution.
Solver: helps us model practical problems & find a solution by iterating thru all possibilities. For example, finding cheapest way to ship goods from one location to another.
Simulations: We can simulate real world data & situations in Excel using various random functions & statistical methods.
Trend analysis: We can use built in functions & charting features to understand trend & forecast future values from available data.
Resources to learn Data tables, simulations & solver
Integrating Excel with other tools & Optimizing Excel
Advanced users of Excel know that when you combine the power of Excel with flexibility of other applications like MS Access, Outlook or PowerPoint, you can achieve wonders.
Also, they know how to optimize an Excel workbook to make it fast.
Resources to learn Excel Integration & Optimization
Become Advanced Excel User
Thru Chandoo.org, I have trained more than 3,000 people all over the world & made them advanced Excel users. You too can get this training and become advanced user of Excel.
Click on either links to learn more.