Advanced Excel

Oct 30
8:00 - 4:00 p.m.

Penn State Great Valley - Main Bldg
Malvern - Map

4-A&A; 4-Other
CPE Credits

Learn Excel skills in six key areas: collaborate with other users and secure workbooks; use tables to analyze and report data; integrate and manipulate data from external sources; create and audit complex formulas; use advanced data analysis tools; and analyze and communicate information using visualization techniques.
Highlights

Secure sensitive information
Dynamic data ranges, structured reference formulas
Import and link data from external sources
Power Query and other cleanup tools
Advanced functions, such as SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR
Data tables, subtotals, slicers, filters, and PivotTables