If you need to be able to work with Advanced features of Excel, then you will benefit from this course, which will cover the following: • Creating Advanced Formulae: Using name Ranges; Using V-lookup; Using H-Lookup; Using V-Lookup and H-lookup together; Using Concatenate • Filtering Data in a list, including Advanced filtering and Custom sorting; • What-if Analysis: Goal seeking; Scenario Manager; • Adding Subtotals to a list; • Using Pivot Tables, including Pivot chart and Slicers; • Recording