Microsoft Excel Masterclass - Digital File

Microsoft Excel Masterclass - Digital File

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

    $29.00Price
    • Facebook
    • YouTube
    • Instagram

    ©2020 by MeritCAANZ.com