Excel Training

About Microsoft Excel

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS, and iPadOS. 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 details

Purpose

This course will introduce the learner to the power of Microsoft Excel. The learner will be equipped with a strong foundational knowledge of Excel to organize, analyze and work with data. This includes the development of essential Excel skills, such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis. The learner will gain the confidence to navigate the Excel interface, master essential spreadsheet functions, perform calculations and produce creative charts and graphs from data, while building an aptitude for data analysis that is critical to the success of any organization.

Topics

Module 1: Introduction to Microsoft Excel (30 mins)

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

Module 2: Data Entry and Formatting (45 mins)

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

Module 3: Basic Formulas and Functions (1 Hour)

• Mathematical operations 
• Logical functions 
• Text functions

Module 4: Sorting, Filtering and Validation (40 mins)

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

Module 5: Charts and Data Visualization (30 mins)

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

Module 6: Pivot Tables and Pivot Charts (30 mins)

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

Model 7: Basic Data Analysis Tools (20 mins)

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

Module 8: Collaboration and Data Sharing (10 mins)

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

Module 9: Final Project (35 mins)

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