How many people are keyboard only users? Also, how did you learn to do that and how long did it take to learn?

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

Just learned a new one yesterday. When you press ALT+down arrow on a filtered column to drop down the filter options, press e to jump to the typing field.

like

A colleague mentioned that new hires at her mom’s company had to go 6 months without a mouse, so I tried to limit using a mouse myself. I google any time I don’t know a shortcut, and 99.99% of the time the first result shows exactly what I need. I recommend start slow and pick a couple of tasks you want to shortcut and go from there.

likehelpful

I stopped using a mouse about a year ago. I use the alt key, it was slow at first but I’m pretty quick now. I get faster everyday.

like

For me self taught but I’d also ask if I saw someone do something I’ve never seen before.

like

Self taught. I forced myself to learn 1-2 shortcuts a day, every day for 2 months. Was a little slow the first few weeks. Fast forward 3 years later, I only know of 2 other people more advanced in excel than I am.

like

This was a wonderful question, starting the journey to mouseless!

like

Going keyboard only is a great goal. Love all of the comments. Only thing I would add is since most will have to use the mouse a little bit, learn to use the touchpad or eraser, and get rid of the external mouse. You can save a lot of movement by keeping your hands on or near the keyboard

like

About a month

like

How did you guys learn all the shortcuts? Is there a instructional video u used or just kept googling how to do stuff?

like

It’s def faster to keep your hands on the keyboard rather than switching back and forth from mouse to keyboard.

like

I'm sure it is but how did everyone learn to do that? In school, online tutorial, self-taught?

like

It’s self thought. Try learning one or two shortcuts a day and you’ll get there. For the most part Alt key does all the magic.

like

It’s self thought. Try learning one or two shortcuts a day and you’ll get there. For the most part Alt key does all the magic.

like

Keyboard only is the way to go! I started small, by challenging myself to see if I could go an hour without my mouse. That hour eventually turned into days, and it showed me what I was most frequently using my mouse for. A few quick Google searches told me what shortcuts could replace those clicks, and I wrote macros for the rest. Definitely worth it.

like

Added question, are you guys using keyboard only for everything or only excel? I felt I could make progress in excel by googling shortcuts but could not figure out how to do it in other programs

like

WallStreet Oasis had a great 10 hour video course I went through in undergrad. Helped me be Excel keyboard free walking in as intern which gave me more time to focus on more important things than learning excel.

like

So ... Maybe a dumb question but how do you enable content without using the mouse?

like

Mouse is making a come back with alteryx. I learned my shortcuts by keeping a reference I made of the ones I used and just review it at start and end of day. Eventually you won’t even need it

Self taught over the course of 2 years. Helped that I worked for an investment bank before big 4 and so was encouraged to go mouseless. There are many free resources online just by googling excel shortcuts

Many of you say you learn 1-2 shortcuts a day - how did you choose which shortcuts and what list did you work from to check stuff off?

Related Posts

Anyone else required to put together completely unrealistic timelines?

Upper management's direction is to put together the most aggressive deadlines we can. If we think a project will take 16 months, make the plan for 10 months then there's a chance we may launch in 13 months.

I understand that time to market is important in consumer product goods, but being constantly behind schedule and rushing everything is terrible for the team's morale.

like

Hi All,

I am an SAP EAM certified which is my primary skill. I want to extend my skills, which other module would have more demand as a secondary skill along with EAM?
Like QM/PP etc?
Could you please advise on this?

like

Hi Fishes,
could you please let me know which one will be better to join between these 2.

1. DBS - 23 lpa fixed
2. Ericsson - 23 lpa fixed+ stv 7.15%

Also how is the BSS unit of Ericsson with regards to wlb and job security?

Tech stack- java+ spring boot

like

Any CAIA holders out there? How have you generally been viewed?

like

LADIES: SWEAT, Fitbod or else for HIIT workouts & committing to a routine?

like

सालों, मार खाओगे अगर सोन पापड़ी लाए तो 😂😂

Post Photo
likefunny

IT Audit staff position available in Denver. DM me if interested

like

I had got bonus on April 2021 as i was retained and it was eligible till April 30th 2022 else i had to return the money in full. So, i left the company on May 2nd 2022. I have now received mail abt recovery. I have to pay them the one time bonus in full. I am now wondering how is this one time bonus calculated. Is it i should put down my papers only after 1 year?! The letter says "You will be eligible for this reward if you remain on the rolls of the organization as on April 30, 2022. "Capgemini

like

Anyone ever pay for prep for a FAANG non tech interview prep? I’ve had 2 in the past and never made it to the virtual on site and looking for help for my next one.

like
like

Anyone got contact at Grayling? Hoping to land a job there.

like

I am an International Student who would be completing my post baccalaureate diploma in International Business in Dec 2022. Currently I am researching Freeze Dried Food. Seems like not many people are aware about it but it's a gold mine. My vision is for people like me who don't get time for cook food and make up for Work day and study. I want to solve this problem for them. Do you think this will work. I am still researching about it

like

🐠 who were counseled out & now unable to start a new job due to COVID-19 hiring freezes—were you able to get unemployment? If so, how? Not sure how to answer the application questions about how/why I left the company. TIA for your help

like

Hi All
SAP BASIS and HANA Consultant with 4.5 years of experience. I have a proper and diverse skill set to be an asset if given a chance.
Am trying extensively for ONSITE opportunities but everyone is asking a prior visa. I can self sponsor if required, but getting a visa before offer letter is a tough jump for my financial situation.

In dire need for a referral.

Please help me out as I am Extraordinarily frustrated in my current scenario and badly need a change.

Thanks.

like

I think my last straw may be that I’m on the way to the ER and people are asking me to send my working files over the weekend since I’m “out of pocket” today

likefunny

What’s the normal pay increase from SWE 1 to SWE 2. Not a FAANG company, but Fortune 500.

like

Litigators who practice in civil SDNY! My question, is it true that they are not permitting partial Summary Judgment motions anymore unless you are willing to waive any right to bring any further dispositive motions? I know the EDNY is going that way.

like

How does Freshworks pay US employees? is it 1st and 15th of the month? Every other week? Curious what the pay periods are. Thank you in advance!

like

Is that something that's available to Teachers in Louisiana?

like
likehelpful

Additional Posts in Excel Genius

Is there a way to connect SharePoint and Power BI so that there’s a live data connect for real time updates?

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Alright 🐠, I need some help.
I created a dashboard in excel that shows values that are scraped from different websites. The dashboard values are supposed to update whenever the website...

I have a datetime formatted as <day of month> <hour:minute:seconds> (I.e. 01 02:23:55) in general text. How do I separate day from rest and custom format as actual time stamp? TIA

like

Excel's Conditioning Formatting has a mind of it's own, or is possessed. You define the rule, designate the reference cell/range (goodness knows NOT to use arrow keys within the Edit Rules box... cont

like

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 :(

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

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

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

Am I missing anything? (Yes, I know there are 100,000 401k calculators online)

Post Photo

My firm has workbooks that we roll forward year after year after year. They work great, except for the fact that the number of styles has maxed out, and you can no longer copy and paste data without..

like

Hey guys current TB us set up with columns as company codes and rows as company accounts. Support was received with two columns being codes and accounts. What is the easiest way to update the tb?

Post Photo
like

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

How do I use formulas that reference a pivot table without copying and pasting the pivot as values?

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Dumb question, when I hit (ctrl+shift+down) on column B (data in A) to highlight all rows, my sheet keeps going ALLL the way down to >10,000th cell... how do I make sure it only goes down to my data?

like

I am getting a formula.firewall error in PQ for my merge queries step - I’ve rebuilt both queries (deleted steps in each and recreated them). Is this a security function at my firm or is it something in my model im not understanding?? 😞

like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

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