On this course we'll start by showing you how to use grouping and auditing tools, and how to work with tables and setup advanced filters. The course will show you how to insert and understand nested functions. We'll also look at how to setup advanced conditional formatting, and you'll learn ways to identify blanks cells and find duplicate data. We end the course by showing you how to get proficient with PivotTables!