Overview

Courses Benefits

In this Microsoft Excel Advanced Training course, you will learn how to maximize Excel even further to help you analyze data quicker. You will learn features like PivotTables, macros, and how to protect your spreadsheets from being misused by others.

You Will Learn How To

  • Resolve formula errors
  • Manage data such as removing duplicates, validating and transposing data
  • Answer “What-if” scenarios using goal seek
  • Work with PivotTables
  • Create basic dashboards to visualize data
  • Use Macros to automate repetitive tasks
  • Protect your spreadsheet from misuse by others

Who Should Attend

Anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing. Basic Excel knowledge at the level of Microsoft Excel Basic and Microsoft Excel Intermediate is expected for this Microsoft excel training.

Course Outline

Auditing Worksheets

  • Tracing Formula Precedents and Dependents
  • Showing Formulas
  • Evaluating Formulas
  • Setting Error Checking Options
  • Using Error Option Buttons
  • Running an Error Check

Data Tools

  • Consolidating Information
  • Removing Duplicates
  • Configuring Data Validation
  • Transposing Data
  • Converting Text to Columns
  • Using Goal Seek

PivotTable Basics

  • What is a PivotTable?
  • Creating a PivotTable
  • Using the PivotTable Fields Pane
  • Using PivotTable Classic View
  • Viewing Details of Summarized Data
  • Sorting Pivoted Data
  • Filtering Pivoted Data

Advanced PivotTable Features

  • Using Natural Language to Create PivotTables
  • Changing Field Layout and Sorting
  • Adding Calculated Fields
  • Showing Values in Different Ways
  • Customizing Column Names
  • Changing Order of Rows
  • Changing Order of Columns
  • Grouping Data
  • Changing the PivotTable Layout
  • Creating PivotTables from Data in Multiple Worksheets

Creating Basic Dashboards

  • Creating a Basic PivotChart
  • Using Slicers
  • Using Sparklines
  • Creating Timelines
  • Using the Camera Tool

Using Macros

  • Recording a Macro
  • Editing a Macro
  • Running a Macro

NOTE: Macro programming is not covered

Working with Others

  • Co-authoring
  • Sharing a Workbook
  • Protecting a Worksheet
  • Protecting Cells
  • Protecting a Workbook