Essential Excel Tips & Tricks for Improved Workflows in 2026

Excel’s vast functionality can often feel overwhelming, but mastering a few essential techniques can make a significant ...

ChatGPT for Those in Their 40s: It's Okay Even If You're Not Good at Excel! How to Ask AI About Functions You Don't Understand

Have you ever been using Excel and thought, "I want to get a total, but which function should I use?" "I want to count only ...
YouTube on MSN

Cell referencing in Excel (when to add a $ in a cell)

Cell Referencing in Excel — where to add the $ sign (using the F4 key) A clear walkthrough of absolute vs. relative cell referencing using the F4 shortcut. The video presents five examples (from easy ...
How-To Geek

VS Code is the overlooked Excel companion I didn't know I needed

Excel is still my spreadsheet workhorse, but VS Code handles the awkward file-level jobs I don't want Excel touching.

Pivot Tables Replace SUMIFS Formulas with Drag-and-Drop

A pivot table summarizes raw data without complex SUMIFS formulas. Group and analyze thousands of rows instantly using simple ...
YouTube on MSN

Make Excel formulas dynamic with the hash sign

Learn Dynamic Arrays with the Hash Operator in Excel In Excel, the hash (#) sign references dynamic arrays, which automatically adjust as data is added or removed. Dynamic arrays let formulas return ...

IF function, IIF function

Like Excel, Tableau also has an IF function, but the syntax is a bit different. In fact, the IIF function is what corresponds ...
YAHOO!

These 5 Linux command-line tools let you work with Excel spreadsheets from the terminal

The xleak program combines support for Excel files, a default ASCII-art view of data on the command-line, and an interactive TUI. It's purely for viewing data, but its dual-mode approach makes it ...