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
Beginner4(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
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.
Write a public review