3.96 out of 5
3.96
25 reviews on Udemy

Microsoft Excel Basic to Advance Level

Learn Excel in just few hours...
Instructor:
Nurture Tech Academy
7,934 students enrolled
English [Auto-generated]
An In-depth excel tutorial
From basics of writing a formula to complex functions
Functions explained in most logical and simplest manner
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Learn different Functions from Microsoft Certified trainer from your own desk.
Downloadable exercise files for practical learning
Get a certificate of completion

  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. 

  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 covers 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 in a Commercial Environment. 

Microsoft Excel - Basic Level

1
0101 Touring the interface
2
0102 Enter data & saving workbook
3
0103 Applying Formulas
4
0104 Changing a worksheet's structure
5
0105 Find, Replace & Spell Check
6
0106 Applying fonts, background colors, and borders
7
0107 Formatting numbers and dates
8
0108 Making the pieces fit
9
0302 Count Functions
10
0109 Inserting headers & footers and Repeating Rows
11
0110 Managing Large Workbooks

An introduction to the Excel

12
0401 Change Case (Upper, Lower, Proper)
13
Ex 0401 Change Case (Upper, Lower, Proper)
14
0402 Separating Text on Symmetrical Data
15
Ex 0402 Separating Text on Symmetrical Data
16
Microsoft Excel Assessment Test - Basic Level

Microsoft Excel - Intermediate Level

1
0201 Formula Writing (Don't Miss This)
2
Ex 0201 Formula Writing (Don't Miss This)
3
0301 SumIf & SumIfs
4
Ex 0301 SumIf & SumIfs
5
Ex 0302 Count Functions
6
0303 AverageIf & AverageIfs
7
Ex 0303 AverageIf & AverageIfs
8
0403 Separating Text on Non-Symmetrical Data
9
Ex 0403 Separating Text on Non-Symmetrical Data
10
0501 If Functionality
11
Ex 0501 IF Functionality
12
0502 If with AND
13
Ex 0502 If with AND
14
0503 If with OR
15
Ex 0503 If with OR
16
0601 Vlookup (Exact Match) # 1
17
Ex 0601 Vlookup (Exact Match) # 1
18
0603 Vlookup (Exact Match) # 2
19
Ex 0603 Vlookup (Exact Match) # 2
20
0604 Double Vlookup
21
Ex 0604 Double Vlookup
22
0609 Hlookup (Approximate Match)
23
Ex 0609 Hlookup (Approximate Match)
24
0701 How Excel Records Date & Time
25
0702 Now, Today & Autofill
26
0703 DateValue & TimeValue
27
0704 Calculate WorkingDays
28
0705 DatedIf
29
0801 Loan Calculation (PMT, PPMT, IPMT etc.)
30
Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.)
31
0803 Calculate Depriciation
32
Ex 0803 Calculate Depriciation
33
0901 Basic Sorting & Shortcut keys
34
Ex 0901 Basic Sorting & Shortcut keys
35
0903 Horizontal Sorting
36
Ex 0903 Horizontal Sorting
37
0904 Basic Filter & Shortcut Keys
38
Ex 0904 Basic Filter & Shortcut Keys
39
1001 How to create a chart
40
1002 Format Axis
41
1003 Plot Values on Secondary Axis
42
1004 Life of Pie (Charts)
43
Consolidate Data using Excel Inbuilt Function
44
Ex Consolidate Data using Excel Inbuilt Function
45
1201 Applying Data Validation
46
Ex 1201 Applying Data Validation
47
1301 Worksheet Level Protection
48
Ex 1301 Worksheet Level Protection
49
1304 Protecting Workbook Structure
50
Ex 1304 Protecting Workbook Structure
51
1305 Workbook Level Protection
52
Ex 1305 Workbook Level Protection
53
1401 Understanding pivot Table
54
1402 Using Pivot Table in Real Scenario
55
Ex 1402 Using Pivot Table in Real Scenario
56
Microsoft Excel Assessment Test - Intermediate Level

Microsoft Excel - Advanced Level

1
0504 If with "AND" & "OR" / IF with Countif
2
Ex 0504 If with "AND" & "OR" / IF with Countif
3
0505 Nested IF (A Genie with 3 wishes)
4
Ex 0505 Nested IF (A Genie with 3 wishes)
5
0602 Type of References (Use of $ sign)
6
0605 Vlookup on Duplicate Values
7
Ex 0605 Vlookup on Duplicate Values
8
0606 Vlookup (Approximate Match)
9
Ex 0606 Vlookup (Approximate Match)
10
0607 Vlookup with If (Conditional Vlookup)
11
Ex 0607 Vlookup with If (Conditional Vlookup)
12
0608 Hlookup (Exact Match)
13
Ex 0608 Hlookup (Exact Match)
14
0610 Lookup (Don’t use this !)
15
Ex 0610 Lookup (Don’t use this !)
16
0611 Vlookup with Match (Create Magical Vlookup)
17
Ex 0611 Vlookup with Match (Create Magical Vlookup)
18
0612 Match (Gives us Column/Row Index #)
19
Ex 0612 Match (Gives us Column/Row Index #)
20
0613 Index & Match (Made for Each Other)
21
Ex 0613 (1) Index & Match (Made for Each Other)
22
Ex 0613 (2) Index & Match (Made for Each Other)
23
0802 Creating a Loan Table
24
Ex 0802 Creating a Loan Table
25
0902 Sorting Using Custom List
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4
4 out of 5
25 Ratings

Detailed Rating

Stars 5
9
Stars 4
19
Stars 3
5
Stars 2
0
Stars 1
1
30-Day Money-Back Guarantee

Includes

12 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Skip to toolbar