Comerze › Blogs › Skills & Careers

Excel Shortcuts and Formulas for Accountants: 25 That Save Hours

A few keystrokes can save you an hour a day. These are the ones worth learning first.

By Comerze DeskUpdated 10 November3 min read

Reviewed by Comerze Desk

Shortcut or formulaUse
Ctrl+Shift+LTurn filters on or off
Ctrl+TConvert range to a table
Alt+=AutoSum
F4Lock cell references
Ctrl+Arrow / Ctrl+Shift+ArrowJump or select to the end of data
Ctrl+1Format cells
SUMIFS / COUNTIFSTotal or count with conditions
XLOOKUP or VLOOKUPMatch data from another table (XLOOKUP in newer Excel)
INDEX + MATCHFlexible lookup
IF / IFERRORConditions and clean errors
TEXT, EOMONTHMonth names, month-end dates
Pivot tableSummaries in seconds

3 mini exercises

  1. ReconcileUse XLOOKUP to match invoice numbers from books with GSTR-2B and flag differences.
  2. AgeingUse IF and TODAY to bucket receivables into 0 to 30, 31 to 60 and 60+ days.
  3. SummaryUse a pivot table to show monthly expenses by category.
Pro tipPractise on a messy file

Clean data is rare. Learn Text to Columns, Remove Duplicates and TRIM early.

Foundation: Excel skills commerce students need.

Keep reading

Tools & courses for CA studentsMarketplace