Excel · Core Formulas

Core Formulas

The complete Core Formulas module for Excel for Data Analytics — structured into 13 sections, from basic calculations to real-world formula combinations.

Sections

13 sections · Lessons coming soon

Core Formulas

Sections

Basic Calculation (Foundation)

Logical Functions

Conditional Calculation

Lookup & Reference

Text Cleaning & Transformation

Date & Time Analysis

Dynamic Array Functions

Statistical Analysis

Error & Information

Database Functions

Data Summarisation

Modern Excel Functions

Real-World Formula Combinations