MS Excel Pivot tables & Charts for Beginners

Focused View

Raghvan Bhattacharya

2:06:51

107 View

1. Excel Charts

1.1 Session1.xlsx

1. Session 1.mp4

36:04

2. Pivot Tables

1.1 Session2.xlsx

1. Session2.mp4

37:12

3. Reports Creation Using Pivots

1.1 Session3.xlsx

1. Session3.mp4

09:27

2.1 Session4.xlsx

2. Session4.mp4

09:27

3.1 Session5.xlsx

3. Session5.mp4

10:36

4.1 Session6.xlsx

4. Session6.mp4

08:25

4. Pivot Charts

1.1 Session7.xlsx

1. Session7.mp4

15:40

Description

Learn how to use Pivot tables for creating reports.

What You'll Learn?

Charts
Pivots
How to Create Pivots
Create Reports From Pivots

Who is this for?

Freshers or Absolute Beginners

What You Need to Know?

Basic Mathematics

More details

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
Excel helps to analyze data. Today companies have large data. It becomes easy to analyze and interpret large with the help of excel.
It helps to know the trend in the data with the help of charts, graphs, 3-D images, etc.
Excel helps in bringing data together. It is possible to import files and documents in excel.
We can work with others simultaneously with the help of an excel web app.
It helps to store data, do calculations, organize, and format the cells.
Excel file is secured with a password, therefore, security is assured.
Disadvantages of Excel
Can't handle large amounts of data.
File hanging, Corrupting issue if size is large.
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

User Reviews

Rating

average 0

Total votes0

Focused display

I am working as a data analyst from last 10 years. My tasks are to Clean the data, Validate the Reports , Create Visuals using Tableau & Excel as per business requirements or s per various Departments in an organization. I have designed this course for the freshers & working Professionals also. Please leave a feedback after completion of the course.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.