Event Level: Advanced
Required Knowledge: Experienced Excel® user
Advanced Preparation: None
Who Should Attend: Business professionals who work with Excel® 2019 or newer and want to extend their knowledge with advanced features and functions
Vendor: K2 Enterprises
Speaker: Tommy Stephens
Speaker: Mac McClelland
Speaker: Brian Tankersley
Speaker: Jeff Cook
Speaker: Randy Johnston
Speaker: Connie Clark
- * Identify and implement the best techniques to secure sensitive information in Excel® workbooks and collaborate with other users to improve accuracy and efficiency * Create tables and take advantage of their advanced features, such as dynamic data ranges, structured reference formulas, and the ability to relate multiple tables together into a Data Model * Import and link data into Excel from external sources — including text, Access, and SQL Server — and use advanced tools, such as Power Query and various cleanup tools to manipulate the data to meet specific needs * Use advanced functions, such as SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR to create and audit complex formulas * Analyze worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables * Describe techniques used to create, manipulate, and customize charts for analyzing and communicating information