Hi everyone! I will be going through my first whiteboard/case-style interview for the first time (I was converted from an intern to full time at my current company). This marketing associate position would require some level of excel knowledge specifically on Pivot Tables & VLookUps for email campaign analysis. What’s your experience with interviews like these, and any tips for a first-timer? Thank you in advance!

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

Are you good at both of those?

Know the limitations of VLookUp and know the inputs that go in and the outputs that come out. Talk about XLoopUp too if concept questions come up but know that XLookup isn't backwards compatible with versions of excel that are too old

Be solid with pivot tables, how to make one, how to sort, filter, refresh, change data sources, change values to show a % of a total or etc, and know how to make outputs off of pivots

like

Related Posts

What would be a good exit out of the Rpa space for someone who doesn’t want to code anymore but still stay in tech? I don’t see many jobs in the Rpa space anymore so I’m not sure what kind of jobs to apply for.

like

Hello Fishes,

I hope you will help me out.

I had an technical interview for birlasoft.
I am having 4.5 yrs of experience into Dot net.
I received a mail today that i am selected and i have to do some video interview through Silva it was of 15 minutes.
The question were posted online and my video response was captured there l.

I just want to know is it common to have video interview like this

Thanks

like

I have an interview coming up for BCG but due to some personal reasons might need to push it a few weeks. What’s the likelihood the firm will be OK with pushing / is it even worth asking?

like

Lots of talk about inflation, layoffs, hiring freezes, pay cuts, and stressful job shifts lately. Does anyone have any advice or encouragement to share for those who have been impacted or fear that they will be soon?

Hi Fishes,

Any openings for senior associate role in Internal Audit, I am a qualified CA with almost 3 years of experience around 2 years in EY India and 1 year in Deloitte USI. Please let me know and also would be great if you can share expected CTC at that level. I am getting 13+ fixed right now.

like

I'm a woman working in a male-dominated organization. I'm also the newest member of the team. My coworkers have been given approval to travel to see customers, even internationally, but my boss won't let me. I've been held back in more ways than just travel & have even had accounts taken away from me & given to my male coworkers.

I discussed this unequal treatment with my boss 10 days ago, then abruptly yesterday I took a call from HR telling me that I was being let go.

Any leads for hiring?

Hello, I am hiring a General Manager - preferable with a local passport and education - for anm digital advertising agency to start up subsidiary in SG to cater for the local SEA market.
What should I expect this person would require to receive in salary and benefits?

like

Is all the development work in Thoughtworks done in pairs.Is code pairing just for interviews or its followed in all the projects too?

like

Looking to transition out of Healthcare sales into SaaS and would like to get a position with Salesforce, Gartner or even move into the public sector. Just looking for some guidance and advice on anyone who has done this successfully and if you have any contacts that be helpful to learn from.

I have an interview with Deloitte coming up in the next couple of weeks... any insight, suggestions, case interview tips, or general comments to share?

Thanks!

like

Hey folks, looking for some insight. How much should I ask my hourly wage to be for a contract job with Amazon Business that will run from mid August to end of December 2022?

I was looking for a full-time position that paid $70,000 with job security. The contract makes me a little nervous. Should I ask for more? If so, then how much more is reasonable?

Hi guys! I wanted to know the is salary range for a Business Development Manager (Account Manager , Inside Sales) at Dell. I also wanted to know what to expect for the interview. I have mine tomorrow. Any information is beneficial. Thank you! Dell

like

Does anyone have any insight on the Selendy & Gay case study portion of the callback? Not substantive legal analysis, but what was the actual structure like?

like

Can anyone tell me what the salary range is for Monitor Deloitte senior consultants in the UAE? Also I have a SC offer from PwC healthcare (not strategy &) and currently also interviewing with Monitor so according to you all which of the two is better across WLB, growth, culture, quality? Thanks!

like

I recently learned from 3 different employees that left (voluntarily) they were making 98-105k. They were outside candidates and were all hired within the last year and for the same position, and same regional territory. I have worked for the company 3+ years and went from a core position, to large loss. I was given a 10k raise putting me around 78k. Yes.... some of these individuals have Lardge Losss experience but does that really make a 20-25k difference? Any advise!?

likehelpful

Just submitted documents for a contract position - why does the background check take 4 weeks? Geeze!

like

What’s up with this trend of hiring managers rejecting developers who don’t have FAANG experience on their resume? People in consulting companies also work for clients who handle high traffic and complex architectures. Also, not everyone wants to work at FAANG companies due to moral issues that these big tech companies ignore and blatantly misuse personal data and privacy.

like

Hi,

I received my Relieving letter today. That means all my Exit checklists are closed?
When I will receive my final settlement?

like

More Posts

Are you guys enjoying this mandatory work from home? Or you are so bored and ready to go back to office?

like

Any advise on how to get a position as an HRBP without HRPB experience? All positions I've looked at want at a least 2-3 year of experience. Would over 5 years of HR experience and a PHR suffice, or what skills should be added to that?

like

Anyone on here child free because of how bad your parents were at parenting?

like

2nd Cousin has a Mexican boyfriend of 4 months and is 3 months pregnant - did not have conversations with her mother or her sister, close cousins before going forward. She’s feeling the lash back of a mother who’s looking to influence her decision and get an abortion before she starts this life. There are definitely some red flags with the guy with his income and that he doesn’t speak English, curious what others would do - what would your parents say? Mine would flip!

like

Optum or global logic?
Which one i should join?
Yoe-2. 5 yrs

like

Hi Everyone! I’m Alyssa, one of the Community Leaders at Fishbowl this summer. I’ve been in Special Education for almost 10 years and coaching for 7 (mostly pre-k and elementary). Excited to be here!

like

Any advice on material needed for the LCSW? I’ve been sitting on my LMSW for 8 years and am ready to switch to PP. I have been within agencies since graduating, but never “needed” to take it. I’ve taken it and failed once already. Any guidance would be appreciated!

like

I am so making this my new WFH set up!

Post Photo
likeupliftingsmartfunny

Hi friends! I’m not sure what I should be making as a med device sr quality engineer in SoCal. With performance reviews coming around soon, any one mind sharing a reference range?

like

Here to restate the understated truth of our profession..

Post Photo
likesmartuplifting

Does Hitachi Ventara has software development center office in NCR / Delhi region

Looking for a P&C company that is a true meritocracy. Any suggestions?

like

Recommendations for laser hair removal in Chicago without breaking the bank?

like

I have 2 offers in hand - Global Logic - 23 LPA fixed , Tech Mahindra - 26.5 (including variable).
Which one is good for job security , work life balance and hike and all.
Need your suggestions pls

I am reaching out on behalf of CTMconnects to let you know that we are impressed with your work experience and think that you would be a great fit for a few copywriter positions that we are looking to

funnylike

Where can I find the IV on internet cat NFTs? Trying to update my option model spreadsheet but missing this data...

like

Favorite production companies that can do OOH activations, pop ups, and other less conventional productions? Could be US or overseas.

like

Please DM if interested
Company Optum

Post Photo
like

Anyone know a good tax accountant in the DMV area?

likeuplifting

I've 10+ yrs of experience in Web Analytics, Site Personalization, SEO and CMS. I'm very much interested to move into Data Science domain. For a beginner in DS what are important skill set i should get to transit into DS? Thanks!

like

Additional Posts in Excel Genius

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

Hey, tips for where to look for good excel cheat sheets online? :)

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

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

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

What are the most typical models you all build

likehelpful

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

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

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Best excel plug in? Currently using Capital IQ and WST

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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