Hands-On Advanced Excel Masterclass

Excel Beginners to Advanced. Excel is the most powerful tool to manage and analyze various types of Data. This perfectly designed Excel course will begin with an introduction to Excel and will take you through various features of Excel.

Beginner 0(0 Ratings) 0 Students enrolled English
Created by Handson Hybrid
Last updated Mon, 02-Jan-2023
+ View more
Course overview

Excel is the most powerful tool to manage and analyze various types of Data. This perfectly designed Excel course will begin with an introduction to Excel and will take you through various features of Excel. If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. Grow your career as a Data Analyst through knowing Data Analysis in Excel. Everything that is very important to know like Functions and Formulas, Data Validation, Pivot Table, Power Pivot, VLookup, HLookup, KPI and many more things are discussed in details in this course. This course will help you to make yourself one step ahead of everyone. All the resources are given that will help you to practice.

This course is designed perfectly, from introduction to advanced will be covered through various features of excel. You will get familiarized with Cell Refencing, Table formation, Customizing Cell Style, Border, Formula and Functions, Conditional Statements, Data Sorting, Filtering, Validation.

You will get notion of use Descriptive Statistics through the use of Average, Median, Count, Max, Min functions. An in-depth knowledge of using Chart and Graphs to analyze data, and presenting data through pivot table using of power pivot and KPI.

What will i learn?

  • Introduction of MS Excel
  • Text Functions and Numerical functions
  • Formatting types in Excel
  • Inserting Images, Shapes, Charts and lot more things.
  • Sorting and filtering of data
  • IF Functions
  • Pivot Tables and Charts
  • Conditional and lookup functions
  • IF Function
  • IF Or Function Count if
  • VLOOKUP
  • HLOOKUP
  • INDEX FUNCTION
  • MATCH FUNCTION
  • Precedent and dependent
  • Watch Window
  • Pivot charts
  • Excel Power pivot
  • Key Performance Indicator (KPI)
Requirements
  • Basic computing knowledge
  • No prior knowledge of excel is required
Curriculum for this course
79 Lessons 02:24:15 Hours
Introduction of MS Excel
9 Lessons 00:18:35 Hours
  • Introduction
    00:01:20
  • How to open MS Excel
    00:00:42
  • Starting Excel Screen and Version
    00:02:08
  • Excel sheet details
    00:02:42
  • work sheet vs work book
    00:01:54
  • Customizing Quick Access Toolbar
    00:01:52
  • Customizing Ribbon
    00:03:41
  • Relative cell reference
    00:02:33
  • Absolute cell reference
    00:01:43
Text Functions and Numerical functions
7 Lessons 00:17:56 Hours
  • Upper Lower Proper
    00:01:41
  • Max Min
    00:01:40
  • LEFT MID RIGHT CON TRIM LEN FUNCTION
    00:05:36
  • FIND REPLACE SUBSTITUTE
    00:02:44
  • Exact Rept Search
    00:02:17
  • Average Count CountA CountBlank
    00:02:01
  • Absolute Round Integer Power
    00:01:57
Formatting types in Excel
12 Lessons 00:18:51 Hours
  • Selected Area Moving
    00:01:01
  • Protect Workbook and Worksheet
    00:02:34
  • Insert and Delete
    00:02:21
  • Hide and Unhide Rows & Column
    00:01:15
  • Formatting Data
    00:01:46
  • Format painter
    00:00:54
  • Fill Color
    00:01:23
  • Customizing Cell Styles
    00:02:09
  • Conditional Formatting
    00:01:52
  • Cell Merging
    00:01:22
  • Cell Height Width Adjust
    00:01:14
  • Cell Border
    00:01:00
Inserting Images, Shapes, Charts and lot more things.
4 Lessons 00:07:36 Hours
  • Insert Picture
    00:02:04
  • Insert Shapes and Icon
    00:02:09
  • Inserting Charts
    00:02:26
  • Printing the Worksheet and Selected Area of the Worksheet
    00:00:57
Sorting and filtering of data
4 Lessons 00:09:09 Hours
  • Sorting and Filtering Data
    00:02:43
  • Filtering
    00:02:13
  • Grand Total and Sub Total
    00:01:56
  • Creating Table
    00:02:17
IF Functions
8 Lessons 00:20:27 Hours
  • Sumif and SumifS functions
    00:03:17
  • Dsum Function
    00:02:36
  • SumifS vs Dsum
    00:01:42
  • Data Validation 1
    00:03:35
  • Date Validation 2
    00:02:49
  • Dynamic Data Validation
    00:01:51
  • Subtotal and Sumtotal
    00:02:29
  • Subtotal Function Number
    00:02:08
Pivot Tables and Charts
9 Lessons 00:23:46 Hours
  • Pivot Table Introduction
    00:03:16
  • How to start Power Pivot
    00:00:57
  • Inserting Data in Pivot Table
    00:02:43
  • Creating Link between two Tables
    00:01:46
  • Customizing Pivot Table
    00:03:40
  • Pivot Table Drill Down
    00:01:45
  • Pivot Chart and Slicer
    00:03:05
  • Pivot Table in Power Pivot
    00:03:26
  • Key Performance Indicator (KPI)
    00:03:08
Conditional and lookup functions
9 Lessons 00:27:55 Hours
  • If Function
    00:02:04
  • IF and, IF or Function
    00:03:47
  • Count If
    00:02:12
  • VLookup
    00:04:11
  • IfError and VLookup
    00:02:02
  • HLookup
    00:04:09
  • Index & Index Match Functions
    00:05:07
  • Precedents and Dependents
    00:02:23
  • Watch Window
    00:02:00
Resources
17 Lessons 00:00:00 Hours
  • Sum, SumIf, DSum, Subtotal
    .
  • HLookUp & VLookUp, Index, Match
    .
  • If Function
    .
  • Key Performance Indicator(KPI)
    .
  • Power Pivot
    .
  • Pivot Slice & Chart
    .
  • Pivot 1
    .
  • Pivot
    .
  • Data Validation
    .
  • Text Functions
    .
  • Table
    .
  • Sub and Grand Total
    .
  • Insert Charts
    .
  • Inset Shape, Icon
    .
  • Customizing cell style
    .
  • Format Painter
    .
  • Numeric Functions
    .
+ View more
Other related courses
About instructor

Handson Hybrid

0 Reviews | 3 Students | 5 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Preview this course
₹4990 ₹499
Includes: