Wyndham Philadelphia-Bucks County Feasterville-Trevose - 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