Microsoft Excel Beginner to Advanced Course

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(107 Ratings) 11050 Students enrolled
Created by Guruskool Institute Last updated Wed, 19-May-2021 Hindi
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.

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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 42 Inserting Images 00:05:26
  • 43 Inserting and formatting excel shapes 00:07:03
  • 44 working with excel SmartArt 00:08:13
  • 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
  • 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
  • 52 Opening the In-built Templetes 00:08:02
  • 53 Creating a Custom Template 00:06:46
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 107 protectiong Specific cells in a worksheet 00:06:45
  • 108 Protecting the structure and the whole workbook 00:05:51
  • 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
  • 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
  • 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
  • Lesson 124 00:03:38
  • Lesson 125 00:06:05
  • Lesson 126 00:08:25
  • Lesson 127 00:04:53
  • 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
  • Lesson 133 00:01:36
  • Lesson 134 00:07:39
  • Lesson 135 00:07:05
  • Lesson 136 00:01:26
  • Lesson 137 00:05:56
  • Lesson 138 00:14:17
  • Lesson 139 00:03:26
  • 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
  • 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
Requirements
  • Basic Knowledge of Computers
  • Intent to Learn
+ View more
Description
+ View more
Other related courses
16:53:24 Hours
5 18873 ₹ 6000 ₹ 599
27:14:59 Hours
4 5607 ₹ 10000 ₹ 1499
00:00:00 Hours
0 0 ₹ 10000 ₹ 499
About the instructor
  • 630 Reviews
  • 28296 Students
  • 4 Courses
+ View more
Student feedback
4
Average rating
  • 27%
  • 0%
  • 7%
  • 17%
  • 46%
Reviews
  • Thu, 05-Nov-2020
    Darpi
  • Thu, 05-Nov-2020
    Shailendra kumar jha
  • Fri, 06-Nov-2020
    Rajni Ganesh Bokde
  • Fri, 13-Nov-2020
    Sk Abdulla
  • Thu, 19-Nov-2020
    Jitendra Kumar
    Superb ✍️✍️✍️❤️❤️❤️
  • Sat, 21-Nov-2020
    Sonali bansal
  • Sat, 21-Nov-2020
    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
  • Thu, 26-Nov-2020
    Prashant Gajjar
  • Sat, 28-Nov-2020
    MANI RATNAM
  • Sat, 26-Dec-2020
    Ankit kumar kushwaha
    many features/functions of excel not explained.
  • Tue, 01-Dec-2020
    Deepak Sehgal
    I am unable to view any video.....only introduction video is running. Pls help 9999577709
  • Wed, 02-Dec-2020
    Abhinay
  • Sat, 05-Dec-2020
    Manoj Yadav
    Best app for online
  • Sun, 06-Dec-2020
    Virendra singh
  • Sun, 06-Dec-2020
    Rewa
    It's not working.
  • Sun, 23-May-2021
    Venkatesh
  • Wed, 09-Dec-2020
    Prakash Swain
    Very good techniques
  • Sat, 12-Dec-2020
    Kintav Chauhan
    Plz give some comments coloum for doubts ...
  • Sat, 12-Dec-2020
    Mithun Paswan
  • Mon, 28-Dec-2020
    Hemant kumar
    It is best course
  • Tue, 15-Dec-2020
    Ram Naresh Kumar
  • Sat, 19-Dec-2020
    Rima Sinha
  • Sat, 19-Dec-2020
    Tarun yadav
    3
  • Mon, 21-Dec-2020
    Deependra Lodhi
  • Wed, 23-Dec-2020
    Moni
    Very happy with Guru School.Easy to understand. I just love my course trainer way to talking and her English
  • Thu, 24-Dec-2020
    DASHARATH KAMBLE
    Where your course video how to open
  • Fri, 25-Dec-2020
    Pramod
  • Sun, 10-Jan-2021
    Jagadeesh
    Worst coaching Unable to view my classes
  • Sat, 26-Dec-2020
    atul shinde
  • Sun, 27-Dec-2020
    Jemish
  • Sun, 27-Dec-2020
    Tejashri Kamble
  • Thu, 31-Dec-2020
    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
  • Thu, 31-Dec-2020
    Sanjay Mourya
  • Fri, 01-Jan-2021
    Afzal Hussain jishan
  • Sat, 02-Jan-2021
    Koshik sevak
  • Mon, 04-Jan-2021
    Gurdeep Singh
    Awsome????
  • Wed, 06-Jan-2021
    Ankit Kumar
    it's very easy to learn . it is very good course.
  • Wed, 06-Jan-2021
    Himansh sharma
    5 out of 5
  • Wed, 06-Jan-2021
    sumit Kumar
    Nice
  • Fri, 08-Jan-2021
    Saloni Shital Khandelwal
  • Fri, 08-Jan-2021
    Bharat Sharma
  • Sun, 10-Jan-2021
    Sanjay saini
    Nice course and traning also good
  • Mon, 11-Jan-2021
    Mitali Mahale
    It was ok.ok course One advice to tutor please use neutral accent What about sections 24 & 25???
  • Mon, 11-Jan-2021
    Dilip katiyar
  • Sat, 16-Jan-2021
    DILIP JAYRAM KHAIRNAR
  • Wed, 13-Jan-2021
    RAHUL KHAREEDULA
  • Sun, 17-Jan-2021
    Ravi Narayan Mahapatra
    Thank You So Much Medam
  • Thu, 21-Jan-2021
    Abhishek Pandey
  • Sat, 23-Jan-2021
    Alamsaheb Dhabbu
    Best online class
  • Sun, 31-Jan-2021
    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
  • Thu, 28-Jan-2021
    SACHIN PANDIT RAGATE
    GOOD COURSE
  • Fri, 29-Jan-2021
    Jagdish Rathod
    5
  • Sun, 31-Jan-2021
    aditya bisht
  • Mon, 01-Feb-2021
    Mandeep Kaur
  • Thu, 04-Feb-2021
    Manish Pujari
  • Tue, 23-Mar-2021
    Sheetal Ganatra
    5
  • Fri, 05-Feb-2021
    Satya Prakash Parida
  • Mon, 15-Feb-2021
    NOORUL HASSAN
  • Thu, 18-Feb-2021
    Partha Sarathi Singha
    i would love to say that this website is superb and awesome i love it
  • Tue, 23-Feb-2021
    Purushotam lal
    Good
  • Thu, 25-Feb-2021
    RAHUL
  • Wed, 03-Mar-2021
    laxman
    presentation super medam
  • Thu, 04-Mar-2021
    Amol Fupate
    awesome....
  • Thu, 04-Mar-2021
    Roshan gupta
  • Fri, 05-Mar-2021
    Snehal Shrikrushna Gavhale
  • Fri, 05-Mar-2021
    Udbhav Jain
  • Sun, 07-Mar-2021
    MD Adil
  • Mon, 08-Mar-2021
    shivani sharma
    very nice, and easy to understand,
  • Mon, 08-Mar-2021
    Rishabh Sarkar
  • Wed, 10-Mar-2021
    Jubeen kalita
    Amezing
  • Wed, 10-Mar-2021
    ravindra gupta
  • Tue, 16-Mar-2021
    Sathish Kumar S
    5 stars
  • Wed, 17-Mar-2021
    Arjun tomar
  • Mon, 22-Mar-2021
    Meenakshi Sharma
  • Tue, 23-Mar-2021
    Deepa
    Course is very easy to understand and informative
  • Fri, 26-Mar-2021
    Mahesh Hegde
  • Tue, 30-Mar-2021
    vinod parsad
  • Tue, 30-Mar-2021
    Jignesh
    Moderate Knowledge which is necessary for beginners. Video Quality is very good
  • Wed, 31-Mar-2021
    Virendra pandey
  • Sun, 04-Apr-2021
    Junaid
    Wonderful. Worth the money invested. u won't find such info at such low price
  • Fri, 09-Apr-2021
    Navanath Manjare
  • Sun, 11-Apr-2021
    Saroj Kumar Patra
  • Sat, 17-Apr-2021
    Smriti Srivastava
  • Mon, 19-Apr-2021
    Harish Chandra Behera
    most useful video
  • Thu, 22-Apr-2021
    MULLEVA KAVITHA CHOUDHARY
  • Sat, 24-Apr-2021
    Sunil Kumar
    Best for learning Excel app
  • Mon, 26-Apr-2021
    Shrutika Thakur
    Videos are not opening
  • Fri, 21-May-2021
    priyasmita kundu
    thank you for solving my problem
  • Sun, 02-May-2021
    Karan Bhargava
  • Thu, 06-May-2021
    Shweta kaushik
  • Fri, 07-May-2021
    SHUBHAM GARG
  • Sat, 08-May-2021
    Vaishnavi sadiwal
  • Tue, 11-May-2021
    Harsh Shah
    Method of teaching is great and each concept covered was easy to understand.
  • Fri, 14-May-2021
    SONU PAL
  • Sun, 16-May-2021
    Rahul Kumar
  • Tue, 18-May-2021
    Parjeet
  • Mon, 24-May-2021
    Tarvinder Singh
  • Wed, 26-May-2021
    malay sarkar
    nice
  • Sat, 29-May-2021
    Akash kumar
    superb experience
  • Sun, 30-May-2021
    Yuvraj Grover
    It helps me a lot even from doing virtually
  • Mon, 31-May-2021
    Divyansh Agarwal
  • Mon, 31-May-2021
    Yogeshwari
  • Tue, 01-Jun-2021
    Trupti Sankpal
    Whenever I'm opening these lessons every time only intro is showing...now am thinking there is nothing anything except intro
  • Thu, 03-Jun-2021
    A PRAVEEN
    In 4th Sections last video intstructor said about Quiz. Please suggest where will i get that.
  • Fri, 04-Jun-2021
    Mrinal Kanti Roy
    It's helpful for me
  • Sun, 06-Jun-2021
    Raghu ram v
    super
  • Thu, 10-Jun-2021
    Poojasonkar
₹ 1999 ₹ 10000
Buy now
Includes:
  • 15:12:37 Hours On demand videos
  • 152 Lessons
  • Full lifetime access
  • Access on mobile and tv