Microsoft Excel Basic to Advance Level


211
Learners

In this Excel, A 2 Z - An In-depth video course, Nurture Tech Academy introduces you to the simplest and logical way to understand Excel environment in detail.

Basic Course Offerings
149 Lecture Topics
13+ Hours of Video Lectures
Course Specials
Interactive Discussion Forum
128+ Course Files
Course Completion Certificate
Basic Plan

  • 30 days Free access to Basic Course Offerings covering HD Video Lectures delivered by Industry Experts.
  • Videos may contain ads
INR 0
Enrol Now
EFY Times
Standard Plan

  • 180 days access to basic course offerings covering HD video lectures
  • Course specific discussion forum for anytime doubt resolution
  • Ad-free Videos
  • Course Completion Certificate
USD 79.98/USD 66.64
Enrol Now
Enterprise Plan

  • Ideal for multiple participants.
  • Single payment option for instant multi user on-boarding.
  • Attractive discounts on bulk purchases.
  • Option to include white labelled LMS with custom dashboard report.
  • Multi course selection available.
Course Overview

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with Excel Introduction and its interface, how to write a Formula in Excel and starts with basic formulas like Sum and Count then gradually move to the complex one like IF, IF with And, IF with OR, Nested IF. Then it will cover the whole Lookup Functionality. Financial Functions will be covered thereafter with Date & Time Functions. 

It will also cover the basics of Excel Charts, types of charts in Excel (e.g. Column, Bar, Line, Pie, Pie of Pie, Bar of Pie, Area, bubble chart etc.) 

Data Validation, What-if Analysis, Solver Add-in cover afterwards. 

Then we will see step by step how to record a Macro. Then it will show you how to use show developer tab, ways to record a Macro, record a Macro, use Relative Reference, Create a Monthly Report Macro, assign a Macro to a shape, how to edit or delete a Macro and finally what are the security settings of a Macro. 

By the completion of this online training course, you will be fully versed, and capable of using most of the Formulas & Functions in Microsoft Excel 2007/2010/2013/2016/2019/Office 365 in a Commercial Environment.


Course Curriculum
1 Introduction to the Course Preview 00:47
2 0101 Touring the interface 03:21
3 0102 Enter data & saving workbook 04:50
4 0103 Applying Formulas 03:30
5 0104 Changing a worksheet's structure 04:04
6 0105 Find, Replace & Spell Check 03:15
7 0106 Applying fonts, background colors, and borders 05:01
8 0107 Formatting numbers and dates 04:43
9 0108 Making the pieces fit 04:22
10 0109 Inserting headers & footers and Repeating Rows 02:21
11 0110 Managing Large Workbooks 05:01
12 0201 Formula Writing (Don't Miss This) 08:28
0201 Formula Writing (Don't Miss This)  
13 Ex 0201 Formula Writing (Don't Miss This) 02:00
Ex 0201 Formula Writing (Don't Miss This)  
14 0301 SumIf & SumIfs 24:32
0301 SumIf & SumIfs  
15 Ex 0301 SumIf & SumIfs 08:23
Ex 0301 SumIf & SumIfs  
16 0302 Count Functions 08:24
0302 Count Functions  
17 Ex 0302 Count Functions 02:46
Ex 0302 Count Functions  
18 0303 AverageIf & AverageIfs 03:39
0303 AverageIf & AverageIfs  
19 Ex 0303 AverageIf & AverageIfs 03:49
Ex 0303 AverageIf & AverageIfs  
20 0401 Change Case (Upper, Lower, Proper) 04:32
0401 Change Case (Upper, Lower, Proper)  
21 Ex 0401 Change Case (Upper, Lower, Proper) 03:39
Ex 0401 Change Case (Upper, Lower, Proper)  
22 0402 Separating Text on Symmetrical Data 06:26
0402 Separating Text on Symmetrical Data  
23 Ex 0402 Separating Text on Symmetrical Data 05:57
Ex 0402 Separating Text on Symmetrical Data  
24 0403 Separating Text on Non-Symmetrical Data 08:47
0403 Separating Text on Non-Symmetrical Data  
25 Ex 0403 Separating Text on Non-Symmetrical Data 05:12
Ex 0403 Separating Text on Non-Symmetrical Data  
26 0501 If Functionality 04:31
0501 If Functionality  
27 Ex 0501 IF Functionality 03:13
Ex 0501 IF Functionality  
28 0502 If with AND 05:40
0502 If with AND  
29 Ex 0502 If with AND 03:45
Ex 0502 If with AND  
30 0503 If with OR 03:22
0503 If with OR  
31 Ex 0503 If with OR 02:53
Ex 0503 If with OR  
32 0504 If with 08:43
0504 If with "AND" & "OR" / IF with Countif  
33 Ex 0504 If with 04:12
Ex 0504 If with "AND" & "OR" / IF with Countif  
34 0505 Nested IF (A Genie with 3 wishes) 13:34
0505 Nested IF (A Genie with 3 wishes)  
35 Ex 0505 Nested IF (A Genie with 3 wishes) 05:25
Ex 0505 Nested IF (A Genie with 3 wishes)  
36 0601 Vlookup (Exact Match) # 1 22:59
0601 Vlookup (Exact Match) # 1  
37 Ex 0601 Vlookup (Exact Match) # 1 03:52
Ex 0601 Vlookup (Exact Match) # 1  
38 0602 Type of References (Use of $ sign) 11:35
0602 Type of References (Use of $ sign)  
39 0603 Vlookup (Exact Match) # 2 04:03
0603 Vlookup (Exact Match) # 2  
Ex 0603 Vlookup (Exact Match) # 2  
40 Ex 0603 Vlookup (Exact Match) # 2 06:30
41 0604 Double Vlookup 11:13
0604 Double Vlookup  
42 Ex 0604 Double Vlookup 10:10
Ex 0604 Double Vlookup  
43 0605 Vlookup on Duplicate Values 10:10
0605 Vlookup on Duplicate Values  
44 Ex 0605 Vlookup on Duplicate Values 05:50
Ex 0605 Vlookup on Duplicate Values  
45 0606 Vlookup (Approximate Match) 08:11
0606 Vlookup (Approximate Match)  
46 Ex 0606 Vlookup (Approximate Match) 02:13
Ex 0606 Vlookup (Approximate Match)  
47 0607 Vlookup with If (Conditional Vlookup) 04:53
0607 Vlookup with If (Conditional Vlookup)  
48 Ex 0607 Vlookup with If (Conditional Vlookup) 02:54
Ex 0607 Vlookup with If (Conditional Vlookup)  
49 0608 Hlookup (Exact Match) 03:46
0608 Hlookup (Exact Match)  
50 Ex 0608 Hlookup (Exact Match) 03:42
Ex 0608 Hlookup (Exact Match)  
51 0609 Hlookup (Approximate Match) 02:02
0609 Hlookup (Approximate Match)  
52 Ex 0609 Hlookup (Approximate Match) 02:20
Ex 0609 Hlookup (Approximate Match)  
53 0610 Lookup (Don’t use this !) 05:19
0610 Lookup (Don’t use this !)  
54 Ex 0610 Lookup (Don’t use this !) 01:58
Ex 0610 Lookup (Don’t use this !)  
55 0611 Vlookup with Match (Create Magical Vlookup) 14:16
0611 Vlookup with Match (Create Magical Vlookup)  
56 Ex 0611 Vlookup with Match (Create Magical Vlookup) 05:40
Ex 0611 Vlookup with Match (Create Magical Vlookup)  
57 0612 Match (Gives us Column/Row Index #) 03:14
0612 Match (Gives us Column/Row Index #)  
58 Ex 0612 Match (Gives us Column/Row Index #) 02:55
Ex 0612 Match (Gives us Column/Row Index #)  
59 0613 Index & Match (Made for Each Other) 11:02
0613 Index & Match (Made for Each Other)  
60 Ex 0613 (1) Index & Match (Made for Each Other) 05:31
Ex 0613 (1) Index & Match (Made for Each Other)  
61 Ex 0613 (2) Index & Match (Made for Each Other) 03:52
Ex 0613 (2) Index & Match (Made for Each Other)  
62 0701 How Excel Records Date & Time 02:25
0701 How Excel Records Date & Time  
63 0702 Now, Today & Autofill 02:41
0702 Now, Today & Autofill  
64 0703 DateValue & TimeValue 02:23
0703 DateValue & TimeValue  
65 0704 Calculate WorkingDays 03:15
0704 Calculate WorkingDays  
66 0705 DatedIf 05:20
0705 DatedIf  
67 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 12:41
0801 Loan Calculation (PMT, PPMT, IPMT etc.)  
68 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 07:39
Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.)  
69 0802 Creating a Loan Table 09:48
0802 Creating a Loan Table  
70 Ex 0802 Creating a Loan Table 06:44
Ex 0802 Creating a Loan Table  
71 0803 Calculate Depriciation 02:51
0803 Calculate Depriciation  
72 Ex 0803 Calculate Depriciation 02:48
Ex 0803 Calculate Depriciation  
73 0901 Basic Sorting & Shortcut keys 16:14
0901 Basic Sorting & Shortcut keys  
74 Ex 0901 Basic Sorting & Shortcut keys 06:48
Ex 0901 Basic Sorting & Shortcut keys  
75 0902 Sorting Using Custom List 08:28
0902 Sorting Using Custom List  
76 Ex0902 Sorting Using Custom List 02:41
Ex0902 Sorting Using Custom List  
77 0903 Horizontal Sorting 01:27
0903 Horizontal Sorting  
78 Ex 0903 Horizontal Sorting 01:17
Ex 0903 Horizontal Sorting  
79 0904 Basic Filter & Shortcut Keys 09:28
0904 Basic Filter & Shortcut Keys  
80 Ex 0904 Basic Filter & Shortcut Keys 05:19
Ex 0904 Basic Filter & Shortcut Keys  
81 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 05:56
0905 Filter Problem # 1 (Copy Filtered Data without hidden rows)  
82 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 03:19
Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows)  
83 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 07:33
0906 Filter Problem # 2 (Pasting Values on Filtered Data)  
84 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 02:49
Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data)  
85 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 07:45
0907 Filter Problem # 3 (Performing Calculation on Filtered Data)  
86 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 01:40
Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data)  
87 0908 Advanced Filter (Applying Complex Criteria's) 13:07
0908 Advanced Filter (Applying Complex Criteria's)  
88 Ex 0908 Advanced Filter (Applying Complex Criteria's) 05:48
Ex 0908 Advanced Filter (Applying Complex Criteria's)  
89 01. Excel Charts Introduction 02:59
90 02. How to Create a Chart 02:47
How to prepare a Chart  
91 03. Play with Design and Layout of Chart 02:46
92 04. Link a Chart Title 02:53
93 05. How to Show Axis Title 02:34
94 06. How to Show Data Lable 02:12
95 07. Show Data with Chart in Data Table 02:03
96 08. Column Chart 02:04
Column Chart  
97 09. Bar Chart 01:33
Bar Chart  
98 10. Line Chart 1 03:05
Line Chart  
99 11. Line Chart 2 02:43
Line Chart 2  
100 12. Area Chart 01:23
Area Chart  
101 13. Pie Chart 02:35
Pie Chart  
102 14. Pie of Pie or Bar of Pie 02:34
Pie of Pie or Bar of Pie Chart  
103 15. Line Chart with Log Scale 02:08
Log Scale  
104 16. Bubble Chart 01:21
Bubble Chart  
105 17. Selecting Chart Elements 05:17
1001 Chart & its Elements  
106 18. Use of Format Dialog box 03:07
107 19. Modifying Chart and Plot Area 04:21
108 20. Modifying Data Series 02:05
109 21. How to handle Missing Data 03:58
110 22. Modifying 3-D Charts 02:58
111 23. Creating Combination of upto 5 Different Charts 03:02
112 24. Creating a Chart Templates 02:56
113 25. Creating Picture Charts 02:12
114 Consolidate Data using Excel Inbuilt Function 06:38
Consolidate Data using Excel Inbuilt Function  
Consolidate Data using Excel Inbuilt Function  
Consolidate Data using Excel Inbuilt Function  
115 Ex Consolidate Data using Excel Inbuilt Function 02:59
Ex Consolidate Data using Excel Inbuilt Function  
Ex Consolidate Data using Excel Inbuilt Function  
Ex Consolidate Data using Excel Inbuilt Function  
116 1201 Applying Data Validation 13:26
1201 Applying Data Validation  
117 Ex 1201 Applying Data Validation 04:57
Ex 1201 Applying Data Validation  
118 1202 Dependent Dropdown List 07:34
1202 Dependent Dropdown List  
119 Ex1202 Dependent Dropdown List 04:55
Ex1202 Dependent Dropdown List  
120 Using Data Validation with Vlookup & Match 05:52
1203 Using Data Validation with Vlookup & Match  
121 Other Data Validation Examples 10:38
Other Data Validation Examples  
122 1301 Worksheet Level Protection 01:27
1301 Worksheet Level Protection  
123 Ex 1301 Worksheet Level Protection 00:49
Ex 1301 Worksheet Level Protection  
124 1302 Cell Level Protection 05:00
1302 Cell Level Protection  
125 Ex 1302 Cell Level Protection 02:04
Ex 1302 Cell Level Protection  
126 1303 Hiding Formulas from Formula Bar 03:14
1303 Hiding Formulas from Formula Bar  
127 Ex 1303 Hiding Formulas from Formula Bar 02:30
Ex 1303 Hiding Formulas from Formula Bar  
128 1304 Protecting Workbook Structure 01:10
1304 Protecting Workbook Structure  
129 Ex 1304 Protecting Workbook Structure 01:07
Ex 1304 Protecting Workbook Structure  
130 1305 Workbook Level Protection 02:29
1305 Workbook Level Protection  
131 Ex 1305 Workbook Level Protection 01:10
Ex 1305 Workbook Level Protection  
132 1401 Understanding pivot Table 12:33
1401 Understanding pivot Table  
133 1402 Using Pivot Table in Real Scenario 10:18
1402 Using Pivot Table in Real Scenario  
134 Ex 1402 Using Pivot Table in Real Scenario 09:39
Ex 1402 Using Pivot Table in Real Scenario  
135 1403 Grouping in Pivot Table 04:24
1403 Grouping in Pivot Table  
136 Ex 1403 Grouping in Pivot Table 01:36
Ex 1403 Grouping in Pivot Table  
137 1404 Using Slicers (A Visually attractive Filter) 03:29
1404 Using Slicers (A Visually attractive Filter)  
138 Ex 1404 Using Slicers (A Visually attractive Filter) 01:33
Ex 1404 Using Slicers (A Visually attractive Filter)  
139 1501 Goal Seek (A Reverse Approach) 04:19
1501 Goal Seek (A Reverse Approach)  
140 Ex 1501 Goal Seek (A Reverse Approach) 02:48
Ex 1501 Goal Seek (A Reverse Approach)  
141 1502 One Way Data Table 02:55
1502 One Way Data Table  
142 1503 Two Way Data Table 02:50
1503 Two Way Data Table  
143 1504 Scenario Manager 04:09
1504 Scenario Manager  
144 1505 Solver Add-In 07:52
1505 Solver Add-In  
145 1601 Record your first Macro 15:18
1601 Record your first Macro  
146 1602 Record Another Macro 02:02
1602 Record Another Macro  
147 1603 Assigning macro to a Shape, Button, Picture etc 02:46
1603 Assigning macro to a Shape, Button, Picture etc  
148 1604 Editing or Deleting a Macro 03:01
1604 Editing or Deleting a Macro  
149 1605 Security Settings of a Macro 02:00
1605 Security Settings of a Macro  

Eligibility Criteria

This course is eligible to all working professionals


Ratings & Reviews
Mr. vishesh Yewale
Student, N/A
Good Faculty

Mr. vishesh Yewale
Student, N/A
Good Faculty and Best option For E-learning

SUNITA KUMARI BISHOWKARMA
student
Best coarse on excel I was wondering about the EXCEL course for a long time, therefore, I'm so happy that I got something worthwhile here. the teacher teaches in a very good, calm and easy way.

Frequently Asked Questions

There are no limitations in accessing the course. You can assess the course through the web (ApnaCourse.com) on any device

Most courses are self paced courses with a free access of 30 days. The 30 days access (basic plan) is only on the videos. To extend access by 180 days or to get course specials like question bank, course completion certificate, exam etc, you will have to enrol into the standard (paid) plan.

Yes. If your access to a course expires, you can extend that through an online payment and continue from where you left of.

We engage only experienced and certified faculties for each course. Each faculty has decades of relevant teaching / training experience that they bring to ApnaCourse. For details of our faculty partners, please visit the Faculty section in the website.

We offer a course completion certificate on most courses. This certificate is jointly given by our partner trainer or training instiute who delivered the course.

For any course specific doubts, there is an Online forum on ApnaCourse called Social Circle for every Course. Access to the Social Circle is available only in the paid plan. Post your questions there and an expert would be able to respond to it. For general payment or enrolment related information, please email at support@apnacourse.com.

Pl visit our detailed FAQ section at https://www.apnacourse.com/about/faq. If you still have doubts, feel free to email at support@apnacourse.com.

×
×
Course Expert
Mr. Lokesh Lalwani
Freelance Microsoft Certified Adv. Excel, VBA & Power Bi Trainer/Consultant
×
All batches are currently full