We are back offering face to face training and consulting
Contact
1300 339 610
  • Professional Development
    • Assertiveness Techniques
    • Communication Skills
    • Customer Service
    • Difficult Conversations
    • Influencing Skills
    • Manage Stress & Build Resilience
    • Negotiation Skills
    • Presentation Skills
    • Presenting with PowerPoint
    • How to Prioritise
    • Planning & Problem Solving Skills
    • Taming the Email Monster
    • Time Management
  • Microsoft Office
    • Microsoft Access
      • Microsoft Access Introduction
      • Access Queries and Reports training
      • Microsoft Access Advanced
    • Microsoft Excel
      • Microsoft Excel Introduction training
      • Microsoft Excel Intermediate training
      • Microsoft Excel Advanced training
      • Microsoft Excel Formulas and Functions training
      • Microsoft Excel Databases and Pivot Tables training
    • Microsoft Outlook
    • Microsoft PowerPoint
      • Microsoft PowerPoint Introduction training
      • Microsoft PowerPoint Advanced training
    • Microsoft Project
      • Microsoft Project Introduction training
      • Microsoft Project Advanced training
    • Microsoft Word
      • Microsoft Word Introduction training
      • Microsoft Word Intermediate training
      • Microsoft Word Advanced training
  • Adobe CC
    • Adobe InDesign
    • Adobe PhotoShop
Home / Microsoft / Excel / Excel – Databases and Pivot Tables
excel training courses

Excel – Databases and Pivot Tables

$220.00 (GST Incl)

This bite sized, 2 hour topic driven online course is designed for people who need to know how to manage lists and databases and create Pivot Tables in Microsoft Excel.

  • Description

Description

The following topics will be covered:

Rules for Creating a Database

  • Elements of a Database
  • Create an Excel Database
  • 7 rules for setting up an Excel database
  • Modifying the Database Structure

Excel Tables

  • Creating a table from a list
  • Formatting a table

Sorting

  • 2 click sorting
  • Multiple column sorting
  • Sort by colours
  • Sort by cell icon

Pivot Charts

  • Create a Pivot Chart
  • Format Pivot Charts

Filters

  • Understanding filters
  • Turn on auto filter
  • Filter text fields
  • Filter number fields
  • Filter date fields
  • Filter by colour
  • Filter by cell icon
  • Select filtered data
  • Totals and filters
  • Multiple field filters
  • Advanced filter
  • Remove filters

Pivot Tables

  • What is a Pivot Table
  • Understand how PivotTables summarise data
  • Create a PivotTable
  • Pivot Table layout options
  • Change designs
  • Sort and filter a PivotTable
  • Refresh a PivotTable
  • Change the data source
  • Group data by row labels
  • Format numbers within a Pivot Table
  • Create calculated fields

Related products

  • excel training melbourne
    Excel , Microsoft

    Excel – Advanced Formulas and Functions

    This bite sized, 2 hour topic driven online course is designed for people who need to know how to use the more advanced formulas and functions in Microsoft Excel.

    $220.00 (GST Incl)

  • excel training melbourne
    Excel , Microsoft

    Excel – Intro Formulas and Functions

    This bite sized, 2 hour topic driven online course is designed for people who need to know how to use basic formulas and functions in Microsoft Excel.

    $220.00 (GST Incl)

Contact Us

Send us an Email
1300 339 610

StressLess Learning
11 Lowther Street,
Alphington VIC 3078

Our Company
  • About Us
  • Testimonials
  • FAQ
  • Blog
Quicklinks
  • Microsoft Excel Courses
  • Microsoft Project Courses
  • Managing Email Effectively
  • Adobe InDesign Courses
© 2021 StressLess Learning. All Rights Reserved.