Advanced Excel Course for Job and Real World

Focused View

Manuel Tudu

4:22:29

115 View

1. Introduction.mp4

00:44

2. 5 advanced excel formulas.mp4

19:34

3. Excel Formulas for Job Interview.mp4

12:48

4. Date Function.mp4

09:31

5. Creating Entry Bill.mp4

11:54

6. Excel Shortcut and Quick Navigation.mp4

09:33

7. Excel Macro.mp4

17:39

8. Excel VBA.mp4

10:13

9. FV and PV.mp4

11:42

10. How to create Audit report.mp4

18:02

11. How to create monthy salary slip.mp4

20:20

12. Index Match.mp4

11:56

13. IRR.mp4

09:10

14. NPV.mp4

14:55

15. Offset and Match.mp4

14:49

16. PMT building a complete Loan Schedule.mp4

11:32

17. Vlook up and HLookup.mp4

11:23

18. Vlookup and Choose.mp4

10:36

19. Vlookup and Coloums.mp4

11:58

20. Vlookup and Indirect.mp4

11:37

21. Vlookup and Match.mp4

12:33

Description

Advanced Excel For Beginner to Professional

What You'll Learn?

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

Who is this for?

Who want to learn advanced excel

More details

Description
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.
Who this course is for:
Who want to learn advanced excel

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Manuel Tudu

Instructor's Courses

I love to teach office program like Word, Excel, PowerPoint. One of my passionate subject is Web Design and Development like HTML, CSS, PHP, MySql, Javascript, Wordpress etc. I am working in my teaching section for 4 years and I have vast knowledge in this field.My courses include examples based on my experience as well as the consulting work I have done for international companies.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.