Upon successful completion of this workshop, learners will be able to demonstrate their ability to: Use of Relative and Absolute Cell addressing; Use Excel’s Financial, Statistical, Look up and reference, Database, and Logical Functions; Use the lookup and reference VLOOKUP and HLOOKUP functions; Work with Range Names, IF Statements, Nested IF Statements; Work with and apply the Excel’s DB and FV, PV PMT, PPMT, IPMT Financial Functions; Using Functions and AutoFill to Perform Difficult Calculations; Apply Formulas with Multiple Cell References; Work with Array Formulas; Use and Manage Tables (Databases) in Excel; Apply their knowledge practically to their advanced Excel usage of Formulas and Functions; Get the most from Excel data with the use Pivot Tables, Pivot Charts, Exploring Scenarios and What If Analysis; Consolidate and Combine Workbooks.