Microsoft Excel

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

Microsoft Excel

Leave a comment Cancel reply