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

Take your Excel skills to the next level. Determine how to collaborate with other users and secure workbooks, use tables to analyze and report data, and integrate and manipulate data from external sources. Learn how to create and audit complex formulas, and use advanced data analysis tools and visualization techniques to analyze and communicate information. Get real examples to reinforce the major topics presented.
Highlights
  • Secure sensitive information
  • Advanced table features: Dynamic data ranges, structured reference formulas, and the ability to relate multiple tables together into a Data Model
  • Import and link data from external sources, including text, Access, and SQL Server
  • Manipulate data with advanced tools, such as Power Query and various cleanup tools
  • Advanced functions to create and audit complex formulas: SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR
  • Data Tables, Subtotals, Slicers, Filters, and PivotTables
  • Customizing charts

Registration

PICPA Member: $299
Nonmember: $399

More Information

Course No. 624000 Level: Advanced

Prerequisites: Experience using Excel

Notes
* This course covers Excel 2007 through Excel 2016. * This is a live demonstration and discussion workshop, and is laptop friendly with access to demonstration files.

Speaker(s)

Steven Phelan