Excel 2013 Level 2

Description

Build on the skills and concepts you learned in Excel 2013 Level 1. Wendy Barker will teach you to use multiple worksheets and workbooks efficiently; view and print large workbooks as well protect, share, and save workbooks for distribution. Acquire the skills to format, analyze, and manipulate data in a table including sorting and creating custom and advanced filters and using the lookup functions VLOOKUP, HLOOKUP, MATCH, INDEX, and DGET. Learn how to automate worksheet tasks by creating and editing macros and practice advanced charting techniques using trendlines and sparklines. Finally, generate a scenario summary using what-if-analysis, goal seek , and run solver, and explore the Analysis Toolpak.

Prerequisite: Microsoft Excel 2013 Level 1 or equivalent knowledge.

Thu June 23 & 30, 2015 8:00am - 12:30pm
CIS 721 003Z Fee: $199
Deadline to register: June 16