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

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

Creates a dynamic sentence based on cell values. Helpful for dashboard spreadsheets with frequent updates that are then screenshot for presentations.

Post Photo
like

Related Posts

Is bowl ka naam Vande Bharat consultants 😂 hona chahiye 🤔

funnylike

Orl, Fl males where you @. 32F here

like

Is this the main sm bowl, just seems a bit dead compared to Mgr bowl

like

Deciding between Deloitte vs KPMG FDD. Any recommendations?

like

When you're building that perfect deck.

Post Photo
likefunnyhelpful

What celebrities have you encountered that were either really nice or really horrible?

like

Any thoughts on W&C, PH or Shearman in NY? Chambers seems to suggest that Shearman is a little stronger in the areas it’s good at, but not as broad as the other two. Is that a fair assessment?

like

Anyone have any knowledge about BIP Capital VC firm?

like

Get upto 100% of your TDS as Refund in your desired bank account .
Due date for filing (ITR returns) for the AY 2021-2022 which reflects your transactions during April 2020 -March 2021, is on 31/12/2021.
File now to get rid of penalty for delay returns
Here we will e-file your IT returns
▪️▪️▪️▪️▪️▪️▪️▪️
Are you new to ITR filing???.... no Worries join and get our help to clear your queries

📲 8985907244

like

Do any of you spend time on HNBA or other affinity organizations? If so, do you bill your time as non-billable, i.e. diversity? And how do you balance your time going to an events/getting involved?

like

How do you break into compliance? I don’t have a finance/banking background. Mainly L&E, govt work. I think the skills are transferable but am curious to hear how people with non-finance background have navigated the transition.

like

How can I learn about investing in real estate? Any good books or articles?

like

BCG fish what would you say about the ME practice? I have an offer and am mulling relocating from North America.

like

What does everyone think about Val Demings as a VP candidate?

like

Job base salary presented by HR during screening interview was $130-$145k. I have 3-5 years more experience and more education compared to the posting requirements (BA required, I have a MS). I love the position and what it entails, but was hoping to reach $150-$160 base salary. If offered the position, is this a reasonable ask? This is for big pharma, data analytics in New England.

like

Hi all

My name is Ankush Ghosh. I am currently serving notice period in Infosys. I have a total experience of 2 years and 2 months as system engineer, with main expertise in Java and its framework(Spring, microservice). I would be obliged for some vacancies and obtain certain referrals from this platform.
Thanks in advance.

like

I started a job and the boss is asking for emails and phone numbers of potential customers. Where do you guys get that data? What kind of services do you use?

like

It’s week 5 for me of the breakup and even though I had a full and fun weekend with friends and people I love, I woke up today so so sad because I wanted to text my ex. I just feel overall so defeated and exhausted from sadness and unmotivated at work :(

like

Open to new opportunities as a project manager, however, the options I am finding are all 6 month contract or contract to hire.
Anyone else running into this or is it my area?

like

Interviewing with EY FAAS for a manager role and would appreciate any insight on what will be asked or how to prepare. This will be my first interview since college so feeling a bit nervous and unprepared

like

Additional Posts in Excel Genius

hoping this illustrative post makes sense.
column A=state; B=city. Cells in each column are drop downs, i.e.,can select countries/states. And, current dataset/selected choices is indicative of a category i.e., top locations. I want to build scenarios or addtl categories that ultimately auto changes values in the drop down cells. this is doable w/ lookups, but want to avoid formulas as i need the client to be able to customize the dataset/selections to view scenarios , hence drop downs. 😬😬

like

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

like

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

How can I make these dates sortable with a filter?

Post Photo
like

What are the most typical models you all build

likehelpful

I have a spreadsheet downloaded from a SaaS product. Every where there is drop-down multi-select or drop-down there HTML code I need to remove and simply leave my lists. Any ideas? I thought kutools would work but apparently not?

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

I have a spreadsheet that includes these columns: total AUM of firm X, % of AUM allocated by X to sector Y, % to sector Z, and so on (one column for each sector). Goal is to present in tabular form...

What are your favorite excel macros to make you more efficient at work?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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