watching now
5 Students
31 Lessons
Beginner

What Will You Learn?

  • All the essential Excel formulas
  • Data tools like sorting, filtering, data validations and importing
  • Most popular lookup functions
  • Visual tools, such as bar charts, scatter plots, and histograms

Curriculum

5h 35m
Section 2: Essential Formulas
1:17:06
Basic formula operations
13:10
Mathematical Formulas
19:11
Textual Formulas
17:26
Logical Formulas
11:24
Date-Time Formulas
07:08
Lookup Formulas ( V Lookup, Hlookup, Index-Match )
08:47
Section 3: Data Tools
19:08
Data Tools
19:08
Section 4: Formatting data and tables
18:01
Formatting data and tables
18:01
Section 5: Pivot Tables
08:25
Pivot Tables
08:25
Section 6: Excel Charts
1:50:45
Categories of messages that can be conveyed
04:35
Elements of charts
05:33
The Easy way of creating charts
03:18
Bar and column charts
12:38
Formatting charts
15:13
Line Charts
09:05
Area Charts
06:04
Pie and Doughnut Charts
13:05
Why we should avoid Pie charts
04:06
Scatter plot or XY chart
16:17
Frequency Distribution and Histograms
13:03
Pivot Charts
07:48
Section 7: Excel Shortcuts
12:34
Excel Shortcuts
12:34
Section 8: Macros
10:05
Macros
10:05
Section 9: Advance Excel
15:49
Advance Excel
15:49

Description

Requirements

  • A computer
  • MS Excel (any version)

About the Instructor

Reviews 3
Students 184
Courses 5

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics, and Python.

Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

BitDegree platform reviews

Our students say Excellent
4.5 out of 5
trustpilot logo 1 trustpilot logo