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