Microsoft Excel - Excel from Beginner to Pro without VBA
- Description
- Curriculum
- FAQ
- Reviews
This course is created for those who want to get a sufficient education in Excel to improve their office works, their business, or even their personal life. This course is structured to help the majority of people regardless of their current knowledge of Excel. If you are a beginner or intermediate, then this course is for you.
In these days, the vast requirements of supply and demand of millions of goods worldwide generate tremendous amount of data that needs to be analyzed, presented and organized in a very frequent paste, and as far as I know, no human brain can do that by itself, but with Excel they can.
I believe and I since you are reading this, you agree with me, that It became a shame in the job world not to know Excel!! For me literacy in any career is equivalent to the ignorance of Excel in these days!!
Therefore, this course is intended to teach you this amazing tool. You will learn the vast amount of the features and functions in Excel as well as some advanced techniques that will help you present your data in a professional way and impress your coworkers, managers and clients.
You will know how to organize and rearrange any data you have using Pivot table while plotting them in advanced charts and graphs. But most importantly, you will understand how to think like Excel.
-
5Chapter IntroVideo lesson
-
6Straight Forward FormulasVideo lesson
-
7IF and Nested IfVideo lesson
-
8And Or with If formulasVideo lesson
-
9Rank Sumif(s)Video lesson
-
10Conditional FormattingVideo lesson
-
11Data ValidationVideo lesson
-
12Match FormulasVideo lesson
-
13Index and Match FormulasVideo lesson
-
14ChooseVideo lesson
-
15OffsetVideo lesson
-
16HomeworkVideo lesson
-
17Chapter IntroVideo lesson
-
18Straight Forward FormulasVideo lesson
-
19ConcatenateVideo lesson
-
20Left, Right & MidVideo lesson
-
21Len TextVideo lesson
-
22Search and FindVideo lesson
-
23If(isnumber(search))Video lesson
-
24Right(Len(Search))Video lesson
-
25SubstituteVideo lesson
-
26Check BoxVideo lesson
-
27Numbers to WordsVideo lesson
-
28HomeworkVideo lesson
-
39Chapter IntroVideo lesson
-
40Bar ChartVideo lesson
-
41Basic Column ChartVideo lesson
-
42Column ChartsVideo lesson
-
43Line ChartsVideo lesson
-
44Area ChartsVideo lesson
-
45Pie & Donut ChartsVideo lesson
-
46Treemaps and Sunburst ChartsVideo lesson
-
47Radar ChartsVideo lesson
-
48Waterfall and Funnel ChartsVideo lesson
-
49Histogram and Pareto ChartVideo lesson
-
50World MapVideo lesson
-
51Combo ChartsVideo lesson
-
52Heat MapVideo lesson
-
53Surface ChartVideo lesson
-
54SparklinesVideo lesson
-
55Annual Leaves using Gant ChartVideo lesson
-
56Gant Chart using Conditional FormattingVideo lesson
-
57Advanced Line ChartVideo lesson
-
58Advanced Column ChartVideo lesson
-
59Dynamic Donut ChartVideo lesson
-
60Linked Picture ChartsVideo lesson
-
61Overlay Image ChartVideo lesson
-
62Curved ColumnVideo lesson
-
63InfographsVideo lesson
-
64Scatter, Bubble, Box & Whiskers, and Stock ChartsVideo lesson
-
65Dynamic DashboardVideo lesson
External Links May Contain Affiliate Links read more