Course Details > MS Office > Excel
Microsoft Excel Level 3 - Advanced
To view or download the detailed course description in PDF format click here [link will open in a new tab or window depending on your browser].
In this course you will learn to utilize the advanced features in Microsoft Excel including:
Importing and exporting Data.
Use of data forms and named ranges.
Using the Solver tool.
Sorting and filtering Lists.
Creating Macros to automate your tasks.
Spreadsheet protection and validation.
Master data validation.
Merging and linking workbooks.
Using advanced data analysis tools and lookup functions.