Microsoft Excel Pivot Tables Training Course Beginners Birmingham

Birmingham Beginners Microsoft Excel Pivot Tables Course Overview

Birmingham is a city renowned for its vibrant culture and rich industrial heritage. From the Bullring to its iconic museums, Birmingham offers a unique mix of history and modernity. Our Beginners Microsoft Excel Pivot Tables Training Course training is designed to help you unlock the full potential of your software. Whether you're mastering advanced techniques or tackling specific challenges, our courses provide practical, hands-on learning experiences. If Pivot Tables training in Birmingham isn't exactly what you're looking for, explore other computer training courses in Birmingham.

Discover more about Birmingham, including its world-class galleries and cultural landmarks. Our training options are flexible, allowing you to learn at your workplace or in a distraction-free location. For those seeking a peaceful environment, we offer sessions in professional training spaces like Victoria Square or Rednal.

Why Choose Pivot Tables Training in Birmingham?

Birmingham is a hub for innovation and growth, attracting diverse industries and businesses. Our tailored training courses support professionals and organizations looking to enhance their skills and stay competitive. With years of experience delivering IT training in Birmingham, we understand the needs of local businesses and are committed to delivering impactful, high-quality courses.

Course Duration: 1 Day

Complete Course Outline

Pivot Table Formulas

If Function
SUMIF
Flash Fill
VLookup
Index Match Function

Tables

Creating Tables
Using Functions with Tables
Sorting Data in Tables
Adding & Deleting Rows
Converting a Table back to a Range

Pivot Tables

Creating a Pivot Table from existing data in Excel
Formatting Pivot Table Data
Filtering and Sorting Data in Pivot Tables
Dates and Pivot Tables
Slicers and Timelines
Connecting Pivot tables using Slicers
Timelines
Pivot Charts

PowerPivot

Installing PowerPivot
Adding a Table to PowerPivot

Performing Basic DAX calculations

Inserting a column in PowerPivot
Creating a calculated column
Formatting data in columns
Adding data from a text file
Creating relationships
Pivot Tables the PowerPivot way
Date calculations in DAX
Setting a Date Order
Calculated Fields
Year to Date function in DAX
Viewing Sales from previous day
Using a Calendar Table

Although this course is designed with Excel 2013 in mind, the principles used could be applied to 2010 & 2016 as well.

You may also be interested in the following courses:

Or the following training courses may be of interest:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel PowerPivot training course intermediate