Forage Academy — Excel Skills Job Simulation
Completed and submitted the Forage Academy Excel Skills Job Simulation on November 4, 2026. This evidence-led project documents data-quality review, conditional formatting, Excel formulas, PivotTables, KPI design, dashboard charts, and recorded VBA macros with worksheet buttons.
A question. A process.
Work you can explore.
Move from the project’s purpose to its available previews and source files.
Chapter 1 of 4 · The question
What this project explores.
Completed and submitted the Forage Academy Excel Skills Job Simulation on November 4, 2026. This evidence-led project documents data-quality review, conditional formatting, Excel formulas, PivotTables, KPI design, dashboard charts, and recorded VBA macros with worksheet buttons.
Follow the implementation.
- 01
Inspected account-sales workbook structure and identified missing cells, text-based formula-error markers, cross-sell flags, CAGR outliers, and high-sales records.
- 02
Applied conditional formatting to surface data-quality issues and analytical thresholds without treating text error markers as numeric values.
- 03
Built account-level calculations and summary metrics with SUM, AVERAGE, MAX, MIN, IF, IFERROR, COUNTIF, and SUMIF; used an absolute reference for the sales threshold.
- 04
Created PivotTable summaries for 2021 unit sales by account type and top accounts, then prepared a six-year sales summary.
- 05
Built a dashboard with a line chart for annual sales, a bar chart for the top 10 accounts, a column chart for sales by account type, and three KPI cards.
- 06
Recorded and tested a first macro plus SortBy5YrCAGR and SortBy2021UnitSales; assigned the sorting macros to separate Form Control buttons.
- 07
Captured workbook/button and VBA screenshots, assembled a readable PDF evidence file, and submitted the XLSM and PDF through the Forage activity.
See the work. Inspect the details.
The source files and README are the available evidence for this project. Open them to review the implementation and its assumptions.
Enlarge preview Choose where to look deeper.
Search the linked source inventory or narrow it to the kind of artifact you want to inspect. Files open at their original source.
5 linked source files
No linked files match this view.
The source
keeps moving.
Source updated
Learning notes and original evidence from the Forage Academy Excel Skills virtual experience program.
Current README excerpt
A comprehensive, hands-on Excel learning portfolio demonstrating data preparation, advanced conditional formatting, dynamic formulas, executive dashboard visualization, and VBA spreadsheet automation.
A source excerpt, not an independently verified outcome.