more-arw search

Q&A Forum

Fantasy Excel Shortcuts

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

Topic Expert
Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

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
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

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

EMERSON GALFO
Title: CFO
Company: C-Suite Services
LinkedIn Profile
(CFO, C-Suite Services) |

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

Sarah Jackson
Title: Associate Editor
Company: Proformative
(Associate Editor, Proformative) |

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
Title: PMM
Company: Replicon
(PMM, Replicon) |

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

Mark Matheny
Title: VP - FInancial Planning and Analysis
Company: Novolex (formerly Hilex Poly)
(VP - FInancial Planning and Analysis, Novolex (formerly Hilex Poly)) |

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

Larry Conrad
Title: Accounting Manager
Company: State Auto Insurance
(Accounting Manager, State Auto Insurance) |

As suggested by another manager in the office...

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

Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

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

Tobias Crush
Title: Director of Finance
Company: Piper Alderman
(Director of Finance, Piper Alderman) |

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
Title: Analyst - Finance
Company: Own
(Analyst - Finance, Own) |

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

Topic Expert
Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

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
Title: Controller
Company: Pierre Frey, Inc.
(Controller, Pierre Frey, Inc.) |

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
Title: Director of Business Development
Company: Audit Associates
(Director of Business Development, Audit Associates) |

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

6195 views
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.