In this course on Microsoft Excel, we shall start from basics. We shall get some hands on experience of different functionalities offered by Excel which are valuable in freelance market places. We shall learn tricks to apply this knowledge in routine office tasks and complex data analysis.
This course is in self assessment mode. You can watch the videos and download the assignments, but you will have to assess your progress and assignments yourself. The medium of instruction is Urdu.
Curriculum
- 1 Section
- 43 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Introduction43
- 2.0General Introduction to Excel6 Minutes
- 2.1Formulas in MS Excel10 Minutes
- 2.2Assignment 01
- 2.3Applications of VLOOKUP10 Minutes
- 2.4Assignment no 4 (Vlookup)
- 2.5VLookup and Nested IF17 Minutes
- 2.6Assignment 02 & 03
- 2.7Range Lookup using VLookup, named ranges, and data validation list17 Minutes
- 2.8How to use Named ranges in Excel7 Minutes
- 2.9How to use Match and Index in excel8 Minutes
- 2.10Page layout and print settings in Excel14 Minutes
- 2.11Data validation and drop-down menu in Excel10 Minutes
- 2.12How to use tables and slicers in Excel8 Minutes
- 2.13Data visualization (Graphs) part 18 Minutes
- 2.14Data visualization Part 210 Minutes
- 2.15Data visualization part 37 Minutes
- 2.16Data visualization part 48 Minutes
- 2.17How to use pivot tables in Excel9 Minutes
- 2.18Pivot tables Part 28 Minutes
- 2.19How to create Dashboard in Excel15 Minutes
- 2.20How to remove duplicates in Excel9 Minutes
- 2.21How to use Power Query in Excel8 Minutes
- 2.22Data manipulation using Power query12 Minutes
- 2.23How to do Statistical analysis in Excel9 Minutes
- 2.24How to do statistical analysis in Excel part-27 Minutes
- 2.25How to do statistical analysis in Excel | T-test9 Minutes
- 2.26How to do statistical analysis in Excel | F-test, ANOVA8 Minutes
- 2.27How to enable and use macro in Excel14 Minutes
- 2.28Using Macro and VBA in Excel part-110 Minutes
- 2.29Using Macro | relative reference | part-26 Minutes
- 2.30How to use VBA editor in Excel10 Minutes
- 2.31How to use vba editor in Excel | part 210 Minutes
- 2.32How to use vba in Excel | making custom functions10 Minutes
- 2.33How to use custom functions in vba | learn with example12 Minutes
- 2.34How to make automatic invoicing system in Excel | part 110 Minutes
- 2.35How to use message box and input box in Excel13 Minutes
- 2.36How to use input box in vba Excel14 Minutes
- 2.37How to make Invoice in Excel | Exporting invoice to pdf18 Minutes
- 2.38How to make automatic mailing system using vba10 Minutes
- 2.39How to use variables in vba | Declaring variable in vba | Excel15 Minutes
- 2.40Assignment no 4 (Vlookup)
- 2.41Assignment no 5 (Data Visualization)
- 2.42Types of Variables in vba9 Minutes