Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Mission

Mission: the October expense report

Finance wants a summary of October's expenses. Answer their questions with formulas, then build a pivot table.

  1. Total Travel. Finance's questions are in column F. Put the answers in column G. Total spent on Travel, in G2
  2. Two conditions. Food expenses paid by Bram, in G3
  3. Above 100. How many expenses are above 100? In G4
  4. Average Food. The average Food expense, in G5
  5. A pivot table for finance. Finance also wants a quick overview they can filter themselves: a pivot table.

← All lessons