Tableau vs Excel: Which Should You Learn First in 2026?

Question: Total sales by region

1. Put data in a table (Ctrl+T), name it Sales
2. Formula for one region:
   =SUMIFS(Sales[Amount], Sales[Region], "North")
3. Or Insert > PivotTable
   Rows: Region   Values: Sum of Amount
4. Add a column chart from the pivot

Skills practised: tables, SUMIFS, pivots, charts

Question: Total sales by region

1. Connect to the Excel or CSV file
2. Drag Region to Rows
3. Drag Amount to Columns (SUM is applied)
4. Choose a bar chart from Show Me
5. Drag Region to Color; add a Region filter
6. Add the sheet to a dashboard

Skills practised: dimensions, measures, chart choice, filters

Profit margin per row:
=IFERROR([@Profit]/[@Sales], 0)

Look up region manager from another table:
=XLOOKUP([@Region], Managers[Region], Managers[Name], "Not found")

Count orders above 10,000 in North:
=COUNTIFS(Sales[Region], "North", Sales[Amount], ">10000")

Clean extra spaces from customer names:
=TRIM([@Customer])

// Profit margin
IF SUM([Sales]) = 0 THEN 0
ELSE SUM([Profit]) / SUM([Sales])
END

// Order size band
IF [Amount] >= 10000 THEN "Large"
ELSEIF [Amount] >= 2000 THEN "Medium"
ELSE "Small"
END

// Clean names
TRIM([Customer])

Excel dashboard layout (one sheet)

Row 1:  Title + date range
Row 2:  KPI cards: Total Sales | Orders | Avg Order Value
        (cells linked to pivot results, e.g. =GETPIVOTDATA(...))
Row 3:  Line chart: sales by month (from pivot)
Row 4:  Bar chart: sales by region | Top 5 products table
Right:  Slicers for Region and Category connected to all pivots

Tip: keep raw data and pivots on hidden or separate sheets.

Tableau dashboard layout

Sheets:
  KPI sheet       Text table with SUM(Sales), COUNTD(Order ID)
  Trend sheet     MONTH(Order Date) vs SUM(Sales), line
  Region sheet    Region vs SUM(Sales), bar, sorted
  Product sheet   Top 5 products (filter: Top N by Sales)

Dashboard:
  KPIs on top, trend in the middle, region and product below
  Region sheet used as a filter action for the others
  Category filter applied to all sheets

Weeks 1-2   Excel basics: tables, formatting, SUMIFS, COUNTIFS
Weeks 3-4   Lookups (XLOOKUP), text and date functions
Weeks 5-6   Pivot tables, charts, Power Query cleaning
Week 7      Excel dashboard project
Weeks 8-9   Tableau basics: dimensions, measures, chart types
Weeks 10-11 Calculated fields, filters, dashboard actions
Week 12     Tableau dashboard project using the same data

Project A (Excel): Sales report with pivots, slicers and a
                  one-page dashboard
Project B (Tableau): Same dataset rebuilt as an interactive
                     dashboard with filter actions

Write one paragraph comparing what was easier in each tool.
Interviewers like this comparison.

Excel
[ ] SUMIFS, COUNTIFS, XLOOKUP, IFERROR
[ ] Pivot tables and slicers
[ ] Power Query basics

Tableau
[ ] Dimensions vs measures
[ ] Calculated fields and table calculations basics
[ ] Filters, parameters, dashboard actions
[ ] Publishing to a public profile (non-sensitive data only)