Excel Programming Course

Lesson 1 • Cell Selection and Data Entry

Introduces cell referencing, selection techniques, and efficient data entry. These skills underpin every formula and data operation covered later.

Lesson 2 • Workbook and Worksheet Management

Teaches creating, saving, and organizing workbooks and sheets. Proper file management prevents data loss and supports collaborative workflows.

Lesson 3 • Printing and Page Layout

Configures print areas, headers, footers, and page breaks. Students produce print-ready outputs that meet professional presentation standards.

Lesson 4 • Navigating the Excel Interface

Covers the Ribbon, Quick Access Toolbar, and worksheet tabs. Establishes spatial awareness of the application as the foundation for all subsequent tasks.

Lesson 1 • Text Functions and Manipulation

Applies functions to clean, combine, and extract text strings. Text manipulation is critical for standardizing imported data before analysis.

Lesson 2 • Mathematical and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and rounding functions. These functions handle the majority of quantitative analysis tasks in business settings.

Lesson 3 • Logical and Conditional Functions

Builds IF, AND, OR, and nested logic to drive conditional outputs. Logical functions enable dynamic, decision-based calculations across datasets.

Lesson 4 • Formula Syntax and Operators

Explains formula structure, operator precedence, and error indicators. A solid syntax foundation prevents calculation mistakes in all subsequent work.

Lesson 1 • Advanced Reference Functions

Covers OFFSET, INDIRECT, and CHOOSE for dynamic range construction. These functions enable self-adjusting formulas that respond to changing data layouts.

Lesson 2 • INDEX and MATCH Techniques

Combines INDEX and MATCH for flexible, bidirectional lookups. This pairing overcomes VLOOKUP limitations and handles complex retrieval scenarios.

Lesson 3 • Conditional Aggregation Functions

Applies SUMIF, COUNTIF, AVERAGEIF, and their multi-criteria variants. Conditional aggregation replaces manual filtering for summary calculations.

Lesson 4 • VLOOKUP and HLOOKUP Fundamentals

Teaches vertical and horizontal lookup syntax, match types, and common pitfalls. These functions are the baseline for all table-based data retrieval tasks.

Lesson 1 • Removing Duplicates and Cleaning Data

Uses built-in tools and functions to identify and remove inconsistencies. Clean data is a prerequisite for accurate pivot tables, charts, and formulas.

Lesson 2 • Importing and Connecting External Data

Imports data from CSV, text files, and other workbooks. External data connections keep reports current without manual copy-paste operations.

Lesson 3 • Data Validation and Input Controls

Sets validation rules, dropdown lists, and error alerts on input cells. Validation enforces data integrity at the point of entry, reducing downstream errors.

Lesson 4 • Structuring Data as Excel Tables

Converts ranges to structured tables and explains table references. Structured tables automate formatting, filtering, and formula expansion across datasets.

Lesson 1 • Creating and Configuring PivotTables

Walks through PivotTable creation, field placement, and layout options. A well-configured PivotTable is the fastest path from raw data to executive summary.

Lesson 2 • PivotCharts and Dashboard Integration

Creates PivotCharts linked to PivotTables and arranges them into dashboards. Integrated visuals communicate summarized insights to diverse audiences efficiently.

Lesson 3 • Slicers and Timelines

Adds slicers and timeline controls for visual, interactive filtering. These controls make PivotTable dashboards accessible to non-technical stakeholders.

Lesson 4 • Grouping and Calculated Fields

Groups dates, numbers, and text items and adds calculated fields. Custom calculations extend PivotTable analysis beyond the source data columns.

Lesson 1 • Formatting and Customizing Charts

Applies titles, labels, axes, gridlines, and color schemes to charts. Consistent formatting aligns charts with organizational branding and reporting standards.

Lesson 2 • Chart Types and Selection Principles

Maps common chart types to data relationships and communication goals. Choosing the right chart type is the first step toward accurate visual storytelling.

Lesson 3 • Advanced Chart Techniques

Builds combination charts, waterfall charts, and sparklines for complex data. Advanced chart types handle scenarios where standard charts obscure key insights.

Lesson 4 • Conditional Formatting for Visualization

Uses data bars, color scales, and icon sets to visualize values in cells. In-cell visualization provides instant pattern recognition without separate chart objects.

Lesson 1 • VBA Syntax and Variables

Covers Sub procedures, variable declaration, data types, and scope. Proper variable use prevents runtime errors and makes code readable and maintainable.

Lesson 2 • Visual Basic Editor Orientation

Navigates the VBE, project explorer, and code modules. Familiarity with the editor environment is required before writing or editing any VBA code.

Lesson 3 • Recording and Running Macros

Uses the macro recorder to capture actions and assigns macros to buttons. Recording is the fastest entry point into automation for non-programmers.

Lesson 4 • Working with Ranges and Cells in VBA

Manipulates cells, ranges, and worksheets through the Range and Cells objects. Object-based range control is the core skill for automating data operations.

Lesson 1 • Event-Driven Programming

Attaches code to workbook and worksheet events such as open, change, and activate. Event procedures trigger automation automatically without user-initiated macro calls.

Lesson 2 • Functions and Reusable Procedures

Creates Function procedures, passes arguments, and returns values. Reusable functions reduce code duplication and enable custom worksheet functions.

Lesson 3 • UserForms and Custom Dialog Boxes

Designs UserForms with controls to collect and validate user input. Custom forms replace generic input boxes and enforce structured data entry in applications.

Lesson 4 • Error Handling and Debugging

Implements On Error statements, error logging, and debugging tools. Robust error handling prevents crashes and guides users to corrective action in production code.