Best source to learn excel shortcuts?

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

Whenever you open excel, throw your mouse away. If you force yourself to use the ALT/CTRL shortcuts, you will learn in no time. And excel guides you to use all ALT shortcuts

That being said, there are some things I still use the mouse - selecting font colors for example, it's faster if you use the mouse

like

I like the 2003 shortcuts, they're quicker to type compared to the ribbon since you don't have to watch it animate through your selections.

You can just disable animations tho - although I'd check your pc/hardware, mine doesn't make any significant difference

YouTube, Chat GPT or Copilot.

Related Posts

I feel like the stereotype about being an introvert and an accountant don't apply to black ppl. Everyone I met that's an accountant is LOUD, okay lol

like

Company gave me an offer but is only giving me 3 or 4 days to respond. Is this common? Seems like a red flag to me

like

Hi fishes
currently working in India with salary of 37lpa and over 7 year of experience as senior data analyst. Recently got a call from a company in Tallin Estonia. What is the average salary in Estonia for 7+ year experience as senior data analyst. And is it recommended to go with the opportunity.

like

Do you guys ever feel like you're 'too Asian' in the workplace but 'not Asian enough' when it comes to family/friends? My morals are rooted in Asian traditions, but can't speak my native language well

like

What is the best way to get early adopters participating in the community before officially launching it? We want it to look like a lively place before new folks pop in.

like

Any star alliance status match delta platinum?

like
like
like

What will be the case if client doesn't like my performance.

Will they release me from there project before contract ends or any action in terms of termination from job will be taken by client or Nagarro.

Just wanted to know, has anyone went through this kind of situation???

like

What are first steps to building a real estate portfolio? I want to have at least 50% of my income be passive by the time I’m 30. I’m 24yo now, have saved up some, don’t have student loans or any debt. I have two brothers who is helping with college though and really need to be creative. Totally willing to adjust my lifestyle to reach this goal but just am not sure where to even start.

like

Hi Folks,
Lately I was a Product Manager with a startup.. 2 months back I lost my job because the company is closed.

Now my past company CTO is asking me to join his current company as Product Analyst again it's a 4 year old company.

From a PM to a PA role will this affect me in my career.

Please help me with this...

Audit Financial services - what can a SM 1 make. Newly promoted this year- waiting for a comp discussion. HCOL (Bay Area). Any inputs?

like

What is tcs vpn name to connect via cisco anyConnect?

like

How fair is it for the firms to pay different salaries for the same work in different countries? or lower salaries to employees from the developing nations even though they might be working directly with the client or leading projects?
Cost of living is definitely one factor but how would you counter when a Consultant from Mexico and a Consultant from US want to go on a vacation to UK?

funnylike

Hi fishes,

Just wanted to know, honeywell has office in Delhi ncr ???

like

Need serious career advice about two jobs prospects. DM me please

like

Looking for electric shavers recommendations primarily to shave my head

like

Additional Posts in Excel Genius

Still don't have xlookup. #fomo

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

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

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

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

Scan your QR code to download
Fishbowl app on your mobile

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