Related Posts
I was laid off during Deloitte‘s mass layoff in July of last year. I have worked as an independent contractor since and projects haven’t been consistent at the client I’m working for. I’m looking to get back into a big firm and was seeing if anyone would be able to refer me or help get my foot in the door. I was a business analyst for 1.5 years at Deloitte and have several years of additional experience which I’d be more than happy to share.
More Posts
Is 25 mbps slow for internet?
I have no problem lying to get what I want
Riley loves ball. Arya loves Riley 😆
Can someone refer me to another company?
Additional Posts in Consulting
New to Fishbowl?
unlock all discussions on Fishbowl.
We outsourced some data analysis and facilitation to a vendor once. I was working with them and said, “So just throw a VLOOKUP on that so you can pull the other data in...”
Blank expression
“Are you familiar with the VLOOKUP function? I’d be happy to walk you through it...”
And that’s the story of how I taught someone doing data analysis for me how to use VLOOKUP.
And people ask me why I don’t delegate more....
I had one created a model with a goal seek and a macro to run the goal seek for the client. Had to explain what goal seek is and what it does. Years later, client calls on my personal mobile to ask for a meeting. Turns out they needed help with goal seek 😂
I once showed a client how to manipulate the date, then drop formula down. His response: “I feel a lot better about spending millions of dollars on you guys now"
Vlookup is for beginners - index match is the real thing 😉
Would’ve thought it was sarcasm, but they then asked me to walk them through the process.
It’s the little things 😄
Like telling a monkey he is good at juggling... Half impressed half pity
Show how you make a pivot table 😱😱😱
When you do “Alt + N + V” to create a pivot table and they be like 😳😳😳😳
Getting others to think that you're good at Excel is 90% of being good at excel
@M1. I learnt it the hard way but never use pivot tables when building a model. It doesn’t let your model be dynamic and leads to a lot of mistakes in copy pasting, data scrubbing etc. I let all raw data sheets remain as separate tabs, build a Database using SumIFs and then do all analysis and modeling off of that (also using formulas, no pivots). Takes a lot of upfront investment, but pays off immensely eventually in saved time.
Of course Pivot tables are good for quick analysis and a bunch of other things.
Excel is for rookies
M2 tell us more! How to apply slide design to photo design?
Taught a client how to design slides....used the approach yo take photos on his honeymoon and his wife was super impressed with their photos.
May have been my proudest moment.
I hate index match, but then I also hate that vlookup requires your reference value to be on the left hand side so...
Honestly, sumifs are really light on processing and file size. These aren’t vlookups or index matches
Pivot tables are for impressing clients on the fly.
Of course you can't use a pivot table to underpin your whole model, but good luck with sheets full of sumifs -- you'll crash excel with a reasonable number of them.
My client once asked my what the median formula did in excel. Then she asked me what a median was
I don’t have a mouse and I never use one...
Sumifs countifs for the win! I loved using those over pivot tables too, but long ago as an associate was told pivot tables are more advanced and I should use those for more impressive models. Looks like someone steered me wrong.
Alt + h + b + a
Alt + h + b + t