Tel:020 7920 9500
Microsoft Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction..
For more demanding uses, Excel can be used to create charts, Analyse Data, used as a data repository and of course keep track of your accounts.
Benefit From our Smart Training
Excel Pivot Tables Training Course Overview
Our Excel Pivot Tables training course is recommenced for all Excel users who need an overview of the power of Pivot Tables.
Pivot Tables are one of Excel’s most popular and powerful features and give you the ability to analyse and report on raw data with ease.
Excel Introduction Training Course Five Core Topics
- Pivot Table source data
- The various types of Pivot Table calculations
- Filtering and sorting data
- Slicers and Timelines
- Using Conditional Formatting on Pivot Tables
Excel Pivot Table Training Course Details
Course Location : Face to face group / Online & Onsite training available.
Class Size : As a guide we recommend class sizes to be no more than six.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our Excel Introduction Training Course can be tailored to your requirements
Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.
- Guidelines for creating source data: ranges or tables?
- Creating a simple Pivot Table
- Rearranging fields
- Show Details
- Refreshing Pivot Tables
- Changing the source data
- Connection to External data sources
- Unpivoting the source data
- Changing the Summary Function for a value field
- Adding Fields to Values Area
- Multiple Subtotal calculations
- Grouping data; Numbers, Dates and Times
- Adding Calculated Fields and Items
- Show Values As to calculate percentages and comparatives
- Distinct Count calculations
- Dealing with GETPIVOTDATA
- Formatting Pivot Tables with Styles
- Formatting the numbers
- Sorting A-Z, Z-A, manual and custom sorts
- Multiple Field Filters
- Label and Value Filters
- Top 10 Filter
- Dealing with blank cells
- Show Items with no data
- Replace error values
- Generating reports with Show Report Filter Pages
- Changing the Report layout
- Adding blank rows and displaying totals
- Repeat All Items
- Adding a Slicer and a Timeline
- Connect Slicers to multiple Pivot tables
- Create a Pivot Chart
- Add Data Bars, Icons and Colour Scales
Services
Online or Your Venue
Unlimited access to out online training manuals
Courses delivered by Certified Trainers
Our Trainers
our lead trainers, have many years of delivering training courses from basics to development levels in their chosen field . All our trainers are encouraged to become Microsoft Accredited within their first year of working for us.
Our instructors are very approachable, making the driest subject matter fun.
