Online Courses & Platform for e-learning | Online Certification Courses

Courses taught by Anette Prehn

Learn MS Excel From Basic to Advance
MS Excel is a "must-have" skill for any Student, professional or business person.

This Course of mine will help you to understand the excel from very basic, like what is excel, to the important excel formulas & functions, like Sum/Avg/Trim/Concatenate/Vlookup/Hlookup/Countif/If & more, to decoding excel errors to Excel formatting to advance concept like pivot table/pivot chart/hyperlinking/bar chart/pie chart/line chart to excel data validation to excel reporting.

My way of teaching is very simple & with examples which makes it easy to understand the subject.

The Course has 14 lectures which are split into 8 sections :
1. Section 1: Introduction to Excel (1 Lecture)
2. Section 2: Maths Formulas & Functions ( 2 Lectures)
3. Section 3: Text & Lookup Functions ( 2 Lectures)
4. Section 4: Logical & Information Functions (2 Lectures)
5. Section 5: Date & Time and Excel Formatting Skills (2 Lectures)
6. Section 6: Advance Excel - Understanding Pivot table & Pivot Chart (1 Lecture)
7. Section 7: Advance Excel - Chart Analysis (2 Lectures)
8. Section 8: Advance Excel - Data Validation & Preparing Reports in Excel (2 Lectures)
The total course duration is 5.5 hrs.

All The Best for your learning journey!

Happy Learning!
(0)

INR1500