Management Computing Excel Course

Lesson 1 • Workbook and File Management

Teaches creating, saving, and organizing workbook files. Connects proper file hygiene to reliable data management throughout the course.

Lesson 2 • Cell Selection and Navigation Techniques

Introduces keyboard shortcuts and mouse techniques for moving through large datasets. Efficient navigation reduces errors and speeds up every workflow.

Lesson 3 • Customizing the Excel Environment

Covers display options, view modes, and accessibility settings. A tailored environment improves productivity and reduces visual fatigue.

Lesson 1 • Styles, Themes, and Cell Templates

Introduces cell styles and workbook themes for consistent branding. Reusable styles reduce formatting time across large workbooks.

Lesson 2 • Data Validation and Input Controls

Restricts cell input to valid values using validation rules and drop-down lists. Prevents entry errors before they propagate through formulas.

Lesson 3 • Number and Date Formatting

Teaches built-in and custom number formats for currency, percentages, and dates. Consistent formatting ensures data is interpreted correctly by all readers.

Lesson 4 • Entering and Editing Cell Data

Covers text, number, date, and time entry methods. Accurate input at this stage prevents downstream calculation errors.

Lesson 1 • Formula Construction Principles

Explains operator precedence, cell references, and formula syntax. Correct syntax is the prerequisite for every function covered in this chapter.

Lesson 2 • Logical Functions and Conditional Logic

Introduces IF, AND, OR, NOT, and nested logic structures. Conditional logic enables dynamic outputs that respond to changing data.

Lesson 3 • Text Functions for Data Cleaning

Teaches LEFT, RIGHT, MID, TRIM, CONCATENATE, and TEXT. Text functions transform raw imported data into consistent, usable formats.

Lesson 4 • Math and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and ROUND. These functions handle the majority of quantitative calculations in management reporting.

Lesson 1 • XLOOKUP for Modern Retrieval

Introduces XLOOKUP syntax, default values, and search modes. XLOOKUP replaces legacy lookups with a single, more readable function.

Lesson 2 • Conditional Lookup Functions

Covers SUMIF, COUNTIF, AVERAGEIF, and their multi-criteria variants. Conditional aggregation links lookup logic to summary calculations.

Lesson 3 • Cross-Sheet and Cross-Workbook References

Teaches referencing cells across sheets and external workbooks. Linking data sources reduces duplication and keeps reports automatically updated.

Lesson 4 • INDEX and MATCH Combination

Teaches INDEX and MATCH as a flexible alternative to VLOOKUP. This combination retrieves data from any column direction without restructuring tables.

Lesson 1 • Removing Duplicates and Cleaning Data

Uses Remove Duplicates, Find and Replace, and text-to-columns tools. Clean data prevents miscounts and incorrect aggregations in downstream analysis.

Lesson 2 • Sorting and Filtering Data

Covers single-level and multi-level sorting plus AutoFilter and custom filters. Sorted, filtered data is the foundation for all analytical tasks.

Lesson 3 • Excel Tables and Structured References

Converts ranges to Excel Tables and introduces structured reference syntax. Tables automate formatting, filtering, and formula expansion as data grows.

Lesson 4 • Conditional Formatting for Data Insight

Applies highlight rules, data bars, color scales, and icon sets. Visual cues surface patterns and outliers without requiring additional calculations.

Lesson 1 • Chart Accessibility and Export

Adds alt text, adjusts color contrast, and exports charts for reports and presentations. Accessible charts meet professional and compliance standards.

Lesson 2 • Advanced Chart Techniques

Builds combination charts, secondary axes, and sparklines for compact visuals. Advanced techniques handle complex comparisons that single-axis charts cannot show.

Lesson 3 • Chart Formatting and Design

Applies chart styles, color schemes, axis formatting, and gridlines. Consistent design aligns charts with organizational branding standards.

Lesson 4 • Chart Types and Selection Criteria

Maps common chart types to data relationships and communication goals. Choosing the right chart type prevents misrepresentation of business data.

Lesson 1 • Grouping and Calculated Fields

Groups dates, numbers, and text items and adds calculated fields and items. Custom calculations extend PivotTables beyond simple aggregation.

Lesson 2 • PivotCharts and Dashboard Integration

Creates PivotCharts linked to PivotTables and arranges them into a dashboard layout. Linked charts update automatically when source data or filters change.

Lesson 3 • Slicers and Timelines for Interactivity

Adds slicers and timeline controls to filter PivotTables visually. Interactive filters let non-technical users explore data without modifying the workbook.

Lesson 4 • PivotTable Formatting and Layout

Applies PivotTable styles, report layouts, and subtotal options. Professional formatting makes PivotTable output suitable for direct stakeholder distribution.

Lesson 1 • Recording and Running Macros

Records, stores, and runs macros to automate repetitive formatting and data tasks. Macros reduce manual effort and ensure process consistency.

Lesson 2 • What-If Analysis Tools

Uses Goal Seek, Scenario Manager, and Data Tables for sensitivity analysis. These tools quantify the impact of variable changes on business outcomes.

Lesson 3 • Solver for Optimization Problems

Configures Solver to find optimal solutions under constraints. Solver handles resource allocation and scheduling problems common in management roles.

Lesson 4 • Dynamic Arrays and Spill Functions

Introduces FILTER, SORT, UNIQUE, and SEQUENCE for dynamic range outputs. Spill functions eliminate the need for manual array entry and update automatically.