Excel Tutorials

Learn how to use the VBA InStr function to find text inside strings, including syntax, examples, case sensitivity, and common mistakes.

Learn how to clear formatting in Excel using the Clear Formats tool, shortcuts, and other methods while keeping your data intact.

Learn how to create a heat map in Excel using Conditional Formatting, customize color scales, and visualize patterns in your data.

Learn how to use Excel’s SUMIF() function to add values that meet a condition, with syntax explanations, practical examples, and common mistakes to avoid.

Learn how to use Grok in Microsoft Excel to analyze data, generate formulas, clean spreadsheets, create charts, and run financial scenarios using natural-language prompts.

Learn how to track changes in Excel using Show Changes, Version History, and collaboration features.

Learn how to use Excel's XLOOKUP() function with step-by-step examples. We cover the syntax, exact and approximate matches, multi-column returns, and how to fix common errors.

Learn how to use Excel What-If Analysis tools to test assumptions, compare scenarios, and model different outcomes without changing your original data.

Learn how to use Excel Name Manager to create, edit, and delete named ranges and write cleaner, easier-to-maintain formulas.

Master time calculations in Excel. Apply ready-to-use formulas directly to your own data.

Explore simple formulas, modern Excel functions, and newer AI tools to count words in Excel.

Learn how to build clear and accurate waterfall charts in Excel using both built-in tools and manual methods. Explore useful variations such as stacked, dynamic, and vertical layouts.