Microsoft Excel - What you can learn - Sample Courses

---

Creating and working with spreadsheets

Editing and formatting cells

Entering formulas

Using essential functions such as SUM, AVERAGE, COUNT, COUNTA

Organising data with sorting and filtering

Displaying data in charts

Working with Tables

Managing setup and printing

Working with conditional formatting

Displaying sparklines

Using intermediate functions such as IF, COUNTIF, SUMIF, VLOOKUP, XLOOKUP, SUMPRODUCT, TRIM, CLEAN CONCATENATE

Using named ranges and formula auditing

Summarising data with PivotTables

Protecting worksheets

Working with subtotals

Applying advanced filters

Using advanced functions such as nested IF/AND, INDEX/MATCH, IFERROR/VLOOKUP, AVERAGEIFS, SUMIFS, COUNTIFS

Grouping and outlining data

Working with data validation and consolidation

Using 'What if' analysis tools

Absolutely! We are more than happy to customise the course outline to suit your needs.

Please contact us to request a Training Needs Analysis form. Simply get your team members to complete and we'll do the rest.