INTERMEDIATE MICROSOFT EXCEL
This hands-on one-day training course has been designed to give delegates a solid understanding of intermediate level tools and concepts used in Excel, specifically in writing and using formulas in order to increase their knowledge and productivity.
Users with a basic understanding of Microsoft Excel who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.
MODULE 1: Working with Functions and Formulas
Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.
- Creating Formulas
- Common Aggregate Functions (eg. SUM)
- IF and Nested Functions
- Using the VLOOKUP Function
- Formulas with Absolute References
- Text Functions
- Date Functions
MODULE 2: Managing Tables in Microsoft Excel
Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.
- Creating Excel Tables
- Sorting and Filters
- Formatting Your Form
- Using Formulas on and in an Excel Table
- Totals in Tables
MODULE 3: Data Tools in Excel
Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.
- Text to Columns
- Remove Duplicates
- Conditional Formatting
- Flash Fill
- Data Validation