Guides · Formulas · Free tools

Master Excel with Step-by-Step Guides

From basics to advanced techniques, learn Excel efficiently with our comprehensive tutorials and practical examples.

Names.xlsxFormula example

ƒx=TEXTJOIN(" ",TRUE,A2:B2)

Keyboard shortcuts, formulas, functions, and chart references.

Find the days between two dates, or calculate a future date.

A baby shower budget with planned costs, deposits, and remaining balance.

Tutorial library

What are you working on?

Learn Excel with practical tutorials and worked examples.

Find a guide or tool

Filter guides, browser tools, and worked examples.

Try a shorter term, or browse all resources.

Paste a small table or list, or set a working calendar. These tools process your inputs locally.

Choose key columns, review every match, and export the kept rows.

Pair repeated occurrences and inspect items left over in either source.

Count inclusive working dates with your holidays and custom weekends.

Select Formula Type

Enter Excel cell references or expressions; put literal text in quotation marks.

Formula Preview

Input Text

Converted Result

Learn multiple methods to calculate p-values in Excel using T.TEST, Z.TEST, and CHISQ.TEST functions.

Learn how to plot stress data, add yield lines, and analyze component safety factors.

Learn how to use Excel's TEXTJOIN function with step-by-step examples.