Learn how to manage, sort and filter data by creating databases and Pivot Tables with our Microsoft Excel Databases and Pivot Tables course.
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.
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.
-
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.
-
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.
-
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
