Overview

**This course includes downloadable course instructor files and exercise files to work with and follow along.**Data analysis is essential in today's data-driven world. Data is crucial in understanding businesses, analyzing trends, and forecasting your business needs. It is crucial that you have the relevant skills to handle and analyze data efficiently.PivotTable is a vital Excel skill for big data analysis and visualization jobs. PivotTables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating datasets, letting you analyze the information in a clear and effective manner.This course will discuss the importance of cleaning your data before creating your first PivotTable. You will also learn how to create PivotCharts and format your PivotTables and charts. We teach you how to make the most of this powerful data analysis tool by using some of its advanced features, including advanced sorting, slicers, timelines, calculated fields, and conditional formatting.This course is aimed at those brand new to PivotTables and also intermediate users looking to expand their Excel skills. You can download the Excel data files that the instructor uses in the tutorials so you can readily follow along.This course covers:Cleaning and preparing your dataHow to create PivotTablesUsing the fields pane and adding fields and calculated fieldsHow to use the value field settingsFormatting numbers in PivotTableDifferent ways to summarize dataGrouping and ungrouping PivotTable data and dealing with errorsUsing multiple fields and dimensionMethods of aggregationChoosing and locking the report layoutHow to format PivotTables and apply stylesBasic to advanced sorting and filteringCreating PivotCharts and adding sparklines and slicersSelecting the right chart to present your dataAdding slicers and timelines and applying them to multiple tablesCombining data from multiple worksheets for a PivotTableAll about the GETPIVOTDATA functionHow to use 3D maps from a PivotTableAdding new data to the original source datasetUpdating your data in a PivotTable and PivotChartUsing conditional formatting in a PivotTableHow to create amazing dashboardsThis course bundle includes:13+ hours of video tutorials100+ individual video lecturesCertificate of completionCourse and exercise files to follow along

Skills

Reviews