Riglabs Collective Logo

📊 Excel Mastery Workshop Lab

Master Excel through hands-on challenges. Complete each challenge to unlock the next.

Progress: 0%

📝 Quick Assessment: Test Your Excel Knowledge

Before we start, answer these 10 questions to establish your starting level.

Basic Skills (Questions 1-5)

1
What is a cell reference like A1?
2
What symbol starts a formula?
3
What does SUM do?
4
How do you make text bold?
5
What does AutoFilter do?

Advanced Skills (Questions 6-10)

6
What does an IF statement do?
7
Which chart shows parts of a whole?
8
What does VLOOKUP do?
9
What is a Pivot Table used for?
10
What does COUNTIF do?

Your Assessment Results

Score
0/10
Answer all 10 questions to see your results...
1

Getting Started: Excel Essentials

⏱️ ~10 minutes

What You'll Learn

  • Create and format a basic data table
  • Apply number formatting (currency)
  • Make your spreadsheet look professional
Task 1.1: Create a Data Table
Beginner

Create a table with 3 columns (Name, Department, Salary) and 3 employee records.

Steps:
  1. Open Excel and create a new workbook
  2. In row 1, type headers: Name, Department, Salary
  3. Add 3 employee records below the headers
  4. Save your file
💡 Tip: Use Tab to move between cells and Enter to go to the next row
Task 1.2: Format Your Headers
Beginner

Make headers bold, add a background color, and center-align them.

Steps:
  1. Select row 1 (click the row number)
  2. Make bold: Ctrl+B
  3. Add color: Home tab → Fill Color
  4. Center align: Home tab → Center button
💡 Tip: Double-click column borders to auto-fit column widths
Task 1.3: Apply Currency Formatting
Beginner

Format the Salary column to display as currency with $ and 2 decimal places.

Steps:
  1. Select cells with salary values (C2:C4)
  2. Right-click → Format Cells
  3. Select Currency category
  4. Click OK
💡 Tip: Or use the $ button in the Home tab for quick formatting
2

Formulas & Functions: Do the Math

⏱️ ~12 minutes

What You'll Learn

  • Create and use SUM and AVERAGE functions
  • Understand how cell references work
  • Copy formulas to multiple cells
Task 2.1: Create a SUM Formula
Beginner

Calculate total salary using the SUM function.

Steps:
  1. Click on cell C5 (below your salary data)
  2. Type: =SUM(C2:C4)
  3. Press Enter
  4. The total salary should appear in C5
💡 Tip: Always start formulas with = and use C2:C4 to mean "from C2 to C4"
Task 2.2: Calculate Average Salary
Beginner

Find the average salary across all employees.

Steps:
  1. Click on cell C6
  2. Type: =AVERAGE(C2:C4)
  3. Press Enter
  4. Add label "Average" in B6
💡 Tip: AVERAGE ignores empty cells automatically
Task 2.3: Create Bonus Calculations
Intermediate

Add a Bonus column that calculates 10% of each salary and copy the formula down.

Steps:
  1. In D1, type "Bonus"
  2. In D2, type: =C2*0.1
  3. Copy D2 (Ctrl+C)
  4. Select D3:D4 and paste (Ctrl+V)
💡 Tip: When you copy formulas, cell references update automatically
3

Data Analysis: Sort & Filter

⏱️ ~10 minutes

What You'll Learn

  • Sort data in ascending and descending order
  • Apply AutoFilter to explore data
  • Use MIN, MAX, and COUNT functions
Task 3.1: Sort by Salary (Highest First)
Beginner

Organize employee data by salary from highest to lowest.

Steps:
  1. Select your entire data range including headers
  2. Go to Data tab → Sort
  3. Sort by "Salary" column, Descending
  4. Ensure "My data has headers" is checked
  5. Click OK
💡 Tip: Always include headers when sorting to keep data aligned
Task 3.2: Apply AutoFilter
Beginner

Add filter dropdowns to quickly analyze data by different columns.

Steps:
  1. Click anywhere in your data
  2. Go to Data tab → Filter
  3. Notice dropdown arrows now appear in headers
  4. Try filtering by Department
  5. Turn the filter off to see all data again
💡 Tip: Filters hide data but don't delete it
Task 3.3: Create Summary Statistics
Intermediate

Build a summary showing MIN, MAX, and COUNT of salaries.

Steps:
  1. In an empty area, create labels: "Min Salary", "Max Salary", "Count"
  2. Below each, create formulas:
  3. =MIN(C2:C4)
  4. =MAX(C2:C4)
  5. =COUNT(C2:C4)
💡 Tip: MIN finds smallest, MAX finds largest, COUNT counts numbers
4

Charts & Visualization: Tell a Story

⏱️ ~12 minutes

What You'll Learn

  • Create different chart types (Bar, Pie)
  • Customize charts with titles and labels
  • Make data tell a compelling story
Task 4.1: Create a Bar Chart
Beginner

Visualize salary differences between employees using a bar chart.

Steps:
  1. Select your Name and Salary data
  2. Go to Insert tab → Chart → Bar Chart
  3. Choose a bar chart style
  4. Click to insert the chart
💡 Tip: Highlight non-adjacent columns by holding Ctrl
Task 4.2: Customize Your Chart
Beginner

Add titles and labels to make your chart professional and clear.

Steps:
  1. Double-click your chart to edit it
  2. Right-click → Add Chart Title
  3. Type a title: "Employee Salary Comparison"
  4. Add axis titles and adjust colors
  5. Click outside to finish
💡 Tip: Good titles make your data story clear to everyone
Task 4.3: Create a Pie Chart (Advanced)
Intermediate

Show salary distribution with a pie chart.

Steps:
  1. Create a summary table with Department and Total Salary
  2. Select this data
  3. Insert → Chart → Pie Chart
  4. Add title and data labels showing percentages
💡 Tip: Pie charts work best with 3-5 categories
5

Advanced Techniques: Conditional Logic

⏱️ ~13 minutes

What You'll Learn

  • Use IF statements for conditional logic
  • Apply COUNTIF and SUMIF functions
  • Create dynamic analyses
Task 5.1: Create an IF Formula
Intermediate

Add a Bonus Level column using nested IF statements.

Steps:
  1. Add header "Bonus Level" in E1
  2. In E2, type: =IF(C2>50000,"High",IF(C2>35000,"Medium","Low"))
  3. Copy to E3:E4
  4. Review which employees get each level
💡 Tip: IF checks conditions; this nested IF has multiple conditions
Task 5.2: Use COUNTIF to Count Conditions
Intermediate

Find how many employees fall into each bonus level category.

Steps:
  1. In an empty area, create a label: "High Earners"
  2. Type: =COUNTIF(E2:E4,"High")
  3. Press Enter
  4. Repeat for "Medium" and "Low" categories
💡 Tip: COUNTIF counts cells matching a specific criteria
Task 5.3: Use SUMIF for Conditional Sums
Advanced

Calculate total salary only for "High" bonus level employees.

Steps:
  1. Create a label: "High Earners Total"
  2. Type: =SUMIF(E2:E4,"High",C2:C4)
  3. This sums C2:C4 only where E2:E4 = "High"
  4. Verify: High + Medium + Low totals should equal total salary
💡 Tip: SUMIF has 3 parts: range to check, criteria, range to sum
6

🏆 Final Challenge: Comprehensive Project

⏱️ ~3 minutes (review)

Your Final Challenge

  • Review and polish your complete work
  • Ensure all formulas work correctly
  • Verify your charts look professional
Task 6.1: Review Your Dashboard
Advanced

Take a moment to review all your work and ensure everything is polished.

Your Checklist:
  1. ✓ Data table with clear, formatted headers
  2. ✓ All formulas calculating correctly (SUM, AVERAGE, IF, COUNTIF, SUMIF)
  3. ✓ Professional charts with titles
  4. ✓ Summary statistics (Min, Max, Count)
  5. ✓ Bonus level categorization
  6. ✓ Consistent formatting throughout
  7. ✓ Clean layout and good spacing
💡 Pro Tip: Imagine presenting this to your manager - does it look professional?
Task 6.2: Create a Summary Sheet (Optional Bonus)
Advanced

Create an executive summary with key insights (optional extension).

Steps:
  1. Create a new sheet tab or use blank area
  2. Add title: "Executive Summary"
  3. Include 3-4 key metrics
  4. Add insights (e.g., "X employees earn above average")
  5. Reference your charts
💡 An executive summary tells the story of your data in 30 seconds

🎉 Congratulations! You've Mastered Excel!

You've successfully completed the Excel Mastery Workshop Lab. You started with the fundamentals and progressed through advanced techniques including formulas, data analysis, visualization, and conditional logic.

6
Segments Completed
18
Tasks Mastered
60+
Minutes Invested
100%
Progress

Next Steps:
Practice these skills with your own data. Build spreadsheets for personal projects, budgets, or work analysis. The more you practice, the faster Excel becomes your superpower!