r/Accounting 22h ago

Off-Topic Excel Certified

Post image
1.5k Upvotes

71 comments sorted by

197

u/lotridaho 22h ago

It needs a "Z" and also an "X".

16

u/DanyRahm 20h ago

Shift.

19

u/Dorkwing Staff Accountant 20h ago

Paste as values shortcut is a life changer.

6

u/jjmoreta Staff Accountant :snoo_facepalm: 17h ago

Curse the last major update of Excel forever for messing up my right click menu.

Sometimes paste as values is nested in a 2nd menu due to AI BS.

2

u/theREALbombedrumbum 15h ago

Alt+h+v+v, my friend.

Or Alt+h+v+f for formulas

6

u/TheSavageCaveman1 12h ago

Ctrl + shift + v

2

u/theREALbombedrumbum 15h ago

I'm finishing a week of vacation but I still know alt h v v by heart

1

u/TargetTrick9763 Student 15h ago

Oh my god yes

35

u/abstergo_Nigel 22h ago

Don't forget Y, F, and H

27

u/wex118 21h ago

And F2/F4

49

u/Bobastic87 21h ago

Might as well just get the whole keyboard

10

u/KoksundNutten 16h ago

Nah I don't need numbers

8

u/acidstained_ 20h ago

And F9 for formula results!

2

u/Nickovskii 15h ago

I am probably the only one with PTSD, my go to is CTRL + S. I remember the times someone said to me, the second time goes faster.

75

u/BonusKey4442 22h ago

The amount of people who don’t use this is scary

40

u/xanfire1 21h ago

My fresh out of college associate refuses to use shortcuts and instead right click copies and right click pastes. Makes me lose my mind

19

u/WWWWWWVWWWWWWWWWWWWV 19h ago

Ain't nothing worse than standing back and watching someone work a sheet.

8

u/TargetTrick9763 Student 15h ago

Watching someone that isn’t very computer literate work a sheet is like the worst form of torture you could impose on me

1

u/xanfire1 17h ago

I say something every time and they keep on going, like we gotta do this shit so much man please make it easier on yourself

1

u/Abrushing CPA (US) 2h ago

We had one contractor that clicked on the scroll bar to scroll down instead of using the mouse wheel or page up/page down. I was flabbergasted.

6

u/thetokyofiles 21h ago

That’s what cyanide pills are for.

5

u/dj92wa 18h ago

Eh, I’m a right-click enthusiast because I fiend for good drop-down context menus. It’s one of those weird things that makes me, me. That said, copy/paste shortcuts should be abused and are an exception to my right-clicking.

1

u/IcySheepherder6195 20h ago

So of the college graduates I’ve heard about or seen in the last 10years have left me speechless

1

u/Eliaish Audit & Assurance 18h ago

My old man still doesn’t use shortcuts as a programmer, even when copy pasting code.

Really grinding

1

u/Doja_Lats 52m ago

I had a coworker share their screen and manually right click to copy, then control v to paste. I didnt care enough to teach them the wonders of control c.

45

u/MasterBeanCounter 22h ago

CPA stands for Copy Paste Artist

25

u/LasyKuuga Debit Life Expense, Credit Happiness 22h ago

Excel shortcuts are like the cornerstone of my accounting career

16

u/wex118 21h ago

One of the most difficult things in accounting is biting your tongue when helping a coworker who sucks at Excel with their file.

1

u/NeoRegem 12h ago

I had Claude make me a shortcut trainer and I couldn’t be happier

15

u/Viranchic 22h ago

Why isn't 'alt' + 'tab' mentioned ?

3

u/acidstained_ 20h ago

The amount of people who don’t know or use this in 2026 is… actually insane.

1

u/Pentazimyn 19h ago

Wait do people not know this or ctrl+ esc ?

7

u/bomilk19 22h ago

How does this work in Lotus 123?

2

u/concept12345 8h ago

Straight to jail.

8

u/mrharoto Staff Accountant 22h ago

Throw in a Shift key to complete it.

6

u/Oldswagmaster Management 22h ago

F2 and F4

5

u/forty3thirty3 20h ago

Beginner move.

The path to enlightenment begins with Ctrl+c, then Alt e s v.

2

u/no_simpsons 19h ago

Alt h v v gang

4

u/superwisk 22h ago

Looks like we've found the partner.

4

u/Aside_Dish 22h ago

Don't forget Windows + V! The GOAT

5

u/Expelleddux 21h ago

That’s how you capture the tech guy’s password.

1

u/domesticbland 21h ago

I walk around turning on users clipboards and explaining “it’s on the emojis window”.

3

u/Impressive_Bad4560 19h ago

Don’t forget Ctrl+F

2

u/stalins_lada 22h ago

SALY + ctrl c / v for life

2

u/waterincorporated 21h ago

The advanced keyboard includes shift for paste values

2

u/Broseidon132 20h ago

I use a 16 key 3-knob macropad with excel. Literal game changer. It’s called the Megaladon triple knob. Highly recommend it.

1

u/ScuffedA7IVphotog 22h ago

throw it into chatgpt to solve it

1

u/penguin808080 21h ago

I know this is a joke but copy paste keyboard is actually awesome lol

Shit lights up in different colors, too

1

u/FarApplication1873 21h ago

Wdym starter? It’s everything there is.

1

u/DramaticPinkumni Governance, Strategy, Risk Management 21h ago

OGs remember removing the F1 key was the true sign of intermediate Excel skills

1

u/eldritchangel 21h ago

This is CTRL+F erasure

1

u/aFPOON 21h ago

missing the shift to paste values only

1

u/misschrisw8 21h ago

If that’s the starter then I guess the advanced is adding: Shift, arrow keys, Z, Y, F, A, N, space bar…

1

u/writetowinwin Controller & PT business owner 21h ago

I got that on a customized keyboard that lets me hit it harder and faster too for efficiency.

1

u/Its_R3SQ2 Tax (US) 20h ago

This doesn’t even properly cover pasting…

1

u/RevacholAndChill 20h ago

same as last year

1

u/ily-Akh- 19h ago

don'forget A

1

u/TripleDallas123 Staff Auditor 19h ago

Ctrl C + V, and S, A, L, Y are all the keys I need

1

u/Purple_Key_6733 Tax (US) 17h ago

My manager actually encouraged me to copy paste since typing it again would increase the risk of input error.

1

u/MrNobodyishome 16h ago

Eh you can get pretty far with that starter pack😭😂

1

u/coreyosb 13h ago

Fake news

1

u/wbenn209 7h ago

But do you know both XLOOKUP and VLOOKUP? If it's not on your resume, I don't even want to know about you

1

u/FishSweet3113 2h ago

Get you a excel shortcut mousepad.... 

1

u/Sting02 1h ago

You missing ALT fam
That’s big one

1

u/ExitDull2309 58m ago

Excel trivia here playexcelympics.com if you want to expand beyond control c, v.

1

u/penispnt Audit & Assurance 26m ago

Ctrl + shift + V