Microsoft Excel: Databases & Pivot Tables

Microsoft Excel: Databases & Pivot Tables

Overview and Objectives

This one-day workshop is designed to help delegates to understand the importance of databases and to use it optimally in Excel. They will also be introduced to Pivot Tables concepts, from basic to advanced.

Course Outline

This course consists of 3 modules
Module 1Databases
Creating a Database
Applying a Table Style to a Database
Naming a Database
Format & Edit a Database
Sorting a Database
Numbers & Alphanumerics
Sorting in a Special Order
Multiple Sorts
Module 2Find and Edit Data
Find and Edit Data across Several Sheets
AutoFilter
Top Ten AutoFilter
Custom Filter (And/Or)
Advanced Filter
Using the Advanced Filter to Copy Data to an Extract Range
Use the Advanced Filter to Extract info to a Different Sheet
Filter Unique Records Only (Duplicates)
Module 3PivotTable Terms
Create PivotTables
Modify PivotTables
Adding Data Fields to a PivotTable
Hiding Data Fields in a PivotTable
Unhiding Data
Removing Data Fields from a PivotTable
Grouping Items in a Field
Create Report Filters
Create Separate Pages
Display Report Filters on Separate Sheets
Format a PivotTable (Numbers / Tables)
Changing the Data Source Range
Using Datatables to create PivotTables
Calculations in a PivotTable
Create a Calculated Field
Refresh the PivotTable Data
Extract PivotTable Data
Showing Underlying Details
Report Layouts
Insert Blank Rows in a Report
Switch Field Headers On and Off
Switch Subtotals On and Off
Chart a PivotTable
Formatting Pivot Charts
Changing Pivot Chart Options

Excel Databases

Who should attend?

Any delegate wanting to further develop their skills in using Databases & Pivot Tables.

Course Prerequisite

The delegate needs to have a good understanding of Excel and we recommend that they have completed the Microsoft Excel: Introduction course.

Duration

1 Day

Cost

R1 270,00 (excl. VAT)

Includes

  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire
Download Course Information

Microsoft Excel: Databases

Course Schedule

View the available course dates