microsoft partner logo color
8379  Reviews star_rate star_rate star_rate star_rate star_half

Automating Tables and PivotTables in Excel

In this live, online Automating Excel Tables and PivotTables training course, attendees learn how to quickly organize and manipulate Excel’s tables and PivotTables to create summary reports....

Read More
By Request
Contact Us For Pricing
Duration 1 day
Course Code OFC-120-HF
Available Formats Classroom

Overview

In this live, online Automating Excel Tables and PivotTables training course, attendees learn how to quickly organize and manipulate Excel’s tables and PivotTables to create summary reports. Students also learn how to use macros to display the tabulated results even faster without any programming.

Skills Gained

  • Create tables
  • Create basic DAX calculations in tables
  • Format tables
  • Create PivotTables
  • Analyze PivotTable date
  • Format PivotTables
  • Calculate within PivotTables
  • Insert slicers
  • Insert timelines
  • Present data with PivotCharts
  • Create, run, and save macros

Prerequisites

All attendees must have knowledge of Excel.

Course Details

Training Materials

All Excel training attendees receive comprehensive courseware.

Software Requirements

  • Excel 2016, 2019, 365, or later
  • Related lab files that Ascendient Learning will provide

Outline

  • Introduction to Tables
    • What are tables in Excel?
    • Why use tables?
    • Setting up tables
  • Tables
    • Creating tables with one shortcut key
    • Formatting tables
    • Create basic DAX calculations in tables
  • Introduction to PivotTables
    • What is a PivotTable?
    • Why use PivotTables?
  • PivotTables
    • Creating PivotTables
    • Understanding the field task pane
    • Rearranging to analyze the data
    • Calculating within a PivotTables
    • Extracting data to create reports
  • PivotCharts
    • Present with PivotCharts
    • How to Create and Work with a PivotChart
    • PivotChart filters
  • Slicers
    • Create Slicers
    • Understanding the slicer tools contextual tab
    • Timelines
    • Timelines tool contextual tab
  • Introduction to Macros
    • What is a macro?
    • Why use macros?
  • Recording Macros
    • Revealing the record macro button
    • Recording steps that analyze data
    • Creating macro buttons on the QAT
    • Creating Macro buttons on the spreadsheet
    • Saving a macro
  • Applying Macros within Tables and PivotTables
    • Recording macros in tables
    • Recording macros in PivotTables that create reports
  • Conclusion
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

Courseware was effective but would like to have some PDF material on BPML and XPATH

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.

The training was good but needed the basic skills of maximo before getting deep in the configuration of it.

The training was very good to understand the concepts and how to set up things .

The format of the class was concise. I learned new skills to use at my workplace.