Microsoft Excel

Starting August 1, 2030

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: 
  • Understand how to use Spreadsheets
  • Use Spreadsheet Functions to Organize Data
  • Perform Data filtering in Excel
  • Maintain large sets of Excel data in a list or table
  • Do dashboarding and Data Visualization with different types of charts.
  • Understand advantages of creating an Excel table before creating a PivotTable.
  • Use IF and the Nested IF functions.
  • Create dynamic reports with VLOOKUP across worksheets.
  • Apply dynamic formulas with IF, VLOOKUP, MATCH, INDEX, functions, and many more.
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

Leave a comment