Essential Microsoft Excel from Beginner to Advance level
- Description
- Curriculum
- FAQ
- Reviews
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.
-
9Basic Formula OperationsVideo lesson
-
10Mathematical Functions - 1Video lesson
-
11Mathematical Functions - 2Video lesson
-
12Textual Functions - PartVideo lesson
-
13Textual FunctionsVideo lesson
-
14Difference between RANK, RANKAVG and RANKEOVideo lesson
-
15Logical FunctionsVideo lesson
-
16Date-Time FunctionsVideo lesson
-
20Excel Charts - Categories of messages that can be conveyedVideo lesson
-
21Elements of chartsVideo lesson
-
22Bar and column chartsVideo lesson
-
23Formatting chartsVideo lesson
-
24Search modes in XLookupVideo lesson
-
25Line ChartsVideo lesson
-
26Area ChartsVideo lesson
-
27Pie and Doughnut ChartsVideo lesson
-
28Why we should avoid Pie chartsVideo lesson
-
29Scatter plot or XY chartVideo lesson
-
30Frequency Distribution and HistogramsVideo lesson
-
31Waterfall ChartsVideo lesson
-
32Hierarchy Charts- Sunburst and TreemapVideo lesson
-
33Combination chartsVideo lesson
-
34SparklineVideo lesson
-
35Piviot ChartVideo lesson
-
36Maps ChartVideo lesson
-
37Stock chartsVideo lesson
-
38ShorrtcutsVideo lesson

External Links May Contain Affiliate Links read more