Learn Pivot Table from basics



Advertisements   
   

 

What you’ll learn

  • Data analysis using Pivot Table

  • Excel Skills for Business

  • Microsoft Excel for Business Data Analysis

Requirements

  • Interest to learn MS-Excel, Data Analytics, Business Data Analysis

Present day organizations are flooded with data. They source data from multiple facets. All these data are churned as a part of business intelligence or data analytics to derive meaningful information. The information is used to make successful business decisions.

In this context, there is a great opportunity waiting for data analysts or data scientists. Organizations are in continuous search to identify and hire data analysts who can churn legions of data in few minutes or hours. Ask Google or Job portals, you will find plethora of openings. Join this course and get one.

The course Data Analytics using PivotTable is designed to make you grab Data Analyst / Data Scientist – The Sexiest job of 21st century.

PivotTable reports are widely used to sort, summarize, group, filter, and analyze data at various level. This course contains 30+ video classes that explain you the nuances PivotTable reports from basics to advanced level. All these video classes are prepared using real time business data.

To augment your learning, related excel workbooks are included.

Why wait, join the course, hone your analytical skills, grab a job / upgrade to next position in your organization.

During your online learning process, if you come across with any questions, suggestions, feedback or review, please do contact the course Instructor.

Read more course:  Nmap Network Security Scanning Basics %26 Advanced Techniques

Who this course is for:

  • Beginner with interest in data analysis
  • Professionals working on large databases
  • HR executives
  • Marketing Research Team Members
  • Financial Analysts
  • Students
  • Standard Rules for Organizing Source Data

    01:10

  • Activating Classic PivotTable Layout

    01:44

  • Introduction to PivotTable Report

    02:42

  • Multiple ways to create PivotTable

    01:50

  • One Dimensional PivotTable

    01:14

  • Two Dimensional PivotTable

    01:51

  • Three Dimensional PivotTable

    01:38

  • Displaying Pages on Separate Worksheets

    02:28

  • Updating PivotTable using Refresh Option

    01:50

  • Updating PivotTable to include new rows

    01:56

  • Hiding and Showing Summary Values

    01:58

  • Changing Summary Statistics

    01:50

  • Changing the Relationship of Summarized Data

    03:04

  • Options Available in Show Values As

    02:16

  • Sorting Data in PivotTable

    01:43

  • Grouping Data in PivotTable

    01:53

  • How to Create Calculated Field in PivotTable

    03:54

  • How to Filter PivotTable Data Manually

    03:50

  • Creating PivotTable Label Filters

    03:50

  • How to Create PivotTable Value Filters

    02:27

  • How to create PivotTable Date Filters

    03:00

  • How to Create Multiple Filters

    03:42

  • What next after Creating a PivotTable

    03:01

  • Turnoff GETPIVOTDATA to activate PivotTable Cell Reference

    04:36

  • Creating PivotChart on PivotTable Report

    03:09

  • Create PivotTable and PivotChart together

    03:01

  • Calculate Multiple Descriptive, Layout Design, and Print report in Separate Pag

    03:28

Professor of Finance, AACSB accredited Business School, Hyd

Currently I am working as Professor of Finance in one of the India’s leading business school accredited by AACSB, a constituent of NAAC A+ Grade Private University located in Hyderabad, Telangana, India. I teach courses like Security Analysis and Portfolio Management, Investments, Financial Management, Corporate Finance, Accounting, and Financial Statement Analysis.

Learn Pivot Table from basics, Free Tutorials Download

Download Learn Pivot Table from basics Free Tutorials Direct Links

Go to Download Tutorials Page Go to HomePage Tutorials

Password : freetuts.download


Advertisements

Related Courses

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.