Microsoft Excel 2013 Expert

This Microsoft Excel 2013 Expert course takes students on a journey that highlights the upper-level skills which will allow them to get the most bang for their buck from this powerful software. Over the course of 12 modules, students will get a look at conditional formatting, slicers, Power View, the Inquire Add-In, tables, records and fields, using Excel as a database, custom AutoFill lists, comments, tracking changes, and linking, consolidating, and combining data.

 

After completing this course, students will be able to:

Use Conditional Formatting

Work with Slicers

Use Power View

Use the Inquire Add-In

Work better with Tables

Work better with Data

–

Prerequisites

 

Before attending this course, students must have:

Microsoft Office Excel 2013: Introduction

Microsoft Office Excel 2013: Advanced

 

Topics

 

Lesson 1: Using Conditional Formatting

Lesson 2: Working with Slicers

Lesson 3: Using Power View, Part One

Lesson 4: Using Power View, Part Two

Module 5: Using the Inquire Add-In

Module 6: Working with Tables

Module 7: Working with Records and Fields

Module 8: Using Excel as a Database

Module 9: Using Custom AutoFill Lists

Module 10: Using Comments

Module 11: Tracking Changes

Module 12: Linking, Consolidating, and Combining Data