Hey folks! Could you speak for some best practices and habits y’all incorporated to become absolute beasts when it comes to working on excel purely with keyboard?

like
Posting as :
works at
You are currently posting as works at

Use Alt and follow the tips. You'll have them memorized in no time.

likehelpful

Start small. Challenge yourself to go 15 minutes without your mouse. Find the things you need it for in those 15 minutes and learn the shortcuts for them. Then once you can consistently go 15 minutes on the keyboard, up it to 30, an hour, etc.

likehelpful

For re-usable items, create a separate “List” tab. Then, use data validation in sheets to prevent input errors.

like

Related Posts

So I need to find a L1A visa appointment - can I book L1A appointment outside India? In India, the lead time for appointment is huge.

funny

Can someone refer one of my friend at Genpact Uppal Hyderabad??
Profile : senior recruiter.
Exp : 6.5

like

What's the norm of calling your Managers/Counselors in EY GDS? I'm used to calling everyone by their first name in my previous organization, but here I'm seeing people calling managers and seniors managers "Sir".

The thing is I have just joined and pinged my counselor for certain queries, and used his first name and he never responds although he sees my message. 🤔

like

At the beach this morning

Post Photo
likeupliftingfunny

What’s with all the hate against Guidehouse? I just got a job offer with them.

like

A teacher friend sent me this today asking if this is how I teach. I told her I sure would if someone got me that belt! 😂😂😂

Post Photo
likefunny

Hi All,

Hope You all are doing well !

I received following Offer from Atos. How much I will get in hand after all deduction (including taxes)?

Atos

Post Photo

Any PE firms buy up mom and pop businesses or firms with valuations of the 10's of millions?

I am an AI consultant and have a data set of potential opportunities. I would like to partner with your firm.

Insurance, medical, restaurant, and others.

like

Which is the most fascinating zoom call background you have seen in a work call?

like

Calling all remote workers from the UK who are fully embracing or occasionally doing the digital nomad thing, who are you working for and are they hiring? Asking for a friend.

like

Anyone with an equinox membership in NYC that likes playing racquetball? :)

like

Looking for feedback on annual salary for Senior DOT Recruiter. I have 20 years of recruiting management experience, however this is not a management role. Recruiting national CDL truck drivers for a company with 17k employees., also processing the qualifications of each driver candidate and onboarding (full desk).

likehelpful

Can someone explain to me how Tesla trading at 20x sales makes any type of sense

likehelpful

7 YOE Mainframe & Unix
Not good at COBOL
Good Communication
Team playing leading skills
People skills
What may I learn to climb career ladder ?

Hey guys. Can you provide me with any recommendations of practice modelling cases.

like

a PSA you would want everyone to know? i’ll go first, be kind and stay rich ☺️

funnylike

EY vs. Accenture Cyber Security Manager offers. Marginal higher base w/ACN. Which is better WRT career growth and WLB? Echoing previous post from C1.

like

I have a offer with landis gyr of 20 LPA
YOE- 8 years
Stack- QA(manual)
Is this at par with industry standard?
Have offer with iRis as well

Which company to choose

like

ZS hike letters are out. What a shitshow. Worst performance in years considering the market.

like

Additional Posts in Excel Genius

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

What are your top Excel ninja tricks? Ones that few people know...

like

Hey, tips for where to look for good excel cheat sheets online? :)

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal