Essential Microsoft Excel from Beginner to Advance level

Focused View

Tech Bunny

5:31:11

96 View

1. Introduction.mp4

01:05

2. Getting Started With Excel.mp4

07:47

3. Create and open Workbook.mp4

03:04

4. Create New Worksheets.mp4

02:01

5. Tabs and Ribbon.mp4

11:37

6. Data Formats.mp4

07:05

7. Data Handling Basics - Cut, Copy and Paste.mp4

20:44

8. Saving and Printing in Excel.mp4

09:01

9. Basic Formula Operations.mp4

24:28

10. Mathematical Functions - 1.mp4

06:57

11. Mathematical Functions - 2.mp4

04:30

12. Difference between RANK, RANKAVG and RANKEO.mp4

04:37

13. Textual Functions - Part.mp4

06:24

14. Textual Functions.mp4

06:57

15. Logical Functions.mp4

19:08

16. Date-Time Functions.mp4

15:50

17. XLookup as a replacement of Vlookup.mp4

15:43

18. Handling #NA and Approximates match in Xlookup.mp4

09:00

19. Search modes in XLookup.mp4

05:39

20. Pivot table.mp4

15:13

21. Excel Charts - Categories of messages that can be conveyed.mp4

04:31

22. Elements of charts.mp4

07:44

23. Bar and column charts.mp4

07:56

24. Formatting charts.mp4

21:47

25. Line Charts.mp4

09:16

26. Area Charts.mp4

03:07

27. Pie and Doughnut Charts.mp4

08:07

28. Why we should avoid Pie charts.mp4

03:21

29. Scatter plot or XY chart.mp4

06:48

30. Frequency Distribution and Histograms.mp4

13:27

31. Waterfall Charts.mp4

06:59

32. Hierarchy Charts- Sunburst and Treemap.mp4

06:02

33. Combination charts.mp4

05:42

34. Sparkline.mp4

03:46

35. Piviot Chart.mp4

04:13

36. Maps Chart.mp4

05:10

37. Stock charts.mp4

05:29

38. Shorrtcuts.mp4

08:24

39. Concluation.mp4

02:32

Description

Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas,Excel Charts,Projects & More

What You'll Learn?

Excel formulas and features
Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports
Data Selection
Data Navigation
Excel Charts
X-lookup

Who is this for?

Who wants to learn excel

Any student

Who want to increase his / her excel skills

Anyone who have little bit of excel knowledge

More details

Description
Looking to learn Microsoft Excel and improve your data analysis skills but don't know where to start?
OR, you've been using Microsoft Excel for a while but don't feel 100% confident?
There is so much information out there. What do you need to succeed at work?
Iâ€™ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.
In fact, We collected the most common Excel problems faced by my clients. We added in our 15+ years' experience in finance and project management. We included all the hidden tips and tricks We came to learn as an Excel MVP and put it ALL in THIS course. We also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
This Microsoft Excel Course include all the basic to intermediate Excel Curriculum like:
1.Introducing Excel.Â Â Â
2.Excel Formulas and Functions which we used in daily use.
3.Pivot Tables.
4.Excel Charts.
5.Power Query
6.Projects and Many More

We will update projects in our Excel course as students demand.

Thankyou.

Who this course is for:
Who wants to learn excel
Any student
Who want to increase his / her excel skills
Anyone who have little bit of excel knowledge

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Tech Bunny

Instructor's Courses

Hey, We are tech related institution, we Teach Tech related Courses like HTML, Css, Python, Javascript, and other Coding Stuff to students. We Also Expert in Teaching in Demand Skills like Excel ,Spread sheet , PowerPoint, etc.We are expert in Making in Demand Courses like Python,Excel,PHP,Javascript,Node JS,Larvel,Mern and many Frameworks.

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.