MS Excel Pivot tables & Charts for Beginners

MS Excel Pivot tables & Charts for Beginners

MS Excel Pivot tables & Charts for Beginners

Learn how to use Pivot tables for creating reports.

Language: english

Note: 0/5 (0 notes) 31 students  New course 

Instructor(s): Raghvan Bhattacharya

Last update: 2022-09-25

What you’ll learn

  • Charts
  • Pivots
  • How to Create Pivots
  • Create Reports From Pivots

 

Requirements

  • Basic Mathematics

 

Description

WHO’S THIS FOR?

This course is designed specifically for Beginners.

MS Excel

Excel is flexible and versatile tool for data analysis, data cleaning and data visualization. It is up to person imagination and creativity to capture utilization potential of Excel can offer. Flexibility means you can represent or format data as per your need and can do same task in more than one way.

Advantages of Excel

  1. Excel helps to analyze data. Today companies have large data. It becomes easy to analyze and interpret large with the help of excel.

  2. It helps to know the trend in the data with the help of charts, graphs, 3-D images, etc.

  3. Excel helps in bringing data together. It is possible to import files and documents in excel.

  4. We can work with others simultaneously with the help of an excel web app.

  5. It helps to store data, do calculations, organize, and format the cells.

  6. Excel file is secured with a password, therefore, security is assured.

Disadvantages of Excel

  1. Can’t handle large amounts of data.

  2. File hanging, Corrupting issue if size is large.

  3. Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.

My Opinion on Excel

Excel will always be a heart of organization. we have Tableau, Power BI tools which are becoming the backbone of Industry but Excel will always be a Part of the the industry. we can’t ignore it.


COURSE STRUCTURE

Excel Charts

Pivots Tables

Reports

Pivot Charts



 

Who this course is for

  • Freshers or Absolute Beginners

 

Course content

  • Excel Charts
    • Intro
    • Session1.1
    • Session1.2
  • Pivot Tables
    • Session2
  • Reports Creation Using Pivots
    • Session3
    • Session4
    • Session5
    • Session6
  • Pivot Charts
    • Session7
    • Session 8
    • Session 9
    • Session 10
    • Session 11

 

Time remaining or 976 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate