A Practical 30–60–90 Day Roadmap to Advanced Excel for Data Analysts


First 30 Days: Build Strong Foundations

Aim: "Stop using Excel like a spreadsheet and start using it like a data tool"

What to learn:

IF, IFS, TEXT, LEFT, RIGHT, TRIM, LEN

  • Cleaning, structured datasets without breaking formulas.
  • Working with Excel Tables
  • Structuring data cleanly
  • Reducing manual work
  • Converting ranges to Tables
  • Structured references
  • Basic data cleaning

Practice:

1.Take a messy dataset and clean it
2.Separate raw data from analysis
3.Sorting and filtering properly

Up to day 60: Analytical Excel Skills

Aim: "Start using Excel to analyse data, not just store it."

What to learn:

  • Lookup logic:
    XLOOKUP, INDEX + MATCH

  • Aggregation:
    SUMIFS, COUNTIFS, AVERAGEIFS

  • Pivot Tables for exploration

  • Conditional formatting for validation

Practice:

  • Build KPIs from raw data

  • Validate numbers using multiple methods

  • Use pivots to answer “why” questions

Days 61 to 90: Advanced & Professional Use

Aim: "Use Excel like an experienced analyst supporting decisions."

What to learn:

  • Data validation rules
  • Logical testing for edge cases
  • Power Query basics (optional but powerful)
  • Connecting multiple tables logically
  • Building reusable templates

Practice:

1.Create a small analytical model end-to-end
2.Add validation checks
3.Stress-test your logic with edge cases

Advanced Formulas and Functions to remember

  • LOOKUP functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX + MATCH
  • Logical functions: IF, IFS, AND, OR, SWITCH
  • Text functions: TEXTJOIN, CONCAT, LEFT, RIGHT, MID, TRIM
  • Date & time functions: EOMONTH, NETWORKDAYS, DATEDIF
  • Dynamic array functions: FILTER, SORT, UNIQUE, SEQUENCE


Comments

  1. Sam30 January 2026 at 10:19

    Really enjoyed your Excel roadmap it was clear and practical. It made me think that building strong analytics skills is actually doable step by step, not something out of reach.

    ReplyDelete

Post a Comment

Popular posts from this blog

What Senior Data Analysts Actually Do (Beyond Dashboards)

  When people hear “data analyst,” they often imagine dashboards, SQL queries, and spreadsheets. Those skills are important. But at a senior level, the role moves far beyond building reports. A high level data analyst designs systems. They create structure. They ensure that data flows cleanly from source to insight, and that insight translates into better decisions. The focus shifts from producing outputs to building reliable decision infrastructure. This difference is subtle but critical. From Reporting to Decision Architecture At an operational level, analysts answer questions. At a strategic level, analysts define how questions should be answered. Senior analysts think in terms of: What decisions does the organisation need to make? Which metrics truly represent performance? Are definitions consistent across teams? Can this analysis scale beyond a one off request? Instead of reacting to ad hoc reporting needs, they establish frameworks that prevent fragmentat...
Read more

The Future of Food Safety Tech: How AI Driven Transparency Can Transform Global Consumer Health

Image
  Extending the FoodSense concept beyond India through responsible data systems and applied machine learning The global food safety challenge Food safety challenges are not confined to geography. They appear in different forms across countries, but the underlying risks are shared. Allergen exposure remains one of the most preventable causes of severe food related harm, yet communication failures continue to occur. Expiry dates are frequently misunderstood by both consumers and businesses, contributing to avoidable illness on one end and large scale food waste on the other. These issues place sustained pressure on public health systems worldwide. What varies between regions is not the existence of the problem, but the maturity of the systems designed to manage it. Effective food safety today requires more than compliance. It requires visibility, consistency, and decision support at the point where food is prepared, stored, and consumed. Why AI is an appropriate tool in this do...
Read more

Inside the Smart Food Safety System: Architecture, Data Pipelines, and ML Models Explained

Image
  A deep technical walkthrough of the data pipelines, algorithms, and design decisions behind my food safety prototype Architecture overview Once the prototype moved beyond experimentation, I needed a structure that could survive real-world input. Food labels are noisy. OCR is imperfect. Safety decisions cannot rely on a single model prediction. The architecture reflects that reality by separating concerns clearly and defensively. At a high level, the system flows as follows: Image / Label Input ↓ OCR + Text Parsing ↓ ETL + Validation Layer ↓ Feature Engineering ↓ Freshness ML Model ↓ Rule - Based Safety Engine ↓ Human - Readable Output Each layer can fail safely without corrupting the next. Data Engineering layer (ETL, validation, anonymisation) This layer exists to answer one question: Can this data be trusted enough to make a safety decision? ETL ingestion Raw inputs enter the system either as: OCR extracted ...
Read more