Additional Posts in Excel Genius
I get nervous when I speak in front of a crowd even if it’s just an introduction. There’s no consistent pattern. Sometimes, it happens. Other times, it doesn’t. Any advice on how to mange this?
How many years we need to spend to eligible for gratuity in infosys?
My DOJ in infy is may 2017.
Why do we always have a reactionary posture?
When Kolin Kapernick knelt, it was a good opportunity for the president to encourage peaceful protests and acknowledge the injustices and also call reforms
Is it too late to jump ship? Just got an official offer today. Don’t want to burn bridges.
Any advice for a Level 9 - Business and Integration Arch specialist? Joining early April so any advice is welcome.
For someone considering lateraling, assuming you have an offer already in hand, what is a tactful way of asking about WLB? I have pretty decent WLB where I’m at, for biglaw at least, but am considering lateraling to another area that I just find more interesting.
Interview with Deloitte Consulting GPS as an experienced hire. 3 years exp at Accenture. What should I expect in NYC?
Currently looking for Tech consulting/ Implementation consultant/ privacy roles in London. I have both CIPP/E and CIPM.
Please let me know if you know any roles that are available? Or any recruitment agencies you can refer me to
Is kickball hard to learn
ICP has taken a bad hit. Will it rise again?
Here’s a first - I have an opposing counsel who decided to file a motion in the court to bring criminal charges against me for “perjury” - all because we served him as he was on the record as being his client’s attorney.
What in the actual fuck??
MBB 🐠: what is the business development and internal firm initiatives expectation for associates/consultants or PLs? Is there a percentage you can provide?
Anyone down for a drink or something?
A female planner at the agency said she needed to work on a brief with me. because we’re working from home she asked if I wanted to meet for lunch to go over it. I said sure. She proceeded to order wine. After linch she touched my hand and asked me to her place. I declined. My question for you all is, if I did that to her, and she went to￼￼￼ hr, I’d be canned. Do I have similar recourse?
In my last company I suffered from poor management who yelled at / demeaned employees daily and overrided decisions with no scientific basis, leading to some dangerous/unethical handling of important issues (dealing with real patients). I have a background in bioengineering/math and am looking for research associate positions or clinical specialist/consultant roles in Long Island, NYC or remote positions ASAP. Any advice (or possible referrals)?
Does anyone know some companies that are hiring opt and give visa sponsorship in Seattle or greater Seattle area? I graduated with a degree is computer science and want to go into management roles but I can’t seem to find any. If anyone know anything please help!
Soooo zoom call small talk starter for tmrw is no longer about the weather and now about potus contracting Covid amirite?
Additional Posts (overall)
Any ideas on how to sumif based on criteria listed under a given header wherein the header is the main reference but there are varying criteria beneath said header? Specifically, I would like to drag a formula down a column that references a corresponding department in the row (the header on a sep sheet) and then sums the listed accounts beneath each dept (with each dept having a diff # of accounts) from a given data set. Could do a pivot, but the filtering process is inefficient.
Is it possible to see who has opened an excel workbook? I know you can see edit history, so I’m looking to see if there is something similar for file open. Thx 🐠
Trying to figure out how to understand the variability of price data along a downward trend. Any ideas? If the data wasn’t trending, I’d just evaluate the distribution of data, maybe normalize it.
Hi Excel Gurus, is there was a non-macro approach to input fields?
I have Worksheet A with merged cells used for user input. I attempted to reference values from Worksheet A cells and populate Worksheet B via direct reference. Also using a parameter (name) from Worksheet A to differentiate rows in B.
I keep getting a Spill error as I am taking a merged cell (3+ rows) value from Worksheet A and trying to put it into a single cell in Worksheet B.
Is this a valid approach for input collection?
Trying to use power query but it can’t find a connection in excel, saying the external component has thrown an exception. Any ideas?
Also posted in data analytics bowl, but quick question. I am looking to use Tables 1 and Tables 2 in this screenshot to yield the “ideal outcome” table in Power BI (using query editor). The tables I have setup look similar to Table 1 and Table 2 (it’s a mapping activity of controls to various categories). Is anyone familiar with the proper steps / video that will help me arrive at the ideal outcome?
What task would you expect excel of being able to do but you have never been able to make excel do it.
Hello Excel Geniuses- I need help. I have never learned macros but I’m about to but before I invest the few hours or however long it might take, I wanted to find out if it is possible to do what...
I recently switched my jobs and I am doing a lot of analysis in excel using big data given to me. Are there any courses or any videos I can watch to enhance my analytical skills using excel?
I have a master data list on sheet 1. Need to split the data by location (4 locations) on other sheets but only want to update sheet 1 as I get more data. How can I make it so?
How can I index match a relative value?
I want to look up the per unit cost of 280M units, but don’t have an exact match. The numbers in the picture below are actual units/infra I’m searching against
My formula is currently =index(D26:D48,match(B56,B26:B48,1)
For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?
Happy Friday Eve
I’m trying to work smart & not hard- started recently and what’s some of excel features you recommend I need to get in habit of (short cuts etc...) help.
How can I goal seek tariff (price per unit) to meet a certain Equity IRR based on a target Hurdle Rate using VBA? Can anybody please share a code or explain it to me like I'm a 12 year old. 🙏🙏
What’s the next step in better pay as an HR Coordinator? I’m currently picking up a data analytics certificate for fresher skillsets. I’m aiming for $80-$90k salary at the moment.
I have about 10 variables each with a certain score (10,14,15, 20,20,20,7,9,2,1). I need the max value is there is a single winner (MAX function work here.) If there is a tie for the highest score, I need an output that says “Multiple.” How would I go about this?
Thanks in advance!
Silly question - what’s the difference between the 0 and FALSE in the following VLOOKUP(value,table,column reference,0) and VLOOKUP(value,table,column reference,FALSE)
Looking to do data analytics for nonprofit organizations. Any forms or websites to look?
New to Fishbowl?
unlock all discussions on Fishbowl.