Module 2 – Working Smarter with Excel

This Excel formulas workshop helps teams work smarter by using formulas correctly, reducing manual work, and improving confidence in everyday spreadsheet tasks.

This is an intermediate session focused on improving how your team uses formulas in real scenarios.

Who it’s for

• Users with a good basic understanding of Excel
• Teams who use Excel regularly for calculations and reporting
• Anyone wanting to move beyond basic formulas and work more efficiently

What you’ll learn

• How to build and structure formulas correctly
• Using logical functions to make decisions within spreadsheet
• Working confidently with text functions and data manipulation
• How to avoid common errors that lead to incorrect results

Training content (what we cover)

• Relative and absolute cell references
• SUM and SUMIF functions
• AVERAGE and AVERAGEIF functions
• XLOOKUP for efficient data retrieval
• IF function for logical calculations
• Using helper columns to simplify complex tasks
• LEFT, RIGHT and MID functions
• Splitting text strings effectively
• CONCAT function for combining data
• Using Flash Fill to automate patterns

What this means in practice 💜

• Reduce errors in calculations and reporting
• Build more reliable and structured spreadsheets
• Work faster by automating repetitive tasks
• Handle real-world data more confidently

Details

• Duration: 3 hours
• Small group training (maximum 6 participants)