Microsoft Excel Beginner to Advanced

In this course you will get the complete know how on how you can use excel in your personal and professional life. and succeed in your job, freelancing career, business

Beginner 4(131 Ratings) 12209 Students enrolled Hindi
Created by leah jain
Last updated Tue, 08-Mar-2022
+ View more
Course overview

What will i learn?

  • You Will Learn Excel Formulas
  • Complex calculations in Excel
  • Will Be Able to use excel in your projects
  • Learn Making calculators in excel
  • tough features of excel like V-loopup, macros
  • You will learn pivot tables, flow charts, dashboards etc.
Requirements
  • Basic Knowledge of Computers
  • Intent to Learn
Curriculum for this course
152 Lessons 15:12:37 Hours
Section 1
1 Lessons 00:03:56 Hours
  • Microsoft Excel Course Day 1
    00:03:56
Section 2
9 Lessons 00:19:08 Hours
  • 2 Launching Excel (Resources)
    00:00:56
  • 3 Microsoft Excel Startup Screen
    00:01:24
  • 4 Introduction to the Excel Interface
    00:04:22
  • 5 Customizing the Excel Quick Access Toolbar
    00:02:11
  • 6 More on The Excel Interface
    00:01:42
  • 7 Understanding the structure of an excel Workbook
    00:02:47
  • 8 saving an excel document
    00:03:15
  • 9 opening a document
    00:01:35
  • 10 Common Excel Shortcut Keys (Resources)
    00:00:56
Section 3
7 Lessons 00:46:44 Hours
  • 11 Entering text to create spreadsheets tiltles
    00:04:55
  • 12 Working with Numeric Data In Excel
    00:06:08
  • 13 Entering the Date Values In Excel
    00:04:20
  • 14 Working with Cell Refrences
    00:05:06
  • 15 Creating Basic Formulas In Excel
    00:08:22
  • 16 Relative Versus Absolute Cell Refrence In Formulas
    00:11:30
  • 17 Understanding the Order of Operation (Resources)
    00:06:23
Section 4
9 Lessons 00:39:37 Hours
  • 18 The structure of an excel function (Resources)
    00:08:11
  • 19 Working with the Sum() Function
    00:04:21
  • 20 working with the MIN() and MAX() Function
    00:04:50
  • 21 Working with average() Function
    00:03:05
  • 22 Working with the count() Function
    00:03:04
  • 23 Adjacent cells error in Excel calculation
    00:05:08
  • 24 Using the Autosum Command
    00:04:21
  • 25 Excel's Autosum Shortcut key
    00:02:35
  • 26 Using the Autofill Command to copy formulas
    00:04:02
Section 5
7 Lessons 00:33:35 Hours
  • 27 Moving and copying the date in excel worksheet
    00:06:07
  • 28 Inserting and deleting the rows and columns
    00:06:23
  • 29 Changing the width and the height of the cells
    00:05:45
  • 30 hiding and unhiding excel rows and columns
    00:04:48
  • 31 Renaming an excel worksheet
    00:02:20
  • 32 Deleting an excel worksheet
    00:03:52
  • 33 Moving and copying an excel worksheet
    00:04:20
Section 6
8 Lessons 00:42:03 Hours
  • 34 Working with font formatting commands
    00:06:00
  • 35 Changing the background color of cells
    00:05:39
  • 36 Adding borders to cells
    00:05:41
  • 37 Formatting data as currency values
    00:05:34
  • 38 Formatting percentages and using the format painter
    00:03:56
  • 39 Creating Styles to format Data
    00:07:20
  • 40 Merging and centering the cells
    00:03:48
  • 41 Using Conditional Formatting
    00:04:05
Section 7
3 Lessons 00:20:42 Hours
  • 42 Inserting Images
    00:05:26
  • 43 Inserting and formatting excel shapes
    00:07:03
  • 44 working with excel SmartArt
    00:08:13
Section 8
4 Lessons 00:27:23 Hours
  • 45 Creating an Excel column Chart
    00:05:34
  • 46 working with the excel chart ribbon
    00:05:28
  • 47 Adding , Modifying and Formatting the Excel chart
    00:08:16
  • 48 Moving the chart and working with Excels pie chart
    00:08:05
Section 9
3 Lessons 00:21:23 Hours
  • 49 Viewing and changing the margins, scaling and orientation in print preview
    00:07:57
  • 50 working with the page layout view
    00:05:01
  • 51 Adding Header & Footer and Printing specific range of cells
    00:08:25
Section 10
2 Lessons 00:14:48 Hours
  • 52 Opening the In-built Templetes
    00:08:02
  • 53 Creating a Custom Template
    00:06:46
Section 11
7 Lessons 00:45:51 Hours
  • 54 Understanding Excel List Structure (Resources)
    00:07:17
  • 55 Sorting a list using single level sort
    00:06:10
  • 56 Sorting a list using Multi level sort
    00:04:41
  • 57 Using Custom Sort In an Excel List
    00:05:38
  • 58 Filter an Excel List Using the Autofilter Tool
    00:05:06
  • 59 Creating subtotals in List
    00:07:24
  • 60 Format a list as a table
    00:09:35
Section 12
5 Lessons 00:48:09 Hours
  • 61 Finding and Removing the duplicates
    00:09:03
  • 62 working with DSUM() Function single criteria
    00:11:23
  • 63 Excel function with OR and AND criteria
    00:06:59
  • 64 Excel Function DAVERAGE and DCOUNT
    00:11:54
  • 65 Excel Function SUBTOTAL
    00:08:50
Section 13
3 Lessons 00:26:25 Hours
  • 66 Understanding and Creating the Excel Data Validation
    00:12:11
  • 67 Decimal and adding a custom data validation
    00:08:34
  • 68 Dynamic Formulas by using excel data validation Techniques
    00:05:40
Section 14
3 Lessons 00:18:15 Hours
  • 69 Importing data from text files
    00:08:40
  • 70 Importing Data from Microsoft Access
    00:04:54
  • 71 Exporting data to a text file
    00:04:41
Section 15
7 Lessons 00:43:27 Hours
  • 72 Understanding and Creating the Excel Pivot table
    00:09:07
  • 73 Modifying Pivot table Calculations
    00:06:37
  • 74 Grouping Pivot table
    00:05:44
  • 75 Formatting the Pivot Table Data
    00:06:01
  • 76 Drilling down into pivot table data
    00:03:59
  • 77 Creating Pivot charts
    00:05:27
  • 78 Filtering the Pivot table manually and with Slicer tool
    00:06:32
Section 16
3 Lessons 00:19:35 Hours
  • 79 Understanding Power Pivot and creating data models
    00:07:21
  • 80 Creating Pivot Table and calculations
    00:06:47
  • 81 power Pivot KPIs
    00:05:27
Section 17
5 Lessons 00:27:30 Hours
  • 82 Using the Freeze Panes Tool
    00:05:32
  • 83 Grouping Data (Columns and or rows)
    00:04:25
  • 84 print options for large sets of data
    00:07:52
  • 85 using 3D formulas & Consolidating data from multiple sheets
    00:08:12
  • 86 Congratulations and Introduction of course 103 (Resources)
    00:01:29
Section 18
7 Lessons 00:58:30 Hours
  • 87 working with excel Name Ranges
    00:06:24
  • 88 Advantages & disadvantages and Editing of name ranges
    00:06:44
  • 89 Using IF() Function
    00:09:59
  • 90 Nesting function with Excel
    00:12:58
  • 91 Nesting Excel's AND() Function within IF() Function
    00:06:11
  • 92 Using excel's COUNTIF() and SUMIF() Function
    00:11:00
  • 93 Using IFERROR() Function
    00:05:14
Section 19
7 Lessons 01:00:53 Hours
  • 94 using the VLOOKUP() Function
    00:14:37
  • 95 Using HLOOKUP() Function
    00:06:51
  • 96 Using INDEX() Function
    00:08:32
  • 97 Using Match() Function
    00:05:38
  • 98 Combining MATCH() & INDEX() Function
    00:07:13
  • 99 Continuing Combined MATCH() & INDEX() Function
    00:11:27
  • 100 working with HLOOKUP() 7 MATCH() Function together
    00:06:35
Section 20
3 Lessons 00:27:39 Hours
  • 101 using excel's LEFT(), RIGHT() & MID() function
    00:06:10
  • 102 working with excel's LEN() & SEARCH() Function
    00:17:51
  • 103 using CONCATENATE() Function
    00:03:38
Section 21
3 Lessons 00:12:20 Hours
  • 104 tracing Precedents and dependents in excel formulas
    00:05:09
  • 105 Working with the Watch window
    00:04:04
  • 106 Showing formulas
    00:03:07
Section 22
2 Lessons 00:12:36 Hours
  • 107 protectiong Specific cells in a worksheet
    00:06:45
  • 108 Protecting the structure and the whole workbook
    00:05:51
Section 23
4 Lessons 00:31:03 Hours
  • 109 Working with Goal Seek Function
    00:07:29
  • 110 Working with Solver Tool
    00:11:23
  • 111 Building effective Data Tables
    00:04:33
  • 112 Creating Scenarios
    00:07:38
Section 24
4 Lessons 00:23:17 Hours
  • 113 Understanding the Macros and activationg the developer Tab
    00:04:46
  • 114 Creating a Macro with the Macro Recorder
    00:08:16
  • 115 Editing a macro with VBA
    00:03:57
  • 116 Running Macro with diffrent Types
    00:06:18
Section 25
7 Lessons 00:37:15 Hours
  • Lesson 117 (Resources)
    00:03:37
  • Lesson 118
    00:02:30
  • Lesson 119
    00:05:02
  • Lesson 120
    00:04:29
  • Lesson 121
    00:06:13
  • Lesson 122
    00:06:31
  • Lesson 123
    00:08:53
Section 26
4 Lessons 00:23:01 Hours
  • Lesson 124
    00:03:38
  • Lesson 125
    00:06:05
  • Lesson 126
    00:08:25
  • Lesson 127
    00:04:53
Section 27
5 Lessons 00:15:13 Hours
  • Lesson 128
    00:02:43
  • Lesson 129
    00:02:28
  • Lesson 130
    00:03:43
  • Lesson 131
    00:03:21
  • Lesson 132
    00:02:58
Section 28
3 Lessons 00:16:20 Hours
  • Lesson 133
    00:01:36
  • Lesson 134
    00:07:39
  • Lesson 135
    00:07:05
Section 29
4 Lessons 00:25:05 Hours
  • Lesson 136
    00:01:26
  • Lesson 137
    00:05:56
  • Lesson 138
    00:14:17
  • Lesson 139
    00:03:26
Section 30
7 Lessons 00:33:58 Hours
  • Lesson 140
    00:01:28
  • Lesson 141
    00:05:29
  • Lesson 142
    00:04:29
  • Lesson 143
    00:07:54
  • Lesson 144
    00:03:22
  • Lesson 145
    00:05:41
  • Lesson 146
    00:05:35
Section 31
6 Lessons 00:36:56 Hours
  • Lesson 147 (Resources)
    00:01:24
  • Lesson 148
    00:09:28
  • Lesson 149
    00:06:29
  • Lesson 150
    00:08:13
  • Lesson 151
    00:08:13
  • Lesson 152
    00:03:09
+ View more
Other related courses
16:53:24 Hours
Website designing course beginner to advanced
Updated Wed, 09-Mar-2022
4 19139 ₹ 6000 ₹ 599
27:14:59 Hours
100 Days Digital Marketing Course [14 Modules]
Updated Tue, 08-Mar-2022
4 5671 ₹ 10000 ₹ 999
15:21:28 Hours
Google Ads Beginner to Advanced
Updated Tue, 08-Mar-2022
0 200 ₹ 10000 ₹ 499
About instructor

leah jain

131 Reviews | 10328 Students | 2 Courses
Student feedback
4
131 Reviews
  • (33)
  • (1)
  • (8)
  • (22)
  • (67)

Reviews

  • Darpi
  • Shailendra kumar jha
  • Rajni Ganesh Bokde
  • Sk Abdulla
  • Jitendra Kumar
    Superb ✍️✍️✍️❤️❤️❤️
  • Sonali bansal
  • vikram Singh dagur
    help ka option nhi aur discretion box me ki link nhi and ye courses paid h whatsup no de hi sakte ho
  • Prashant Gajjar
  • MANI RATNAM
  • Ankit kumar kushwaha
    many features/functions of excel not explained.
  • Deepak Sehgal
    I am unable to view any video.....only introduction video is running. Pls help 9999577709
  • Abhinay
  • Manoj Yadav
    Best app for online
  • Virendra singh
  • Rewa
    It's not working.
  • Venkatesh
  • Prakash Swain
    Very good techniques
  • Kintav Chauhan
    Plz give some comments coloum for doubts ...
  • Mithun Paswan
  • Hemant kumar
    It is best course
  • Ram Naresh Kumar
  • Rima Sinha
  • Tarun yadav
    3
  • Deependra Lodhi
  • Moni
    Very happy with Guru School.Easy to understand. I just love my course trainer way to talking and her English
  • DASHARATH KAMBLE
    Where your course video how to open
  • Pramod
  • Jagadeesh
    Worst coaching Unable to view my classes
  • atul shinde
  • Jemish
  • Tejashri Kamble
  • VIKRAM SINGH RANA
    Thank you Mam For give me knowledge About Basic to advance level of Excel. All Videos Are Good and every points learn step by step
  • Sanjay Mourya
  • Afzal Hussain jishan
  • Koshik sevak
  • Gurdeep Singh
    Awsome????
  • Ankit Kumar
    it's very easy to learn . it is very good course.
  • Himansh sharma
    5 out of 5
  • sumit Kumar
    Nice
  • Saloni Shital Khandelwal
  • Bharat Sharma
  • Sanjay saini
    Nice course and traning also good
  • Mitali Mahale
    It was ok.ok course One advice to tutor please use neutral accent What about sections 24 & 25???
  • Dilip katiyar
  • DILIP JAYRAM KHAIRNAR
  • RAHUL KHAREEDULA
  • Ravi Narayan Mahapatra
    Thank You So Much Medam
  • Abhishek Pandey
  • Alamsaheb Dhabbu
    Best online class
  • CHIRAG ALAM
    Very Helpful and easy to learn. Iam glad to learn MS EXCEL course. Thank you Guruskool ❤️... Guruskool is the best online learning website I love it
  • SACHIN PANDIT RAGATE
    GOOD COURSE
  • Jagdish Rathod
    5
  • aditya bisht
  • Mandeep Kaur
  • Manish Pujari
  • Sheetal Ganatra
    5
  • Satya Prakash Parida
  • NOORUL HASSAN
  • Partha Sarathi Singha
    i would love to say that this website is superb and awesome i love it
  • Purushotam lal
    Good
  • RAHUL
  • laxman
    presentation super medam
  • Amol Fupate
    awesome....
  • Roshan gupta
  • Snehal Shrikrushna Gavhale
  • Udbhav Jain
  • MD Adil
  • shivani sharma
    very nice, and easy to understand,
  • Rishabh Sarkar
  • Jubeen kalita
    Amezing
  • ravindra gupta
  • Sathish Kumar S
    5 stars
  • Arjun tomar
  • Meenakshi Sharma
  • Deepa
    Course is very easy to understand and informative
  • Mahesh Hegde
  • vinod parsad
  • Jignesh
    Moderate Knowledge which is necessary for beginners. Video Quality is very good
  • Virendra pandey
  • Junaid
    Wonderful. Worth the money invested. u won't find such info at such low price
  • Navanath Manjare
  • Saroj Kumar Patra
  • Smriti Srivastava
  • Harish Chandra Behera
    most useful video
  • MULLEVA KAVITHA CHOUDHARY
  • Sunil Kumar
    Best for learning Excel app
  • Shrutika Thakur
    Videos are not opening
  • priyasmita kundu
    thank you for solving my problem
  • Karan Bhargava
  • Shweta kaushik
  • SHUBHAM GARG
  • Vaishnavi sadiwal
  • Harsh Shah
    Method of teaching is great and each concept covered was easy to understand.
  • SONU PAL
  • Rahul Kumar
  • Parjeet
  • Tarvinder Singh
  • malay sarkar
    nice
  • Akash kumar
    superb experience
  • Yuvraj Grover
    It helps me a lot even from doing virtually
  • Divyansh Agarwal
  • Yogeshwari
  • Trupti Sankpal
    Whenever I'm opening these lessons every time only intro is showing...now am thinking there is nothing anything except intro
  • A PRAVEEN
    In 4th Sections last video intstructor said about Quiz. Please suggest where will i get that.
  • Mrinal Kanti Roy
    It's helpful for me
  • Raghu ram v
    super
  • Poojasonkar
  • Suresh sharma
  • Sanjeet Agrawal
  • NAZRUL
    Unable to watch videos.Its freezed Pls fix the problem
  • Swati rawat
  • Ashish Ramesh Bolke
  • Risha Yadav
  • KalyanKumar
  • Saswoti Rout
  • khileshwar
    कृपया हिंदी में बताए
  • DEEPAK SHARMA
    Waste of money becouse .Its ways to define is so poor
  • Tanisha kumari
    Very good course for those who wants to learn excel , easy to understand
  • Jaiprabha Jadhav
    This course is very helpful and is explained very well.Many of my doubts got sorted due to this course
  • Sachin
    this is amazing course of before when i get this course i no that how to oprate excel even we don' have any knowldge but when i got this course litery it was amazing course this course is change my life and i directly become accountant as well as high level post everyone saying you are amazing of excel where you are learn this course i recomnd that guruskool.in everyone must by this course your life is chaniging
  • Aman
    4 ratings kaati hai maine mam ki overacting ki .accent ko theek kariye mam
  • Ashish Vijay Salvi
    Marvelous
  • Mohd Habeeb Musa
    Perfect trainer
  • Umesh G Kalpande
  • AMAN RK JAIN
  • Avinash Waware
    Course is designed very good, but some improvement still there. Thanks for the information given in course
  • Lily Sahu
    Very easy teaching style, short vedio are very helpful to learn the topics.
  • Aakash
  • Uttam kumar
  • Sushanta Kumar pujari
  • Kamal Sarkar
    great
Preview this course
₹ 10000 ₹ 599
Includes: