4.94 out of 5
4.94
24 reviews on Udemy

Advanced Excel Course for Job and Real World

Advanced Excel For Beginner to Professional
Instructor:
Manuel Tudu
1,086 students enrolled
English [Auto]
All the Advanced uses of MS Excel
All the Essential Skills of MS Excel
Advanced Excel Functions, Formulas
VLOOKUP, HLOOKUP
Match, Audit Report
Macro, VBA
Entry Bill, Salary Slip
Job Formula

Hello Everyone are you looking for learning Micro Soft Excel from the basic level to advanced level? if you are looking to learn MS Excel from basic to advanced than you are in right place. So if you need to learn advanced methods for MS Excel than this course is appropriate for you. Lets take a look what you will learn from this course:

· All the Advanced uses of MS Excel

· All the Essential Skills of MS Excel

· Advanced Excel Functions, Formulas

· VLOOKUP

· HLOOKUP

· Match

· Audit Report

· Macro

· VBA

· FV and PV

· Index and Match

· Entry Bill

· Salary Slip

· Job Formula and many more

By the end of the course you’ll be writing robust, elegant formulas from scratch, allowing you to:

· Easily build dynamic tools & Excel dashboards to filter, display and analyze your data

· Create your own formula-based Excel formatting rules

· Join datasets from multiple sources with VLOOKUP, HLOOKUP, INDEX & MATCH functions

· Manipulate dates, times, text, and arrays

So if you want to take yourself in next level for MS Excel than you can join our course. During learning, if you face any problem than I am always there for you to help you out. So I am expecting you to have you in my next lesson.

Introduction

1
Introduction
2
5 advanced excel formulas
3
Excel Formulas for Job Interview
4
Date Function
5
Creating Entry Bill
6
Excel Shortcut and Quick Navigation
7
Excel Macro
8
Excel VBA
9
FV and PV
10
How to create Audit report
11
How to create monthy salary slip
12
Index _ Match
13
IRR
14
NPV
15
Offset and Match
16
PMT _ building a complete Loan Schedule
17
Vlook up and HLookup
18
Vlookup and Choose
19
Vlookup and Coloums
20
Vlookup and Indirect
21
Vlookup and Match
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.9
4.9 out of 5
24 Ratings

Detailed Rating

Stars 5
23
Stars 4
0
Stars 3
1
Stars 2
0
Stars 1
0
5e0f483b333feeb46c143e0721acbe81
FREE For First 1000 Enrolls

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW