Skip to main content
close search
site logo
Wayne Spivak's headshot
Wayne Spivak President & CFO

Fantasy Excel Shortcuts

Asked on June 27, 2014

I was having a drink with a fellow CFO and we got to the subject of Excel and what type of shortcuts we would want and what types our employees might want. We came up with several, here's a few: ALT MB which would (our/there) "MUTE BOSS" CTL FFM which would hopefully "FAST FORWARD the MEETING" and some of the junior members of the staff would really appreciate this shortcut: ALT UCS which would fix the mess by "UN_CONFUSING SPREADSHEET" What would be your favorite Fantasy Excel Shortcut? Enquiring minds need to know!~

Answers

Jaime Campbell's headshot
Jaime Campbell Chief Financial Officer • June 27, 2014

Alt+RCR = Remove Circular Reference
Removes a circular reference and substitutes the correct figure, formula, Goal Seek iteration, or input cell.

CTRL+SHIFT+$ = Close deal with prospect

CTRL+SHIFT+$$ = Upsell

For employees:

CTRL+SHIFT+% = Get a raise

Len Green's headshot
Len Green Performance Improvement Consultant and ERP Strategist • June 27, 2014

SHIFT+UT
Hide You Tube videos
SHIFT +ESPN
Stop watching the world cup

EMERSON GALFO's headshot
EMERSON GALFO CFO • June 27, 2014

SHIFT + MR (mind read) = format the worksheet according to what is on my mind

Sarah Jackson's headshot
Sarah Jackson Associate Editor • June 27, 2014

Wayne, I wouldn't mind CTRL + SHIFT + S2F.... Skip To Friday.

On a more achievable goal, here's a treasure trove of free excel spreadsheets, free accounting spreadsheets, plus all kinds of other excel resources, such as tests, tutorials and more:

https://www.proformative.com/resources/free-accounting-spreadsheets-valuation-budgeting-waterfalls-more

Plus, this actual (non-fantasy) "Excel Shortcut Cheat Sheet"

https://www.proformative.com/whitepapers/excel-shortcuts-cheat-sheet

Enjoy!

Best... Sarah

Vivek G's headshot
Vivek G PMM • June 30, 2014

CTRL+SHIFT+YS ...make all agree with the numbers.
CTRL+SHIFT+AUTO .. auto generate the results needed.

Mark Matheny's headshot
Mark Matheny VP - FInancial Planning and Analysis • June 30, 2014

ALT DS (Deep Search) find the other dozen times I have done this analysis but can't remember where I filed it.

Larry Conrad's headshot
Larry Conrad Accounting Manager • June 30, 2014

As suggested by another manager in the office...

SHIFT+MEFI ..... Make Employees Follow Instructions

Len Green's headshot
Len Green Performance Improvement Consultant and ERP Strategist • June 30, 2014

If I sold software such as modeling/forecasting tools, I may use the following shortcut SHIFT+ that launches a free trial:)

Tobias Crush's headshot
Tobias Crush Director of Finance • June 30, 2014

A couple that would be particularly handy would be:

Ctrl + BB - Build budget model
Ctrl + AB - Auto-populate Budget model
Ctrl + SB - Sign off Budget!

As you can probably tell, budgeting has been the order of the day for me lately!

John P. Martin's headshot
John P. Martin Analyst - Finance • July 1, 2014

SHIFT + SI...Simplify information...for non accounting/finance staff (to C-level)...and...
@Sara Jackson...thank you for providing the "treasure trove" of free excel spreadsheets and free information. Best-John

Jaime Campbell's headshot
Jaime Campbell Chief Financial Officer • July 1, 2014

And the fantasy formula of the day:

Takes the argument of Jaime being up all night again working on a financial modeling project and evaluates her clarity vs. whether she is going to pass out at any moment.

=IF(ISLOGICAL("Jaime"),CONFIDENCE.NORM,IF(OR(ISBLANK("Jaime"),ISODD("Jaime")),FIND(FLOOR(NOW())))

Stephen Glenn's headshot
Stephen Glenn Controller • July 2, 2014

As a controller for a SMB I am also responsible for HR, healthcare, benefits, SIMPLE IRA...

Ctrl + RSCF = Return Signed & Completed Forms

Also useful would be the following:

Ctrl + UIGLTYASQ = Use Info Given Last Time You Asked Same Question

Doug Skinner's headshot
Doug Skinner Director of Business Development • August 26, 2014

As a training advisor for bookkeepers, I'd like to introduce
Alt + Shift + M = Change your mindset about spreadsheets

Want to join the conversation? Submit an answer or ask a question by emailing us at [email protected]

Submit an answer
Industry Dive is an Informa TechTarget business.
© 2024 TechTarget, Inc. or its subsidiaries. All rights reserved. | View our other publications | Privacy policy | Terms of use | Take down policy.
Cookie Preferences / Do Not Sell
This website is owned and operated by Informa TechTarget, part of a global network that informs, influences and connects the world's technology buyers and sellers. All copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. TechTarget, Inc.'s registered office is 275 Grove St. Newton, MA 02466.