I am a certified ITIL analyst and works on all sort of EXCEL related presentations, my role is of defining processes for different organizations.
I am pretty good in:
ADVANCED CHARTING
There is no use if all your analysis is buried in a massive spreadsheet. Advanced users of Excel know that by using charts, we can communicate effectively and present results in a stunning manner. The skills required for advanced charting are,
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
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.
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.
DATA TABLES, SIMULATIONS & SOLVER
Excel has many powerful & advanced features packaged in to it. Data tables: help us model