For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application.
What you will learn:
- Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets.
- Utilities – Protecting data, hide and unhide data, named ranges, working with dates, comments, data validation, headers and footers.
- Linking Data – linking spreadsheets, identifying links, linking separate workbooks.
- Data Analysis – Updating Pivot Tables, filters, subtotals, icons and data bars in conditional formatting, filter and sort using colour.
- Pivot Tables – creating Pivot Tables, Pivot Charts, Slicers, refreshing data, updating ranges.