Do any of you use that scenario manager tool, or is it easier to do scenarios yourself with index(match), data tables etc?

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

I feel like the scenario manager tool would be cool if I actually knew how to use it...

Definitely easier in my opinion to just use index(match). It is easier to edit & add / remove scenarios

like

Data tables are clutch for 1 or 2 variable models with a high number of scenarios.

I’ve never used scenario manager though I’ll have to look into that.

Related Posts

Hi everyone,

Can someone working in
Capgemini please help me? I got an email to complete the application form but I am not able to find the Job requisition number ,it's important to complete for releasing the offer letter.
I tried contacting HR via phone or email but they are not responding at all.

Thank youCapgemini

like

Qualcomm hiring for M.tech freshers

Post Photo
like

What in the world has this country become? Prayers for everyone.. hope this gets better soon!

like

Has anyone seen any unique places to find UX portfolios or post jobs other than the usual suspects?
Some UX Slack channels were doing well for a while but I definitely don’t see as much traction there. Meetups obviously came and went. Even the portfolio sites like Dribbble and Behance don’t seem that same.

How can I get a good paying job in healthcare administration??

I will soon have my masters in healthcare administration and I currently work for a hospital system as a patient service coordinator. I feel extremely undervalued on top of underpaid. I know that I am capable of more. Is there a space for young healthcare professionals to excel?

like

If you had to choose between Google and Apple for a freelance designer gig, which would you choose? Based off of what you've heard about the team, work, environment, etc.

like

How many days Servicenow usually takes to release the offer letter?

like

What kind of salary can I get in industry with 1 year of big 4 audit experience?

like

Hi there! Do we have any coaches for coaches in this group? I.e., coaches that mentor others on how to be a coach?
If you are one or you know any great ones, please drop their names below! ⬇️

like

Does anyone know how long you need to work with Salesforce to be eligible for maternity?

likehelpful

Efficient marketing tools to have as a marketing agency?

like

My boss asked me to take care of some of the details of a project for her—the stuff that isn't really my area of expertise. And now I feel like a shirker because I haven't been able to finish them yet.

like

I am considering pulling a home equity line for my primary residence to use for basement finishing and bathroom remodeling. Has anyone lately shopped for home equity loan/line. Any recommended lenders with best rates or experience either with traditional banks of fintech players? Also, open to any other suggestions with regard to financing the projects.

like
like

Please suggest which company to join for professional growth and WLB. 6YOE tech
stack is AI-ML.
Current CTC: 12.7
DELOITTE - 22+ 0-10% Variable
Wipro - asked 24Fix offer will come soon Virtusa - 25fixed+ 0-10% variable + 1L JB

Virtusa Deloitte USI Wipro

like

May I know notice period standard chartered GBS India?

like

R1 or V1?

like

Favorite /least favorite Seattle area clients and why? (Goes without saying but don't mention specifics if it'll expose sensitive info/relationships)

Hi I have got offers from Rakuten symphony and JP morgan. Which is better company for Java Backend developers with 8 years expirience?

like

Additional Posts in Excel Genius

Has anyone gone through Elevate Excel by Excel Campus? Looking for reviews as I'm having trouble finding any that aren't on their website....

like

Can someone provide the most efficient way to send multiple emails in Outlook which contain excel spreadsheets into a single pdf file and not an outlook file?

like

I’m trying to create a form that I can then take the form field data and import it into excel. I have tried the word way with the setting in advanced (I don’t recall the term) and all it does when the formatting box comes up is shows a box.

like

Dumb question, when I hit (ctrl+shift+down) on column B (data in A) to highlight all rows, my sheet keeps going ALLL the way down to >10,000th cell... how do I make sure it only goes down to my data?

like

Really wish my clients didn’t use Google Sheets. This sucks.

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Favorite Excel shortcut / trick. Go!

Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?

like

I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

like

what’s the quickest way to find all offsetting entries in a huge data sheet?

like

So xlookup? How is it going for you? Still haven’t use it.

like

Hi I’m doing a copy and paste from my online bank which contains the data I need but when I paste it embedded small icons for each lines and I need to do another copy values only each time...

Does anyone know how to keep in leading zeros when converting to a number, so I can do a vlookup across data sets?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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

like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
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?

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

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