Microsoft Excel Pivot Tables - In-Depth Excel Training

Learn How To Manipulate Your Excel Data With Pivot Tables. An Essential Course For All Excel Users

Microsoft Excel Pivot Tables - In-Depth Excel Training
Microsoft Excel Pivot Tables - In-Depth Excel Training

Microsoft Excel Pivot Tables - In-Depth Excel Training udemy course

Learn How To Manipulate Your Excel Data With Pivot Tables. An Essential Course For All Excel Users

What you'll learn:

  • Become an Excel & Pivot Table ADVANCED user within HOURS which will get noticed by top management & prospective employers!
  • Personal Excel support from a Professional Excel Trainer with 15+ Years of Excel Training!
  • Learn Pivot Tables, Slicers, PivotCharts, Filtering, Grouping, Sorting, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting plus MORE!
  • Access 220+ HD quality tutorials with DOWNLOADABLE Excel workbooks!
  • Access 16 Finance & Accounting real world Case Studies PLUS learn the NEW Excel 2013 & 2016 Pivot Table features!
  • Get LIFETIME access & Quizzes to test the skills learned!

Requirements:

  • Excel for Windows 2007, 2010, 2013, 2016, 2019 and Excel for Mac 2011 and 2016.
  • Some concepts are not available in Excel for Windows 2007 and Excel for Mac 2011, like Slicers and some Pivot table calculations, but this is highlighted in the Course Outline
  • This course was recorded using Excel for Windows 2010, 2013 & 2016.

Description:

This Microsoft Excel – Pivot Tables training course from Infinite Skills teaches you everything you need to know about pivot tables, one of the most powerful features in Excel. This course is designed for users that already have a basic understanding of Excel.


You will start out by learning the basics of pivot tables, such as how to prepare your data, creating manual pivot tables, and using pivot table tools. You will then learn how to manage pivot table data, including understanding and working with the pivot cache, working with the data source, and pivoting data in a pivot table. This course will show you how to properly format pivot tables, teaching you how to apply basic formatting, rename pivot table fields, and format numbers. Finally, this video tutorial will cover topics such as how to sort and filter pivot tables, manipulate calculations, and visualize table data with charts.

Once you have completed this video based training course, you will be comfortable with creating pivot tables using a variety of different methods and manipulating their structure and functionality. Working files are included, allowing you to follow along with the author throughout the lessons. Microsoft Excel Pivot Tables - In-Depth Excel Training Udemy

Who this course is for:

Course Details:

  • 4 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Microsoft Excel Pivot Tables - In-Depth Excel Training udemy free download

Learn How To Manipulate Your Excel Data With Pivot Tables. An Essential Course For All Excel Users

Demo Link: https://www.udemy.com/course/microsoft-excel-pivot-tables-in-depth/