Excel Pivot Tables - Crash Course

Simpliv

Course

Online

£ 150 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Why Pivot Tables?Pivot Tables is one of the essential tool available in MS Excel, with which you can perform many tasks. It let's you summarize the data and you can use various operations to find important insights.In this course...You will be able to learn all the basic fundamentals of Pivot Tables for analytics. you will learn how toCreate a Pivot Table
Prepare CrossTabs
Apply Filters
Use Slicers
Use Date Timelines
Apply Value CalculationsSo build your basics strong and start your journey to become a Data Analyst. Enroll in this course now!!!

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Pivot Tables
Microsoft Excel
Data Analytics with Excel
Pivot Table Tools

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Sales Training
  • MS Excel
  • Sales
  • Marketing
  • Excel

Course programme

Course Introduction 1 lecture 03:10 Excel Pivot Tables preview Course Introduction 1 lecture 03:10 Excel Pivot Tables preview Excel Pivot Tables preview Excel Pivot Tables preview Excel Pivot Tables preview Excel Pivot Tables preview Data Insights with Pivot Tables 7 lectures 16:08 Overview About Store Dataset Data Insights Sales Profit Summary preview Highlight the Data Unprofitable Products Create Crosstabs Select Regions for Unprofitable Products Data Insights with Pivot Tables 7 lectures 16:08 Overview About Store Dataset Data Insights Sales Profit Summary preview Highlight the Data Unprofitable Products Create Crosstabs Select Regions for Unprofitable Products Overview About Store Dataset Overview About Store Dataset Overview About Store Dataset Overview About Store Dataset Data Insights Data Insights Data Insights Data Insights Sales Profit Summary preview Sales Profit Summary preview Sales Profit Summary preview Sales Profit Summary preview Highlight the Data Highlight the Data Highlight the Data Highlight the Data Unprofitable Products Unprofitable Products Unprofitable Products Unprofitable Products Create Crosstabs Create Crosstabs Create Crosstabs Create Crosstabs Select Regions for Unprofitable Products Select Regions for Unprofitable Products Select Regions for Unprofitable Products Select Regions for Unprofitable Products Real Time Analytics with Pivot Tables 4 lectures 13:41 Real Time Analytics and Insights Search Data for States with Slicers Finding Trends Find Data for Specific Date Real Time Analytics with Pivot Tables 4 lectures 13:41 Real Time Analytics and Insights Search Data for States with Slicers Finding Trends Find Data for Specific Date Real Time Analytics and Insights Real Time Analytics and Insights Real Time Analytics and Insights Real Time Analytics and Insights Search Data for States with Slicers Search Data for States with Slicers Search Data for States with Slicers Search Data for States with Slicers Finding Trends Finding Trends Finding Trends Finding Trends Find Data for Specific Date Find Data for Specific Date Find Data for Specific Date Find Data for Specific Date Reporting with Pivot Tables 2 lectures 06:01 Reporting Made Easy Generate Reports with Pivot Tables Reporting with Pivot Tables 2 lectures 06:01 Reporting Made Easy Generate Reports with Pivot Tables Reporting Made Easy Reporting Made Easy Reporting Made Easy Reporting Made Easy Generate Reports with Pivot Tables Generate Reports with Pivot Tables Generate Reports with Pivot Tables Generate Reports with Pivot Tables Target your Market with Pivot Table Analysis 2 lectures 07:03 Marketing Analytics Target Your Advertisements Target your Market with Pivot Table Analysis 2 lectures 07:03 Marketing Analytics Target Your Advertisements Marketing Analytics Marketing Analytics Marketing Analytics Marketing Analytics Target Your Advertisements Target Your Advertisements Target Your Advertisements Target Your Advertisements Summary 1 lecture 00:21 Become an Analyst Summary 1 lecture 00:21 Become an Analyst Become an Analyst Become an Analyst Become an Analyst Become an Analyst

Additional information

Basic knowledge about Microsoft Excel

See related categories

Excel Pivot Tables - Crash Course

£ 150 + VAT

The best Excel courses

See all

See all