Overview:
Excel is the most powerful tool to manage and analyze various types of data. This Microsoft Excel tutorial will cover in-depth lessons for Excel learning and how to use various Excel formulas, tables, and charts to manage small to large scale business process. |
Course Content:
Upon successful completion of the course, participants will be able to:Â | ||||||
|
||||||
|
||||||
|
||||||
|
||||||
|
||||||
|
||||||
|
||||||
|
||||||
|
Microsoft Excel Syllabus |
Level 1 | ||||||
👉 Chapter 1 | Introduction to MS Excel | |||||
👉 Chapter 2 | Excel Basic Formulas | |||||
👉 Chapter 3 | Excel Data Validation | |||||
👉 Chapter 4 | Excel Formulas & Functions | |||||
👉 Chapter 5 | How to Create Charts in Excel | |||||
👉 Chapter 6 | CSV vs Excel — What is the Difference? | |||||
👉 Assessment | Unit Assessment. |
Level 2 | ||||||
👉 Chapter 1 | Excel VLOOKUP Tutorial – 1 hr | |||||
👉 Chapter 2 | Excel ISBLANK Function – 30 min | |||||
👉 Chapter 3 | Sparklines in Excel 30- 40 min | |||||
👉 Chapter 4 | SUMIF function in Excel | |||||
👉 Chapter 5 | Logical Functions in Excel | |||||
👉 Chapter 6 | Conditional Formatting – 30 min | |||||
👉 Assessment | Unit Assessment. |
Level 3 | ||||||
👉 Chapter 1 | Advanced Excel Charts & Graphs – 40 hrs | |||||
👉 Chapter 2 | How to make Budget in Excel – 45 | |||||
👉 Chapter 3 | Working with data tables – 30 | |||||
👉 Chapter 4 | How to Import CSV Data into Excel – 30 min. | |||||
👉 Chapter 5 | How to Create Pivot Table in Excel – 1 hr | |||||
👉 Chapter 6 | Hyper Link 15 -20 min | |||||
👉 Assessment | Unit Assessment 45 |