Register Today

• Registration

Fundamental Courses

Excel I

This hands-on course is designed to build foundational skills in spreadsheet software, ideal for beginners or those looking to refresh their knowledge. Participants will learn how to manage files, format data for clarity and presentation, organize and manipulate information, apply essential formulas and functions, and create basic charts for visual analysis.

Topics Covered:

• Getting Started
• Formatting & Layout
• Data Management
• Formulas & Functions
• Basic Charts

Prerequisite: Basic computer proficiency 

Excel II

This intermediate-level course is perfect for users who have mastered the basics and are ready to expand their spreadsheet capabilities. Participants will learn how to fine-tune page setup, enhance formatting, apply more advanced formulas, and create dynamic visualizations.

Topics Covered:

• Page Setup & Display
• Formatting Cells and Sizing
• Formulas & Functions
• Enhancing Your Worksheet
• Charts and PivotTables

Prerequisite:  Excel I or equivalent knowledge

Excel III

This course is designed for users who are comfortable with basic spreadsheet functions and ready to take their skills to the next level. Participants will explore powerful tools for data analysis, automation, and visualization to enhance productivity and decision-making.

Topics Covered:

• IF Functions
• Creating Macros
• Conditional Formatting

Prerequisite: Excel I and II or equivalent knowledge

Advanced Courses

Data Analysis

Experienced Excel users will be taught the effective utilization of Excel’s What-If tools, including Goal Seeker, Solver, Scenario Manager, and Data Tables. Additionally, participants will acquire proficiency in installing and utilizing the AnalysisPak add-in—a powerful tool included with Excel but not automatically loaded. Harness the capabilities of this add-in to perform advanced analyses, including Histograms, Range and Percentile Analysis, and Descriptive Statistics, expanding your data analysis skill set.

Ideal for managers requiring data analysis for informed decision-making!

Prerequisite: Excel I, II, and III or equivalent knowledge

Charts

Explore Excel’s various chart types for clear data communication. This course provides a comprehensive understanding of all Excel chart types and their practical applications. Participants will develop expertise in creating, customizing, and enhancing charts using colors, patterns, and graphics. Additionally, they will learn to embed and link charts into Word and PowerPoint files.

Prerequisite: Excel I, II or equivalent knowledge

Pivot Tables

Discover how to convert data rows and columns into an Excel table throughout this course. The table features encompass a wide range of functionalities, such as sorting and filtering, formatting data, and managing table rows and columns. Discover the strength of Pivot Tables—an efficient tool for summarizing large datasets. Easily adjust your analysis by manipulating data directly within the table. Easily group, sort, and filter data, conduct calculations, and add or remove subtotals and grand totals, providing a comprehensive understanding of your data with ease.

Prerequisite: Excel I and II or equivalent knowledge

Functions

Excel Functions are built-in formulas crafted to streamline calculations with minimal manual input. Excel takes care of the necessary mathematical steps, needing only the cell addresses or ranges to execute the calculation. Although basic functions were addressed in Excel I, II, and III, this course acquaints students with additional functions that may not have been extensively explored. Immerse yourself in a more thorough grasp of Excel functions to expand your skill set and maximize the potential of this versatile tool.

Prerequisite: Excel I and II or equivalent knowledge