If you want to succeed in an accounting or finance career, you will need to be a master at Microsoft Excel.
 
This digital file contains over 70 weeks of the best tips & tricks, functions, formulas, shortcuts and general theory to make you into an expert. Some of the topics covered include:
 
Basic functions:
- Viewing in 2 windows
- Autofill
- Remove duplicates
- Creating dynamic workpapers with drop-down boxes
- Custom sort
- Grouping
- Freezing cells
& much more
 
Intermediate functions
- Index match, sumif, vlookup, countif etc.
- Pivot tables
- Fill blanks
- Min & Max
- Workbook links
- Offset
- Drop-down & if combinations
- Creating excellent charts & tables.
& much more
 
Advanced functions:
- Text to columns
- Named Ranges
- Flags
- Pivot Slicers
- Formula auditing
- Excel Presentation
- Legend & model formatting
- Navigation Pages
- Subsitution
& much more
 
We also sell Excel video training courses seperately at www.meritcaanz.com/training