Microsoft Excel: Databases & Pivot Tables

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.

Group Bookings Only:
Our offices – minimum of 6 delegates per group
On Site – Minimum of 8 delegates per group

Duration: 1 Day
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.

Course Outline

  • Databases
  • 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
  • Find 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)
  • PivotTable 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
  • 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 Information

Click on the button to download

Course Schedule

View the available course dates

Contact Us

Contact Us now to find out more…