Take your daily Excel journey to new heights resulting from a deeper dive into the many powerful and advanced features it has to offer. It is simply not enough to know the various features of Excel. An advanced user knows how to use Excel efficiently. Acquire the knowledge and skills associated with these under-utilized Excel features:
- Advanced filter with function driven criteria and post results to different worksheet
- Sort using conditional formatting, by columns, and by custom list
- Consolidate
- IF, SUMIF, COUNTIF, DATEDIF, AND OR, FIND LEN
- VLOOKUP exact, VLOOKUP inexact
- INDIRECT
- Linked drop down lists
- GOAL SEEK
- SOLVER
- Pivot Tables – Creating and Modifying, Grouping by date or text, Calculated Field & Item, with Slicers, and Dashboard
- Macros – Recording, Saving and Shortcuts, and Editing
|
Login/Create account
checkout
view cart (
0
)
