30 Advanced Excel Tips for 2026

Excel 3D Reference (Write 3D-Formulas)

Formulas are the backbone of Microsoft Excel. They allow you to do calculations, like adding totals, averaging numbers, or finding the highest value without a calculator. There is one thing

Power Query: Functions and Formulas

In Power Query, you can use functions and formulas almost as you use them in a worksheet. Power Query has a long list of functions, and you can write formulas

Excel Wildcard Characters: Types and Usage

What are Excel Wildcard Characters Excel wildcard characters are placeholders that stand in for characters you don’t know. Instead of matching a value exactly, you supply the part you’re sure