What you’ll learn

Excel Module

Workbooks & Cells Entry

• Row / column adjustments, text inputs, and automatic cell data handling.

Editing Techniques & Data Cleansing

• Paste special options, clearing contents, cell editing shortcuts
• Fixing broken formatting from text/number system exports

Formulas & Engine Notation

• Mathematical arithmetic operators (+, -, *, /, ^), and .
• Universal operations (SUM, AVERAGE, MAX, MIN, COUNT, IF)
• Relative/absolute cell addressing notation ($A$1)

File Exchange Management

• Importing data feeds, file type conversions, and layout formatting.

Standard Charting & C-Suite Layout Distribution (Integrated)

• Building column, bar, and line charts, axis parameter adjustment, and data series updates.
• Professional Page Setup properties
• Configuring print titles (repeating row/column headers),
• Using Scale-to-Fit setting, ssetting custom page breaks, defining specific print areas
• Setting custom page breaks, defining specific print areas
• Exporting to clean business PDFs

Formatting Techniques & Page Layouts

• Number formatting, currency styles, thousand separators, percentages
• Border lines, text alignments, and grid patterns

Database Management

• Sorting records by criteria (Multi-level, Color sets, Icon arrangements)
• Auto-fill automation, dragging techniques, and deploying data filters

Advanced Excel Module

Formula Readability & Naming Architectures (Integrated)

• Defining cell names and creating Named Ranges
• Using the Name Manager tool, editing range scopes
• Mapping self-explanatory text descriptors directly into advanced formulas

The AI-Assisted Optimization Workflow (Integrated)

• Effective prompting principles for spreadsheet users
• Using AI to parse and write complex nested logic, reverse-engineer unfamiliar legacy sheets, and analyze/debug standard formula errors (such as #N/A, #VALUE!, or #REF!).

Relational Cross-Referencing & Database Functions

• Mastering lookup tools (VLOOKUP, HLOOKUP, LOOKUP), cross-worksheet formulas, file linking parameters, and pasting cross-file links
• Using database functions (DSUM, DMAX, DMIN, DAVERAGE,DCOUNT)

Worksheet Consolidation

• Merging data arrays across multiple sheets into single summary blocks

Advanced Filter Operations & Complex Extraction

• Setting up isolated criteria ranges, applying multi-column comparison operators (>, <, <>), and constructing complex AND/OR logic across record sets
• Executing high-speed data extractions directly to separate worksheet locations for clean, automated reporting without disturbing the master ledger
• You can easily mix AND and OR logic across different columns at the same time
• Avoiding human errors caused by repeatedly filtering, copying, pasting, clearing, and filtering again in AutoFilter

Interactive Summary Reports & Pivot Matrices

• Preparing raw datasets for analysis, building PivotTables from scratch, customizing fields layout, changing data area calculations.

Error Prevention, Governance & Compliance Rules

• Deploying Data Validation rules
• Creating pull-down selection menus
• Setting up warning dialog boxes
• Document/sheet element protection
• Dynamic Conditional Formatting (Highlighting items using data bars or color scales)

What-If Analysis & Modeling Tools

• Using Goal Seek for root-cause targets
• Managing multiple conditions with Scenario Manager
• Creating multi-variable Data Tables

Workbook linking

• Creating a hyperlink
• Editing a hyperlink
• Creating a menu system using hyperlink
• Paste link across different workbooks

Template Design & Basic Automation

• Saving clean custom templates, and recording basic Macro routines to run repetitive tasks instantly