Here’s a rundown of the tabs and what each one does: Home: This contains commonly used Excel features, such as inserting formulas, formatting tables, rows, cells and text, and sorting and filtering.

This cheat sheet gets you ... As you type, Excel looks through your corporate or personal address book and lists the names and addresses of contacts who match the text you’ve input.

TRIM is a lifesaver if you’re always importing or pasting text into Excel ... the Transpose function comes in. First, select a range of blank cells beneath (or on another sheet) that’s ...

Another widely used, but often confusing feature of Excel is Vlookup-the function by which one looks ... foolishly store numbers like a “0” as text instead of a numeral, which can be a real ...

These Word, Excel, PowerPoint, and OneNote cheat sheets will help ... Microsoft offers three reference sheets for Excel, including Ctrl combinations, Function key combinations, and miscellaneous ...

How to Extract a Substring in Excel ... string and we can still find a character relative to it. Be your company's Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets.