Microsoft Excel

Course Description

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS, and iPad OS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel is typically used to organize data and perform financial analysis.  It is used across all business functions and at companies from small to large. The main uses of Excel include: Data entry, Data management, Accounting, Financial analysis, Charting and graphing, Programming, Time management, Task management, financial modeling, Customer relationship management (CRM).

Course Objectives:

By the end of these sessions, the learners should be able to:

• Confidently navigate the Excel interface and manage workbooks and worksheets with ease
• Enter, Clean and organize data using essential tools such as formatting, AutoFill, Flash Fill and conditional formatting
• Apply basic and advanced formulas
• Sort, filter and validate data
• Create professional charts and graphs
• Use Pivot Table and Pivot Charts
• Apply Excel Skills to practical projects

Course Outline:

Module 1: Introduction to Microsoft Excel 

• Overview of the Excel interface
• Workbook and worksheet management
• Navigation and shortcuts

Module 2: Data Entry and Formatting 

• Entering, editing, and deleting data
• Formatting cells, rows, and columns
• Using AutoFill and Flash Fill
• Conditional formatting

Module 3: Basic Formulas and Functions 

• Mathematical operations 
• Logical functions 
• Text functions

Module 4: Sorting, Filtering and Validation 

• Sorting and filtering data
• Data validation
• Drop-down lists
• Removing duplicates and error handling

Module 5: Charts and Data Visualization 

• Creating basic charts
• Customizing chart elements
• Choosing the right chart for your data

Module 6: Pivot Tables and Pivot Charts 

• Creating and modifying PivotTables
• Analyzing large datasets efficiently
• Visualizing data with Pivot Charts

Model 7: Basic Data Analysis Tools 

• Descriptive statistics using Excel
• Data trends
• Forecasting
• Goal Seek 

Module 8: Collaboration and Data Sharing 

• Protecting and sharing workbooks
• Track changes & Version history
• Integrating Excel with other Microsoft Office applications

Module 9: Final Project 

• Apply all skills in a real-world scenario
• Learners submit a finished Excel file as proof of skills