Excel Hub

Three roadmap levels

Pick the level that matches your work today and move one step at a time. [EDIT] Confirm the roadmap items before publishing.

Beginner

Start with basics

Five items to get comfortable in any spreadsheet.

1. Cell references and ranges. 2. Basic formatting. 3. SUM and AVERAGE. 4. Sorting a list. 5. Freezing header rows. [EDIT]

Intermediate

Work with data

Five items for handling larger lists and reports.

1. IF and nested IF. 2. VLOOKUP and XLOOKUP basics. 3. Filters and slicers. 4. Pivot tables. 5. Conditional formatting. [EDIT]

Pro

Automate the routine

Five items for repeat work and clean summary sheets.

1. Data validation lists. 2. Named ranges. 3. INDEX and MATCH. 4. Remove duplicates safely. 5. Simple macros for repeat steps. [EDIT]

Learning Paths

Routines from 12 years in MIS

Office work runs on small habits. These routines helped me keep reports on time and files easy to find. [EDIT] Adapt them to your own team.

1. Name files with date and topic. 2. Keep one summary sheet and update it at a fixed time. 3. Save a copy before large changes. 4. Review formulas once a week. [EDIT]