Any tips on the best ways to learn advanced keyboard shortcuts?

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

Make it a goal to learn a new shortcut a week. Pretty soon you’ll be using shortcuts without even thinking. Another way is to ditch the mouse and force yourself to learn or be slow...I know lots of people who have done this and it worked

like

Challenge yourself to go 15 minutes without using your mouse. See what you need it for in those 15 minutes, and then memorize the shortcuts. Once you’re consistently going 15 minutes without your mouse, up it to 30, 45, etc.

like

Best advice I was given:
“Learning how to use excel without a mouse is like learning a new language; there’s only one way to do it - practice as much as possible.”
Ditch the mouse and you’ll learn to navigate excel very quickly in a few weeks. Really resist any temptation to use the mousepad. You’ll be a little slower at first, but after you get in the rhythm you will be faster than you ever could be if you used a mouse.
I have a few fundamental shortcuts I use that can be applied to almost anything. My favorite way to learn is to work close to those who are senior to me. Also, whenever I think to myself, “there has to be a faster/better way for this”, there usually is, and I will google it.

like

How advanced? Get a cheat sheet for the basics. Set up your QAT for most common shortcuts. Use alt+ for (most) things in the ribbon. I say most because legacy shortcuts can be much faster. Google “excel shortcut for xx” as needed.

like

Ditch your mouse and/or don’t use your touchpad if you’re using a laptop Lol

like

Related Posts

Hi Sharks,
Looking for opportunities/referrals in MBB in consulting/project management role.Requesting support .

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Any stats on how many people get past 1st phone screening case interview with McK? Also if it’s phone does it mean no charts?

like

Well TSIA already up 100%. I’ll pass on this one

like

what do you talk about in your 1:1s?

I got lucky and now have leadership that seems to care about my career growth, but I'm 1. a little overwhelmed taking over a new role from someone who went on parental leave earlier than expected and 2. not used to thinking outside my day to day job, happy to keep my head down and just produce good work.

most of what I bring up in these meetings are logistical or prioritization concerns but I feel like my manager is expecting a lot more from me.

like

EY experienced staff in valuation salary? Just want to see what the range looks like.

like

Any recent H1 transfers or certified LCA’s for EY? I would like to know about the current timelines and success rate for LCA and H1B transfers in premium processing.

like

Viral VC rejection email making its way around Finmeme accounts c/o Litquidity. Might be the most obnoxious rejection email I’ve ever read. And it’s for a no-name $5M AUM firm in Ohio 💀😹

Post Photo
likefunnyuplifting

Has anybody heard of MOURI TECH? How good is it for SAP ABAP Technology?

like

Oracle India (IDC) - 17 fixed + pf(91K)

Optum global solutions - 16 fixed + pf(76k) + varibale 2.4 L + 2L joining bonus.

which is better to go for? Considering growth and future.

like

Any good recruiters or head hunters in Los Angeles?

like

McKinsey & Company Hi Fishes, Working as Process & Proposal Engineer for Air Pollution Control equipments for various industries. Total experience is approx. 10 years. Now want to switch my career into EY, KPMG, BCG, McKinsey etc. for salary hikes and role change. Please guide me in this regard. BE (Mech), PG (Thermal), MBA (Marketing) Accenture, EY, KPMG, McKinsey & Company, Boston Consulting Group, Tata Consultancy, Capgemini, Cognizant

Does anyone have insight into how strong BCG’s healthcare practice is? Thinking more payer/provider than life sciences or med tech

like

How to prepare to become program manager

like

Y'all really gonna use MLK to sell Ram Trucks?!?!

like

I am a 2nd year Manager, and typically do tech enabled HR Transformation and operating model design. What roles and level should I target in industry?

like

Guy I was talking to didn’t officially invite me to his birthday party, but also didn’t text me throughout the party to ask “hey are you coming”/throughout the night which honestly I took as a sign of disinterest. Now we’re not talking and it feels like we left things on a weird note. Should I move on?

like

I have been at my company for a little less than 4 years now. I’ve had the third highest sales last year out of a team of 50 and consistently the highest outbound calls per week. They told me I can start WFH once I hit $1mil in profit, but then rescinded right before I hit the goal. They have also denied simpler request like time off, when I know they have approved this before for others. I feel super unappreciated, but the money is great. I’m not sure if I should look elsewhere and start over?

like

I have been in the electrical / Electronics field with an exp of 6+ yrs. To be honest these fields do not pay as much as their IT counterparts. People in IT discuss on being underpaid at 20LPA whereas ours is not even half of that. I need to know now is that with 6+ years of industry exp. Can I switch my streams for a well paid job. If yes please do help me out. Even otherwise I am open to suggestions and advice.

likefunny

Hello everyone 👋 I am planning on traveling to Athens for the lst week of February and was wondering if anyone has any good tips for a solo traveler. I really live greek food and amthe architecture and would love to experience the local culture

like

Additional Posts in Excel Genius

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

What are the most typical models you all build

likehelpful

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’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

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
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

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

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

Post Photo
funnylike

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

how do you index or vlookup when the match isn't exact? like one cell has a comma or space after the value...?

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

Excel Fact Of The Day:

An apostrophe before a cell value forces Excel to interpret the value as text. (Continued on next post).

like

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

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

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

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