Free Excel Guides

All our guides on Excel formulas and functions, explained simply with practical examples. Pick the topic you need and get started right away.

Basic Excel formulas

SUM, AVERAGE, IF, VLOOKUP and the essential formulas explained from scratch.

Excel conditional logic: if the condition is true do X, otherwise do Y.

Look up a value in a table and return the matching data.

Sum only the cells that meet a specific condition.

Count cells that meet specific criteria for reports and statistics.

Calculate date differences, deadlines and periods automatically.

Join, split and clean text: CONCATENATE, LEFT, RIGHT, MID.

Summarize and analyze large amounts of data in a few clicks.

Create clear charts to visualize your data.

Automatically highlight cells based on their value.

Automate repetitive tasks without writing complex code.

Turn a sheet of raw data into useful insights.

With AutoExel you describe what you want in plain language and the AI builds the formula and analyzes the data for you.