- Pivot tables and reporting
- Advanced conditional formatting
- VLOOKUP. VLOOKUP (vertical lookup) is a function to look up a value in a table and retrieve data from a specific column
- Financial analyst
- Data analyst
- Information clerk
Advanced Excel is quite different from Basic Excel, the focus for the user is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros. Some of the other important concepts to explore while working on Advanced Excel are: If Statements. Sum Products. VLOOKUP.