PATH / EXCEL AND PRODUCTIVITY
Productivity and data
Organize data, explain a calculation and build a report you can verify.
01 / ORIENTATION
From records to explainable decisions
No programming knowledge is required; you can study this path alongside Software. You need Excel to open and review the workbooks; operational exercises do not depend on macros.
- Distinguish inputs, formulas and results.
- Check references, criteria and changes in the data.
- Communicate results without losing their source.
02 / SEQUENCE
First a skill, then a system
01 · Working foundation
Prepare data before calculating
- 00
Workspace and data
Capturing and organizing data in a clear tabular structure.
- 01
Formatting and presentation
Activity tracking with formatting that supports reading and decisions.
- 02
Formulas, operators and references
Budgets and quotes using relative and absolute references.
02 · Analysis
Turn records into useful information
- 03
Data cleaning and organization
Normalizing, separating and validating data for a usable directory.
- 04
Mathematical and conditional functions
Resource control through calculations and verifiable rules.
- 05
Statistical functions
Grade analysis that turns records into information.
03 · Reporting and integration
Communicate progress without losing context
- 06
Visualization and reporting
Enrollment reporting that communicates results clearly.
- 07
Integration
Learning-path tracking that brings formulas, data and visualization together.
04 · Application
Bring fundamentals into complete cases
- 08
Tables and operational analysis
Construction operations control as an applied tabular-analysis practice.
- 09
Personal financial models
Personal financial control that brings together budgets, goals, debt and outcomes.
Workbooks and instructions are in Spanish and use fictional data. They are learning exercises, not client files.
03 / EVIDENCE
Check the result, not just the formatting
- In 00–07, begin with Practica resuelta; in 08–09, begin with Resumen and trace the calculations.
- Change fictional values and predict which results should update.
- Complete the Reto sheet and read its instructions before editing marked cells.
- Keep your copy and explain a formula, a corrected error and the effect of changing an input.
Before moving on
Move on when you can justify references, distinguish data from calculations and verify results without relying on a template. Workbook availability does not certify mastery.
Explore applied projects →