Excel Intermediate

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.