Practice Excel
Sharpen Your
Excel Skills.
Practice Excel formulas and PivotTables with real datasets, hints and checked answers. Choose a topic and difficulty, build your solution, then use feedback to improve.
- Completed
- 0
- In Progress
- 0
Your progress
Progress you earn.
Each completed challenge is a working Excel solution. Pick a task, give it a try, and check your answer.
Practice Library
90 of 90 challenges
- Easy100 XPQuestion 01Math
Calculate Total Monthly Sales Revenue
You work as a Sales Analyst for an electronics distributor. Calculate September revenue from selected orders, late adjustments, and additional sales.
Public
- Easy100 XPQuestion 02Math
Find the Average Daily Sales Amount and More
You are a Sales Analyst for an electronics store. Your manager wants to compare average daily sales across reporting periods and selected days, including late reports and a day with no sales.
Public
- Easy100 XPQuestion 03Math
Identify the Highest Sale
A September electronics order log contains 24 purchases across website, retail and distributor channels. Find the largest recorded order value.
Public
- Easy100 XPQuestion 04Math
Identify the Lowest Sale
Three neighbourhood outlets recorded 18 purchases. Find the smallest receipt amount across all outlets.
Public
- Easy100 XPQuestion 05Math
Count Sales Transactions
A sales register contains 40 purchases made during September. Transaction numbers have gaps, and some customers bought more than once. Count the recorded transactions.
Public
- Easy100 XPQuestion 06Math
Total Sales by Salesperson
Five salespeople handled 32 electronics orders across seven cities. Calculate the total order value credited to Asha.
Public
- Easy100 XPQuestion 07Math
Count Orders from Mumbai
A delivery register contains 45 orders across nine cities. Count how many orders have Mumbai as their delivery city.
Public
- Easy100 XPQuestion 08Math
Average Sale for Electronics
A mixed-category sales report contains 36 purchases with different quantities. Find the average order value for Electronics.
Public
- Easy100 XPQuestion 09Math
Total Revenue by Category
A monthly report lists 28 sales across five product categories. Calculate the total revenue from Furniture sales.
Public
- Easy100 XPQuestion 10Math
Calculate a Running Sales Total
A shop recorded daily sales for all 30 days of September, including three days with no sales. Build the cumulative sales total for the month.
Public
- Easy100 XPQuestion 11Math
Count the Company Employees
The permanent-staff directory lists 28 employees. Some new employees are still waiting for their work email. Count everyone listed using their employee ID.
Public
- Easy100 XPQuestion 12Math
Count Employees by Department
A people-operations register lists permanent, fixed-term and part-time employees across office locations. Count HR and IT employees separately, including every employment type.
Public