🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
5 Students

Description

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

Requirements

  • A computer
  • MS Excel (any version)
  • NFT Certificate
  • 31 Lessons
  • Beginner
  • English
  • 4.8 Rating
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 5h 35min of content, in total.

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

About the Instructor

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.

See All Instructor Courses

BitDegree platform reviews