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

Oh wow....this is a really cool article OP that I definitely had to bookmark. Every day I feel like I learn some new tip or trick in Excel and I really had no idea that one program could do so many things. My boss and I take turns teaching each other the new things we have learned.

Related Posts

Anyone taking advantage of the flight deals from corona virus for summer?

like

2YOE life sciences consulting after mba as consultant with managerial duties and am given senior associate consultant role with lower comp. Would you pursue final interview with them or move on?

like
like

Do any of the big L&E firms have a WFH policy?

like

Can you advise a young producer on working with exec creatives? How do you assert yourself & hold teams accountable to deadlines without making creatives feel as though you are challenging authority?

like

Would you get more money in private if you stayed until senior

So, some of my co-workers simply said that they want to go ahead and start something or start looking elsewhere (career change) because they don't know how much it will last at the pace we are going in regards to case intake and pay out. Should I start panicking or simply start looking elsewhere? They even they even told me if I was looking elsewhere or planned on doing so also. I found it weird in a way.

like

What impact has the prestige of your school had on your career?

like

I’m trying to get a rotation in FDD but my partner is worried about temporarily losing resources in our advisory practice. So, what are some things I could learn in FDD that I could bring back to the advisory practice that might convince the partner to let me go on rotation?

like
like

Thinking about switching to IFS. Currently in consulting. What’s your WLB?

like

Is Ukrainian Village a safe area to live? I’m looking at a place near Western Avenue and have received mixed reviews.

like

Is tiaa following work from home right now? Or people are joining to offices

Hi everyone!! It’s Jess at Landed here. Excited to answer your questions over the next few days with my teammate Alex. Will be popping in and out until Friday - look forward to chatting!

Post Photo
like

Anyone willing to refer for KPMG Atlanta office, financial solutions practice? I'm relocating to the Atlanta area. TIA

like

Difference between Vodafone India services and Vodafone Intelligent Solutions? Are these two different companies?

like

Joining Deloitte. I just submitted my documents to immigration. How long will it take to file my H1B case with USCIS? It’s wired big company like Deloitte is using third party law firm for H1B transfers.

Are customer engineers allowed to work from a country other than US if needed for a few days ? I am planning to visit India for visa stamping and I won’t have much PTOs to take.

What does online assessment for professional means,?

like

What's everyone doing for the 4th?🇺🇸 🇺🇸 🇺🇸

like

Additional Posts in Excel Genius

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Would anyone be willing to teach me vlookup?

like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

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

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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!

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

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