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

OOOH thank you for sharing this OP. I am always asking my director to teach me tips and tricks for Excel because she seems to be a whiz at that sort of thing. I am gonna have to learn these and teach them to her!!

Related Posts

Is the fixed salary of 17 appropriate at Senior 3 level in CcaSS practice?

like

What is your firm doing to develop and retain Latino and African American leaders/partners? Or is it not seen as a priority to have ethnic diversity at this level?

like

What’s the best place to work in pharma these days?

like

PPMDs, if an employee comes to you and ask for support to join a different group within the firm and the employees ends up not getting the other role, do you typically treat them differently after (e.g., not staffing them on as many deals) / would you hold them back from promotion the following year?

like

Dating someone im crazy about. Only downside we have different priorities. She is party/friends focused while I would rather family time, time w her, or doing hobbies. Any tips? Should I give it time?

like

Has anyone ever left someone because they don’t want to live a healthy lifestyle? My SO is so unhealthy but doesn’t want to do anything or believes they can’t

like

I’m hoping to steer clear of any scams by posting & I know it’s been posted before but, again, scams. Anyway, I am looking for something that can be done remotely on nights and weekends after I get home from my daily in-office job. My sister passed away & I’m now helping raise her kids. With Christmas coming, I’m nervous and dreading the season not only to not have her but will I make it a happy one for the kids. I need extra income but need to be home with them in the evenings.

like

Amadeus software labs ot I-Exceed?

like

I need 11 likes?

like

I’m leaving my job soon but I’m wondering if I should be truthful when I hand in my letter of resignation. There’s a ton of reasons but it boils down to: I’m worth more than they can pay me and I need to pay off these student loans. What should I say?

like

HR opinion: Do I have any leverage as a hospital nurse case manager in negotiating earned time? I have 15 years within the organization, left for 10 months to be remote during the pandemic while sorting out childcare as immunocompromised family helped. Now HR is restarting my ET as a new employee. I realize I left, but not on bad terms and I am an exemplar and respected employee. I thought I’d have the upper hand with the nursing shortage but I’m getting the “rules are rules” response. Help!?!

like

Anyone have any suggestions for a horse professional expert? Preferably located in the northeast.

like

Incoming MBA here - am attending the Toigo Catapult virtual conference over the next few days and want to understand what to expect in the video interview component for finalists from anyone who is a current Toigo fellow

What's the variable component in s&p global , HR is saying only fixed component will be mentioned in offer. Pls guide...

Something to brighten your day 🤗
I was listening to a Mufti Menk lecture yesterday on this topic. Surah Nashra is also about burdens we bear. Within this Surah,Allah SWT speaks about how He is the one that granted the cure, purity, and strength after the backs were about to break. Allah SWT takes us to this point to refine us. We never know our capabilities until we are tested and challenged. This is when we realize we can do it and we can get through it 🫶🏻! IA you got this 🫶🏻!

Post Photo
likeuplifting

Thinking about switching in house jobs from one bank to another. Current job is great for work life balance but no promotion prospects and pay is below market. New job offers a better title and better pay but work life balance is a bit of an unknown. What kind of questions would you pose to the new employer/team when trying to ascertain what work life balance awaits? Any tips of setting boundaries early on without inviting judgment? Need flexibility to pick up my kids from childcare every day…

like

What’s the base for G7 at intel if compa ratio is 95%?
What should be expected base for Mtech + 6 yoe , hardware engineer role .

like

How is the WFH policy at TIAA.
1) Have they started calling back people to office?
2) Once the office resumes do we have the flexibility to WFH if we like?

I have an offer from Intelliswift software, Pune. Ctc offered is 13.2(fixed) and my current ctc is 9(fixed). Tech stack: angular, typescript, js, html, css.

Total experience: 6 years

I wanted to know how is the work life balance at Intelliswift.

like

It gets above 65 degrees and the city smells like garbage again. Forgot about that

funnylike

Additional Posts in Excel Genius

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

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 ninja tricks? Ones that few people know...

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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

Post Photo
likehelpful

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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!

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

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

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

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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 anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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