Tuesday Apr 11, 2017
8:00 AM - 12:30 PM CDT
1315 N. Mattis Ave., Champaign, IL 61821
Parkland College on Mattis
217-351-2235
Send Email
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.
Printed courtesy of www.champaigncounty.org/ – Contact the Champaign County Chamber of Commerce - IL for more information.
303 W. Kirby Ave., Champaign, IL 61820 – (217) 359-1791 – info@champaigncounty.org