Welcome to Week 3: Calculations, Logic, and Lookups

Learning Objectives

By the end of this week, you will be able to:

• Understand the anatomy of a formula.

• Master the use of basic mathematical and statistical functions (e.g., SUM, AVERAGE,COUNT, MAX, MIN).

• Apply conditional logic using the IF, IFS, SUMIFS, and COUNTIFS functions for basic decision-making in data.

• Utilize text functions (e.g., LEFT, RIGHT, CONCATENATE, TRIM) for cleaning and manipulating text data.

• Utilize essential Date and Time functions (e.g., TODAY, NOW, YEAR, MONTH, DATEDIFF) to extract information and perform time-based calculations.

• Perform lookup functions (specifically VLOOKUP, HLOOKUP and the more modern XLOOKUP ) to combine data from different sheets or tables.

Expected Outcomes

Your practical skill set will dramatically expand, allowing you to perform deep, metric-driven analysis:

• You will be able to perform calculations and summarize key metrics using powerful spreadsheet functions.

• You will deliver a comprehensive analysis report that uses formulas to calculate and clean data.

Let’s transform your clean data into meaningful business metrics!