Learn how to manage, sort and filter data by creating databases and Pivot Tables with our Microsoft Excel Databases and Pivot Tables course.

Contact us to book now

Learn how to manage, sort and filter data by creating databases and Pivot Tables with our Microsoft Excel Databases and Pivot Tables course.

Contact us to book now

What you'll learn in our Microsoft EXCEL Databases and pivot tables course

At the end of the Microsoft Excel Databases and Pivot Tables course participants will be able to:

  • Create databases in Microsoft Excel
  • Do’s and Do nots of creating databases in Excel
  • Perform calculations on data by using functions and formulas
  • Sort and Filter a database in Excel
  • Work with Pivot Tables and Sub Totals to generate calculations

Who is the course for?

This Microsoft Excel Databases and Pivot Tables course is designed for those who need to know how to develop databases, filter data and work with Pivot Tables and Pivot Charts.

We customise all course content & duration to suit

Course duration

StressLess Learning works in partnership with clients to customise and refine all course content and duration to suit both organisational goals and individual learners requirements. All course outlines are therefore to be used as a guide only.

Download PDF Course Outline

pdf download

Microsoft Excel databases and pivot tables training topics

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

Database Tools

  • Sorting
  • 2 click Sorting
  • Custom Sorting
  • Filtering in Excel
  • Calculations for Filtered Lists

Excel Tables

  • Creating a table from a list
  • Formatting a table
  • Referring to tables in external formulas

Calculating your Data

  • Excel Subtotals
  • Subtotal tricks
  • Tables and subtotals
  • Charts

Formatting

  • Format text
  • Format milestones
  • Format Gantt bars
  • Format Gantt bar text
  • Gridlines

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

Pivot Charts

  • Create a Pivot Chart
  • Format Pivot Charts

More Courses

You might also be interested in these courses

MS Office Courses

  • Improve your skills in Microsoft Office and Office 365. Beginner to advanced Microsoft courses in the full Office suite including: Excel, Word, Outlook, PowerPoint, Project, Access, SharePoint and Teams.
  • microsoft office training courses melbourne
Course Outline

Project Courses

  • Learn advanced features of Microsoft Project. Create custom tables, views and reports, allocate and manage and share resources and automate project functionality using macros.
  • microsoft project training melbourne
Course Outline

Word Courses

  • Use Microsoft Word to create professional looking documentation including letters, reports, and newsletters. Microsoft Word can also be used to transform documents to webpages.
  • microsoft word training courses melbourne
Course Outline

What people say

4.7 out of 5
4.6/5
5 out of 5
5/5
Despite the topic (Excel), Ian kept the course engaging all day. A very satisfying Excel course. Thanks Ian
Stefan
2016
5 out of 5
5/5
Great course, entertaining plus informative. Thank you, I now have more confidence to practice informative spreadsheets and know how to manipulate and manage data in Excel.
Cindy
2019
5 out of 5
5/5
Facilitator was very enthusiastic and had an awesome knowledge of Excel. There was no question she couldn't answer. Made the day fun and engaging.
Cass
2019
4.5 out of 5
4.5/5
Great Excel training. Ian covered all my learning gaps to become proficient in the use of Excel especially with lists and formatting. Very engaging trainer, thanks Ian! Money and time well spent.
Nick
2018
4 out of 5
4/5
The demonstrations were clear and the Excel examples were practical.
Simon
2017
5 out of 5
5/5
Ian made the Excel training course quite entertaining and made the learning fun, whereas I have always found it tricky in the past.
Hannah
2019
5 out of 5
5/5
Good energy and enthusiastic as well as very knowledgeable. Thanks Mark.
Arjun
2018
5 out of 5
5/5
Ian has a great knowledge of Excel and has taught useful tips to use back in the workplace
Chanae
2019
5 out of 5
5/5
Great facilities, informative content and knowledgeable trainer with impressive delivery. Great Excel course, highly recommend. A++
Nicole
2019

Trusted by

2Construct