Loading...

Course Description

This course is the continuation of Excel - Intermediate. It is the third course in a series of three Microsoft Excel courses: Introduction, Intermediate and Advanced. Topics include database management techniques, PivotTables and PivotCharts and Macros. 

Course Outline

  • Managing Data with Excel
  • Overview of using Excel for Database Operations
  • Tables
  • Records
  • Sorting
  • Filtering
  • Subtotals
  • Database Functions
  • Lookup Tables
  • PivotTables
    • Overview
    • The PivotTable Screen
    • PivotTable Field List Pane
    • The PivotTable Ribbon
    • How to Pivot the PivotTable
    • PivotTable QuickFilter
    • PivotTables Options
    • Copying, Deleting PivotTables
    • Sort a PivotTable
    • Grouping
    • Top/Bottom Items
  • PivotCharts
    • Creating a PivotChart
    • Modifying PivotChart
    • PivotChart Options
  • Simple Macros
  • Recording and Running Macros
  • Visual Basic Editor
  • Viewing and Editing Macros

Additional Information

This course is delivered in Excel 2013 but is relevant for Excel 2010 users also.

Prerequisites

Excel – Intermediate, or equivalent experience

Duration

6 Hours | 1 Day or 2 Nights

Applies Towards the Following Certificates

Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel III: Database Operations, Filters, Subtotals and Macros
Type
Instructor-Led
Days
M, W
Time
5:30PM to 8:30PM
Dates
Jan 11, 2021 to Jan 13, 2021
Schedule and Location
# of Course Hours
6.0
Delivery Option
Course Fee(s)
Rate non-credit $345.00
Potential Discount(s)