{ "media_type": "text", "post_content": "What are your top Excel ninja tricks? Ones that few people know...", "post_id": "6132611c90e92e0021ffb9de", "reply_count": 33, "vote_count": 10, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }
null

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

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

I’ve written many of my own buttons that make my life easier, such as:
• Jumping to the end / beginning of a worksheet
• Unhiding all hidden and very hidden sheets (you can’t unhide multiple sheets at a time)
• Unprotecting password protected cells and objects
• Automating some regular tasks such as daily web scraping, pdf and email reports, etc.

Also, if you don’t know the Alt shortcuts, then you’re losing a significant amount of time!

like

VBA mostly, although python can also be used

like

There are hundreds of tricks. The ones I've found most useful regarding formulas:

- Using a Vlookup set as close match inside a Vlookup with exact match significantly decreases the time taken to perform a Vlookup (also works with index match/Xlookup)
- Using conditional sumproduct (without ifs)
- using abs min and index match to perform closes match for values

For other purposes:
- Alt + ; to select only visible cells
- Center across selection (PLS FOR THE LOVD OF GOD DO NOT MERGE CELLS)
- Reference dynamic arrays

likesmart

is there a shortcut for center across selected cells? or a ribbon key

Recent IconRecent

Copy down only on visible cells: ctrl+D. I just use it as my default way of copying down but where it comes in really handy is if you are on a filtered set of cells that you need to copy a value or formula down only on those visible filtered cells and not the full range including those cells that have been filtered out.

likesmart

Ctrl + R does the same thing but to the right!

like

Not using a mouse. If you do everything with the keyboard, with repetition and muscle memory, you can slice, splice and dice small data (<20k rows) at the speed of thought!

likeuplifting

Pivot table: mouse is most optimal. But you can construct a sumif/average if/countif table almost as fast with keyboard if you practice. Build the frame of your table, then fill in with formulas. I use both methods… One con of pivot table is that it makes your Excel file really big

like

Also my main tip is getting a Bluetooth mouth with the side buttons that you can program to quickly flip between tabs.

like

Is it better than Alt Tab?

like

Alt,H,O,I

Adjust autofit all column widths

like

And ALT,O,C,A autofits only selected column widths

Download ASAP utilities. It has saved me so much time.

like

I don't have Excel Ninja skills yet but I am working on it.
I use concatenate, proper, round up, countifs,sumifs, and Vlookup most of the time with multiple sheets and files. I would really like to learn how to do multiple if statements combined with a Vlookup. For instance if the work schedule rule is true to another work schedule and the date is on a Wednesday then the cell must be marked as a training shift day.

like

This is pretty basic, but using F5 to go back is very convenient if you have a lot of tabs.

Opening a new excel window of the same spreadsheet to be able to "alt+tab" between spreadsheet tabs

Power query. It is so powerful

Related Posts

Best Marriott in Zurich?

like

What are your thoughts on MAR (Marriott) stock? It’s $64, lowest price since the pandemic crisis began.

like

Anyway to buy certain fare class at Delta, like Y and B?

like

I see you are deboarding this flight I am supposed to get on in 5 minutes. Tell me again how we're going to have an on time departure.

like

Flying United today without status. Does anyone have an extra drink coupon or two? ❤️ ❤️ ❤️

like
like

Is there always some air turbulence at the end of runway at PHX? My AA flight landing had to be aborted 100-200 feet above and the takeoff yesterday with SW was super shaky. I thought end was near.

like

How do you travel with a baby? Planning summer in Europe and all i can think of is how to get around with at least one luggage, a stroller, a car seat and a baby. Help!

like

Can we do a match between spg, Delta and Emirates? What is world rewards?

like

If I pay down a bunch of credit card debt, how quickly would it reflect in the 3-bureau credit reports? Going through some pre-approvals for mortgage, and not sure how quickly I will see the credit score go up. Maybe not really worth it in the end if I’m already at 775?

like

Just randomly browsing through Expedia. Check out hotel rates in Manhattan

Post Photo
like

In Phuket for the weekend! Gotta love flex travel 🏝🏖

like

I have the Star alliance Gold status. I have international travel coming up through Turkish airlines. Can someone tell me how much excess baggage ( check in ) will I be allowed if I have Star alliance Gold status? I tried calling Turkish twice and both times I got different responses. Their website doesn’t really specify anything. Turkish’s Elite status is equivalent to Star alliance gold and allows 20kg additional/ 1 extra bag.
Can someone please confirm? Thank you in advance!

like

Left to industry but have been bored and unfulfilled. I find myself actually missing things like the travel and fast pace. Has anyone gone back to consulting?

like

On my flight home, I searched men’s red sweater Nordstrom, clicked on the link and it takes me to a page with men’s jockstraps. I’ve never been more embarrassed when the guy sitting next to me 👀

like

People at Southwest gate lining up while people are still deplaning. Uh, do you understand how this works?

like

Anyone in Bay Area? I’ve just come back from international travel and I don’t cook or keep groceries at home with this job. Single, live alone. All stores seem to be sold out of basics and frozen food

like

🐡: Planning to book an SUV for a ski trip later this year. Trying to find the Uncle D discount code on the Travel landing page and the actual web app. No success. Can someone please help me?

like

What was the 2016 flying reqs for united Global service last year?

like

How many moves between firms is too many? 6 years out of school with 3 firms on my resume, 2 years each. My resume tells a good story of upward trajectory and internal promotions, but I am nervous that I may have one more jump left (if that) before I get labeled a flight risk who jumps too often. Any interviewers or recruiters on here who can weigh in?

like

Additional Posts

Hey y'all... 3-part question:

I'm 32, currently single & not dating... so considering egg freezing. For those that have done it, what was your experience like?

My gynae recommended kindbody - any personal experiences with their service?

Did you struggle with the emotional component of feeling like you're late to the game (career over family)?

I'm definitely struggling emotionally and need a morale boost before going ahead with this.

TIA for your responses! 🙏

like

I am in panic! It’s like someone took me and started shaking me.

like

Anyone looking to make the switch to Deloitte?
DM me for a referral.

like

It's lame that I feel validated when an MBB person upvotes my posts...

like

Have you seen JLo’s movie “Hustlers?” Just watched it and loved it. Loved Ramona’s line about, “you just have to figure out what kind of man you’re dealing with.” I’m paraphrasing.

like

So given my title maybe I show know this.. but I need some guidance on a situation. I’m currently interviewing with an interesting company that I’m very positive about and expecting an offer next week. I just realised that they have a more senior role (and closer to my level) posted on their career site that I think would be a better match. How should I address this? We are currently talking about a temporary role too so I think this would be even better.

like

The are you done working yet face

Post Photo
like

Will McKinsey give you a car at any level?

like

Who's already drinking?

like

What’s my exit here? 6.5 yoe in data & analytics consulting focusing on data/big data engineering, cloud. No MBA or masters. I can be technical but don’t think I’d make the cut at a FAANG.

like

Hi! First year here. Do you guys use cpa to file tax? Or is turbotax ok?

like

Applying for round 1 as a senior analyst vs. applying for round 2 (or even 3 for certain schools) as a consultant - which would have higher odds of getting in? ACN promos aren’t effective until Dec

Any teachers here from Colorado that have a 4 day work week? I have some questions.

like

TFW you receive your Admirals Club luggage tags in the mail from AA. #LittleThings #ConsultantLife

like

Anyone feel like they eat more when their SO is around? Mine is out of town this week and I realize that I need a lot less food but his being there just makes me eat more

like

I ended up down a rabbit hole of looking at where alumni from the schools I’m applying to are working (T15/M7) on linkedin and a surprising number work as consultants for the NPS. Are these competitive/ well paying positions?

likefunny

Anyone work at area 23? Do you need prior experience working in medical? Is most of it technical or are they looking for big ideas? Saw an opening for oncology ACD cw for example.

How can I increase the diversity of candidates, particularly for leadership-level roles? I have seen the 3% conference and posted positions with them, are there other helpful resources?

like

What's the difference between operations and operational excellence?

like

How long does it take you to bill 8 hours a day? I’m a first year and feel like I’m not as efficient as I could be or am under billing. It takes me 10-12 hours to bill 8. This includes the hour I take for lunch and dinner, some breaks for bathroom, and non billable time like entering time etc. how are people billing 200 hours a month? What am I doing wrong?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

For account settings, visit Fishbowl on Desktop Browser or

General

Legal