Early in my career, I was nervous every time I opened a big Excel file. Now, it’s one of the tools that makes me feel most in control at work.

Wednesday Wordle 326 3/6

⬜🟩🟩⬜⬜
🟨🟩🟩🟨⬜
🟩🟩🟩🟩🟩

Does Deloitte fire you if you do not get h4 ead on time or allow you to take leave without pay?

Any product counsel for AI-related companies here?

Starting a new in-house role tomorrow after almost a decade in litigation at small/mid-sized firms. I’m feeling pretty scared! Any words of wisdom?

Looking to pivot into healthcare consulting. I come from a MHA background with a two year Administrative Fellowship following it. Any experience breaking into one of the top consulting firms with this type of background?

I have salary discussion with infy tomorrow. How much should I ask? CCTC-8.1 , YOE-3.9
I left infy an year ago only🙈

About to put down 500 on drinks tonight. In that spirit, what's the most inappropriate thing you've ever expensed successfully?

What is a considerate way to say “no thank you” to a recruiter? I was contacted on LinkedIn and want to be respectful of the recruiter’s time but also want to thank them for thinking of me.

I just had my first behavioural interview with VCA for a Digital Consulting Manager role and the Dir said he was going to progress me to the next round.

I have never worked in consulting before, my background is all project management/marketing/advertising and I have an MBA. Wondering if anyone can give me an idea of the type of case questions they've been asked during their interviews for VCA.

Thanks in advance!

Anyone willing to offer referral for lateral hire consulting opportunities at MBB. Is it possible to share the profile internally with someone at Partner level for consideration.
12+ yrs experience in strategy, transformation, change, process improvement, cost optimization & analytics. Helped F500 clients on Future of Work & workforce transformation cases in pandemic.

Hi y’all! I’m a financial educator and my job is to help families in need of financial education! I help anyone on learning how money works here in the US & how to get rid of debt! I offer financial products that help you protect and grow your money. I’d love to help you out in reaching your personal financial needs!
I’m also always looking for people to hire!

Diamond medallion on Delta. They lost my bags on the outbound (3 with my wife who is Plat) and inbound flights (1) on a trip to Europe. How many points should I expect? Any advice to deal with this?

Self-Promotion Alert: In association with my upcoming personal finance blog, I have a draft of a blog post about paying off my car that I would love to get some feedback on

DM me if you’re interested

I got a promotion a year and 3 months ago, and got a pay raise 5 months ago. Could I still ask for a promotion to SAE if I have been supporting a team more as one? Promotions are hard to stab with.

Managers at Accenture Strategy (South), what was your pay increase going from consultant to manager? Any promotion bonuses?

Anyone know when we get our bonus as a new joiner?

Angel investors : What returns do you expect when investing? Also what’s your range of investment?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

Would anyone be willing to teach me vlookup?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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

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.

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.

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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)?