Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Difficulty

74% of the students have found this course easy.

Content

90% of the students have liked the content of this course.

Assignments

80% of the students have liked the assignments of this course.

Teaching

90% of the students have liked how the instructor has taught this course.

Satisfaction

94% of the students are overall satisfied with this course.

Edvicer's Rewards

You can get a reward of 50 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

1280
Start anytime
Self paced
English
Course by
UdemyCourses from Udemy
Certificate awarded
Intermediate
Login to earn 50Edvicer reward coin50 coins = INR 50

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Difficulty

74% of the students have found this course easy.

Content

90% of the students have liked the content of this course.

Assignments

80% of the students have liked the assignments of this course.

Teaching

90% of the students have liked how the instructor has taught this course.

Satisfaction

94% of the students are overall satisfied with this course.

Edvicer's Rewards

You can get a reward of 50 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

Why should you choose this course?

Description

Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial

Syllabus

1. Introduction to course!
2. Excel worksheet operations- the basics
3. How to use copy, cut and paste features in Excel
4. Excel Comments- How to use them
5. Sorting data in Excel
6. Finding and Replacing Data in Excel
7. Text Formatting in Excel
8. Applying a format quickly to other cells
9. Tables and Excel filtering- the basics
10. Data Validation in under 20 minutes
11. Formulas Part 1- Understanding syntax and basic maths
12. Formulas Part 2- Understanding more formula syntax and formula references
13. Formulas Part 3- Learn how to write formulas
14. Formulas Part 4- If then else statements
15. Formulas Part 5- Multiple conditions testing in Excel
16. Formulas Part 6- How do I know which formula to use?
17. Formulas Part 7- Excel Formula Error Messages
18. Formulas Part 8- How to audit any formula
19. Formulas Part 9- Useful text functions to know
20. Formulas Part 10- Data analysis Excel functions to know
21. Formulas Part 11- Advanced Vlookup()
22. Charts- The basics part 1
23. Charts- The basics part 2
24. Charts Intermediate level Part 1- Colour changing and thermometer charts
25. Charts Intermediate level Part 2- Handy chart techniques,funnel and gantt charts
26. Charts Intermediate Level Part 3- How to make Excel waterfall charts
27. Charts Intermediate Level Part 4- How to make a gauge chart in Excel
28. Charts Advanced level- Creating an Excel Timeline Chart
29. Charts Advanced level- Creating a dynamic chart
30. Charts Advanced level- Creating a dynamic chart part 2
31. Charts Advanced level- Creating a dynamic chart part 3
32. Conditional Formatting
33. Pivot Tables
34. Excel Reporting Skills- Essential Tips for Excel Reports
35. Excel Security- Protect your workbooks
36. Making Excel run faster
37. How to stop one Excel workbook from crashing another
38. Introduction to VBA
39. Setting up Excel for VBA use
40. The Basics of VBA
41. VBA Object Model Explained
42. Debugging Code in VBA
43. Building 'Real Life' Macros
44. Excel Career Tips- Use your skills to do better
45. General IT Career Tips
46. The end!

What others say about this course

Reviews from Udemy

The bad: takes the long way around to get to a point.

Very good course, it might be a little basic at the beggining for people who already know Excel but it gets more "interesting" latero on. Good job!

Covers a lot of material yet still explains the what and why clearly and simply. Still working my way through all the videos....

Amazing course - really well explained by the instructor, and plenty of resources to allow you to put the tutorials into practice and improve your excel skills! Highly recommend this course to anyone l  Read More ...

In my opinion this quick overview of Excel workbook was good, as it was very informative and short. There was not too much information but enough to understand what I am going to learn in the next few   Read More ...

Show more reviews

You might also be interested in

Write your review of Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer

30% off