Excel 2013 Level 3
Date and Time
Tuesday Apr 11, 2017
8:00 AM - 12:30 PM CDT
Location
1315 N. Mattis Ave., Champaign, IL 61821
Parkland College on Mattis
Contact Information
217-351-2235
Send Email
Description
In Excel Level 3, build on the skills you acquired in the Microsoft Excel 2013 Basic and Intermediate courses. You will work with advanced functions and formulas as well as search functions such as VLOOKUP, MATCH, and INDEX. In addition, learn about data validation and use advanced data filtering. You will apply advanced chart formatting options and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. You’ll learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, you will run and record macros.
Prerequisite: Microsoft Excel 2013 Level 2 or equivalent knowledge.