Excel Shortcuts for Finance and Accounting

@gramajoconsulting

97.9K followers · usually 8.6K views a post

Views

204.9K

Likes

19.6K

Comments

100

Shares

880

SoundTikTok sound · original sound - gramajoconsulting

Promoted product

Excel for Accountants coursegramajo-consulting.com

404: NOT_FOUND

3 videos

Why it worked

The video provides practical, actionable tips for a specific professional audience (finance and accounting) using common software (Excel), addressing a clear pain point (messy data) with efficient shortcuts. The clear demonstration and call to action for a relevant course likely resonated with viewers seeking to improve their skills.

Summary

This video demonstrates several essential Excel shortcuts for finance and accounting professionals to clean and organize messy data. It covers clearing formatting, selecting and deleting rows, auto-fitting columns, applying filters, and converting data into a table.

Structure

1Introduction to messy data and the need for shortcuts
2Clearing formatting with Alt+H+E+F
3Selecting and deleting rows with Shift+Space and Ctrl+-

Original caption

Use code “10OFF” for $10 off the course. #accounting #accountant #excel #exceltutorial #exceltips

More from @gramajoconsulting

Product placement

Microsoft Excel: acts - it is used to organize and manipulate financial data, and its features are demonstrated to show users how to perform specific tasks like clearing formatting, selecting rows, and applying filters. Removing it would change what happens in the video.

Call to action

Hit the link in my bio to check out the Excel for Accountants course that I created where I walk you step by step on how to do this.

On-screen text

Excel Shortcuts for Finance and Accounting

Transcript

If you can't do this in Excel, you're studying accounting, you are falling behind. When you get messy data, you're gonna hit control A, then you're gonna hit Alt H E F, and you're gonna clear all the formatting. Then you're gonna hit shift spacebar, shift up, and then control minus sign to delete the rows so that the headers that I want are at the top. Then you're gonna hit control A again, then you're gonna hit Alt H O I to fit the columns. Then you're gonna hit control shift L to hit the filters on here. Some people like hitting control T, enter will shift this into a table. And the last thing I want to do for this specific workflow is filter for invoice status. Alt down to enter the filter. E to go search. And I only want the invoices that are done. So I'm gonna write done and hit enter. And then I'm gonna get the data that I want. If you're feeling unprepared in Excel, make sure to hit the link in my bio to check out the Excel for Accountants course that I created where I walk you step by step on how to do this. I'm releasing a Power Query module next week where the price is gonna go up a little bit. So you want to get at the discounted price. Make sure to check out that link in the bio.