Excel Data Analysis with Pivot Tables

Excel Live Instructor Led Training and Face to Face In-house Courses Delivered by Expert Excel Trainers
Search Class Dates

Data Analysis with Excel Pivot Tables  

Learn how to use Pivot Tables and Pivot Charts to streamline and revolutionise your workflow in Excel.
xcel courses

Credible

Our live online reviews are proof that you can trust Trainers Direct to deliver

Flexible

Our tailored training workshops are completely flexible to fit in with your busy schedule

Z

Experienced

Our instructors have a minimum of 15 years industry experience and carry relevant vendor qualifications such as Microsoft or Adobe Certified 

Excel Pivot Tables - 3 hrs

Excel Data Analysis with Pivot Tables Course

Take your data analysis skills to the next level with Excel Pivot Tables. 

 

Course prerequisites

Basic experience with Excel functionality (charts & formulas a plus).

Pivot Tables Course Topics

 

  • Why Pivot Tables?
  • Structuring Source Data
  • Creating Your First Pivot Table
  • Navigating and Manipulating the Pivot Table Field List
  • Exploring Pivot Table Analyze & Design Options
  • Selecting, Clearing, Moving & Copying Pivot Tables
  • Refreshing & Updating Pivot Tables
  • Dealing with Growing Source Data
  • Formatting a Table
  • Sorting, Filtering and Grouping Data
  • Filtering using Slicers and Timelines
  • Using Calculated Fields and Values
  • Pivot Charts
  •  

 

 

FIND US

 

Suite 3, 6/49 Frenchs Forest Rd E, NSW2097

02 9454 7702