I feel awful, friends... I forgot to post the tip of the week thread last night, I’m sorry. I’ll try and make up for it with some extra tasty tips and tricks this week. Comment below if you got ‘em!

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

You’re awesome

like

That kinda just made my day

like

You can record find&replace actions as a macro for a specific selection.

This is extremely useful if you have client reports that store numeric values as text using quotation marks, but where the text values are needed elsewhere on the worksheet.

I’m hardly an expect on macros, but learning the basics so you can do simple tricks like this will save you tons of time.

like
Recent IconRecent

Avoid using merge and center. Instead select the cells, go to format cells, go to ‘alignment’ tab and select ‘center across selection’ from the ‘Horizontal’ drop down

like

Okay I tried running the macro and it gives me an error saying “compile error: sub or function not defined”. Any ideas?

Alt H F D S O X —-> highlights all hardcoded numbers (does not highlight text/column headers)

likehelpful

You're awesome

uplifting

Ever wanted to do an index/match or lookup on two identifiers in separate columns? Although this is possible to do with an array function, a quick and easy way to do this is to concatenate the entries in those two columns. Badabing badaboom, now you have a unique identifier using two criteria, but can still use the same index/match that we all know and love. Neat!

like

Ahhhh okay! If k1 is accurate, that’s really handy OP :) and haha yea I can’t see the text in your pictures. I would recommend you take a photo on your normal camera and then upload vs. just taking it in the app and see if that works!

Related Posts

What would be a good price to pay for a habitable apartment in Murray Hill/Kips Bay? Also any recs on finding a roommate you actually like lol

like

Any good books for someone trying to understand the business side of marketing? Just got my review an they're asking I bring more of that MBA mindset to projects I'm on.

like

Concepting vs technical skill: Which is more important? I’m mostly used for creative concepting at my agency, which has been a great opportunity and has gotten me promoted thus far in my career. BUT

helpful

I’m doing some research on error and empathy. Has anyone come across any research on customer behavior, such as helping them cope with difficulties online and correcting errors. I’m reading and hearing no one likes “We sorry” interactions.

Anyone from Barclays finance process? Can you please share your YOE, Role and CCTC. Don't see anyone from finance background here.

like

Team USA, what does your high school yearbook say your dream job was?

like

Is wipro closed till new years? I have my 1st round of interview, was told i cleared, awaiting for 2nd round since last 3 days

like

Hi fishes,

My current CTC is 7.8 LPA and I'm holding an offer of 14 LPA.
Now I will be having the HR round in another company, so how much I should ask?

YOE: 2 years
Technology: Big Data/Data Engineering

like
like

How do you make sure you are keeping the brand voice consistent?

like

Lien search help. I work at a regional firm, and only one paralegal is available. This paralegal started yesterday …. I essentially have to coordinate with the lien search rep to order lien searches. When an entity is incorporated in DE but the PPB is in a different state, what searches need to be conducted and where? Would we need bankruptcy and federal judgments and lawsuits in DE?

like

Started working at a Delivery Center for Deloitte 3 months ago. I won’t be stayin. 1.5% match for retirement is lowest for any all firms. No retirement pension plan.
Switch I now or wait for year?

like
like

Anyone in internal/corporate communications (government is a plus!) that wouldn’t mind looking over a corporate comms and experience strategy for a position I’ve applied for?

like

Do you tell your partner that you have HSV-1? I didn’t know that I have it and recently I got blood test and found out. I started to have outbreaks (sores around lips, usually one) every now and then when I am stressed.

funny

What’s a good tech sales company for someone that has two years of sales under their belt and wants to make 6 figures?

like

PwC India Folks, heard from someone that AC Kolkata will publish hike letters next week. Please vidate this info.

Also, if i resign now/next week and my last working date is after July 31st, i can still get my hike and bonus, correct? This is written in the employee handbook and my offer letter. I would appreciate if someone who has greater insights to reconfirm this.

Pwc AC PwC India PwC

like

Hello fishes..

Need suggestions please.

I have accepted the offer with tcs (12lpa) and my joining date is 2nd of November.

I just got a job offer from ZF for 13.5 lpa with a 1 lakh joining bonus.

There are only 15 days left to sign up for the TCS. Should I urge TCS to change my 13.5 lpa offer?

Skill: Aws

Relevant experience: 4 years and Overall experience 6.5 years

Hi all,

Can anyone explain me the FEP policy in Mindtree and also what all components can I claim under this?

Additional Posts in Excel Genius

I am getting a formula.firewall error in PQ for my merge queries step - I’ve rebuilt both queries (deleted steps in each and recreated them). Is this a security function at my firm or is it something in my model im not understanding?? 😞

like

Anyone have recommendations for a 5 year forecast model and/or template for a private company? (For a small fintech company)

like

Hi everyone. I know this is probably an easy fix, but can’t find it. Previously when I would close excel, it will check for any changes I made and then ask if I want to save. Now it is instead just closing without the Prompt asking to save changes. Is there something that got unchecked?

likeupliftinghelpful

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

like

Y'all have or seen any good/short tab names for time based assumptions? (ie. the scenario manager tab with price decks)
"Time Based Assumptions" is long and can't think of a good way to shorten or reword.

like

What are the most typical models you all build

likehelpful

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

I have a table in sheet1. Column examples are ID, Initiative, Owner, etc. I’d like to use that table as a growing list of inputs. I’d like for sheet2 to be used by another team for other types of data inputs. But I need sheet2 to automatically populate the IDs from sheet1 as they change. Thoughts?

like

Does anyone have an excel test they can share (or point me to something online) that you use during the interviewing process to evaluate candidates? Not looking for an excel expert but definitely need someone who knows more than the sum function

like

I wonder if there is a quick guide for excel ??

like

Hello Everyone!
What is your opinion about Coursera, LinkedIn Learning, and Udemy courses? I enjoy learning about several subjects, but I want to invest on something that will add much value and that is with my money! Any suggestions? Thank you!

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Is there a way to connect SharePoint and Power BI so that there’s a live data connect for real time updates?

like

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

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!

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

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

like

Convinced my non-accountant-but-still-works-@-B4 wife that Excel doesn't use the letter O at all because it's too similar to 0. And that most accounting systems don't use O either.

Score one for Excel nerds!

likefunny

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