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

Received a job offer. Was wondering if anyone had any thoughts on a concern I had about it. It's an entry level position, and I don't have much experience. The billables are 2040 a year. For billable hours in civil litigation and insurance defense, is 2040 hours for a 1st year associate on the high end in this field for a small or midsize firm? It seems like most attorneys I know have minimum requirements of around 1800. The compensation is around 80k a year.

like

Hi all, I have a friend who is a current Senior PM at Amazon, looking to move on. He requires sponsorship. Are there any companies out there hiring PMs or PMTs that sponsor? Please DM if so and I will put you in touch with him.

like

I am looking forward to HR round for Macquarie Gurugram. All rounds went well except for numerical reasoning section in psychometric test. My yoe is exactly 8 years. My current CTC is 16.2 and expecting raise in current company in 2-3 months.

Q1- What is the maximum I can demand in Macquarie in HR round? Initially, before interviews started, I mentioned 27LPA (negotiable). I have a past offer (not current) of 25.5 LPA.

Q2 do they decline offering in case we get adamant abt high salary 27Lpa?

like

I was offered a position at fidelity. Now when I trade on behalf of a client, will I get commissions for that trade?

like

Hello Guys! Anyone looking for Service Desk Lead role from Noida location. There is an opportunity in HCL noida location. Pls ping me if interested. Immediate joining only

like
like

What does tronc (formerly Chicago Tribune Publishing) do, exactly? What’s the role of an ad copywriter there? They are vague on both the job posting and their website—but I’m also getting desperate.

like

Thoughts on TBWA/ World Health in Chicago? Contacted for AD role. Currently work in shopper agency on heathcare brands

like

Any advice for landing an assistant/associate editor role? Anyone know of shops looking to hire full time?

I am close to receiving an offer for an EA position. Would like a signing bonus. When/how do I ask? I don’t want to lose the job opportunity. It’s a great job.

like

Need some help finding a SWE job. I’ve been trying for a long time with no luck and just want to get my foot in the door. Any help is welcome whether its some tips or a referral. You can DM or comment here. Thank you!

like

Can someone refer me in FIs ? Position open for senior business analyst-banking domain in Bangalore.

like

Hi,
I am a Master's student at Northeastern University looking for Data Analyst co-ops and internships.
I would love to get feedback on my resume or any other advice I can get for my internship search. Would love to connect and talk more.
Thank you :)

Post Photo
like

Square Veeva @teletracking

Trying to decide between 3 offers remote/Columbus

Square is 84k salary 5k bonus and 80k stocks vesting over 4 years
Veeva is 100k salary 20k bonus and 25k Stocks each year forever
Teletracking is 125k cash 5k bonus

I know about Square the most and if they paid closer to Veeva and Teletracking I’d probably go there but it seems like they underpay.
The Veeva culture seems really good but it’s a sustaining engineer position for year 1 so debugging

like

Hi Everyone,

I am currently working as a manual test engineer. I want to learn selenium and plan my career in Microsoft.

My question is will Microsoft conduct interview for testing profiles? If it is how can we get to know the openings.

like

I've an interview tomorrow for .net developer with Siemens, yoe : 7. What type of questions can I expect? Siemens

Hi there! I am current a recruiter at google on contract. My contract is 2 years, and I’m coming up at the year and a half mark. Are there ANY tech companies hiring?! We’re in such a lull on the FAANG side of things… thanks’

like

Hi All

I saw there multiple openings for testing profile in Harman.Can anyone refer me.

I am having 6+ yrs of experience in Testing Domain.

Referral or suggestions for any other company will also be helpful.

Thank you

like

When you ask the intern to take meeting notes

Post Photo
likefunny
like

More Posts

Does your company pay for parking (if they don’t have a designated lot)? If no, do you believe they should they pay for it? Thoughts on this?

I don’t want to make partner, and I want to stay in big law for 2-3 years, do you suggest I just do the bare minimum for hours or should I still be doing as much work as possible?

like

What's a Design Director salary range in NYC? The next level will be a Creative Director. It's studio owned part of a more extensive Agency network.

like

Looking for recommendations for high-quality, high-volume print vendors? (120,000+ direct mailers) Any help would be appreciated.

Is verizon service based or product based company?

Any insight here on Marketing lead salaries in tobacco (in Toronto). The actual role is pretty comparable to a brand manager which can range 80-100k depending on the employer. Thanks in advance!

like

Hi all, I was told that my business unit is Finance Risk and Control in JPMC. My profile is Java Fullstack developer. Can anyone help me about this unit ?

like

Hello fisher my name is sahil kadam
I recently completed may master's in data science mashine learning and artificial intelligence i am looking for job related data analyst i have knowledge about power bi , tableau ,python i also work with r language please give me referal in your connection

Do I go for a promotion even though I’m being told it isn’t a home run? Is there a backlash/ detriment to declaring for one and not receiving? Would I be wasting folk’s time? This is my first run at a promotion outside the Army.

like

Own a condo in Sandy Springs GA and recently discovered I have surface mold in my closet… transferring to clothes etc 🤢 anyone worked with a mold removal company and can share estimates? Wondering what typical prices are, I got an estimate for 1100.

like

Who’s working out Monday morning? 😤😤😤

likeuplifting

Hy all

Right now I am in notice period and don't have any offer in hand
But I inform to my manager I have a offer with x amount and he agreed to match it
Right now I am going for a call with HR
If they ask do I have any offer in my hand then what should I answer them
Will HR ask for the offer latter which I have?
Fact - I don't have any offer in hand right now

like
like

Anyone sell to Zillow? Got an amazing offer from them, but naturally my floor decided to start deforming right before inspection. No water damage - I can get someone out here to fix it ASAP, but wondering if it’s worth the hassle. Mostly worries inspector will think there’s water or foundation issues

like

Cringe for today!
Two things,
1. Why can't you say this as a "Text" post.
2. What's your point?

Post Photo
likefunnyhelpful

Has anyone asked for a hike in the same company without any other offer in hand by letting them know that you deserve more (providing proof of work & awards)

P.S. I know everybody thinks they should receive more but just in case you really think you deserve it when compared to market standards, has anyone approached HR directly?

like

Pretty tired of smart women undermining each other, especially seniors doing it to juniors. Why the hell is the first instinct to attack&destroy? Not into kumbayas but more into having my peer's back.

like

GT people, how unlimited is your unlimited vacation? Or is it more like limited vacation compared to a formal PTO policy. I am thinking it has to be harder to take vacation now than it used to

like

Hi Fish,

My LWD in TCS is on next week. Can anyone please help me what are the formalities I have to do and clearance I have to apply for.
If someone has gone through the process recently, a step by step guide would be really appreciated.

like

Additional Posts in Excel Genius

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

like

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

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

I work on a Mac and excel/sheets can’t handle the size of my data. MS access isn’t available on mac. What do I do 😭

like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

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

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

like

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

like

New project, new massive excel file that I keep making mistakes on. Tips on error validation and performing QA?

Help unhiding columns A-D in excel. I've tried putting A1 in the select cell selecting unhide columns and also youtube to no luck. Please help.

like

Looking to get rid of ALT+ENTER in cells, it’s messing up my import file formatting when I convert the file to .txt.

Could some recommend a way to do this quickly, I’ve tried find and replace control j, and that worked on most but not all cells.

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