Microsoft Excel 101
- Home
- Courses
- Freelancing
- Microsoft Excel 101
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