Quick formula hacks with SUMIF and COUNTIF

Get more flexibility and speed from SUMIF and COUNTIF functions, whether you are new…

Save time with data tables

Quickly organize your data into tables for faster updating, while keeping references, totals and formats updated…

Group rows or columns

Quickly show or hide rows or columns by grouping them together.

Jump to linked cells quickly

Still using the slow way to audit formulas? Trace cell precedents and dependents in an instant with these…

Absolute and relative references

Use absolute and relative references to control whether your formulas stay the same or update when…

Export or print multiple sheets

Want a single document exported or printed from multiple sheets? Here’s how to get consistent page…

Tip of the week: Go to chosen cells quickly

Select the cells you want to go to using the keyboard, fast… no matter where they…

ExcelQuicker.com Tip of the week

Get the Tip of the week from ExcelQuicker.com direct from our website. Finish spreadsheets faster —…

Insert a chart with a single keystroke

Make a new chart in no time with this simple keyboard shortcut.

Navigate worksheet tabs quickly

Still clicking with the mouse to change tabs? Upgrade to a quicker…