Excel gurus I need help ASAP! Is there a way to convert a process flow into a checklist in excel? The main confusion I’m having is how to take the diamonds of the process flow and based on the response convert that into a checklist.

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

So do you want excel to auto fill the Visio page? That would be a hell of a macro!

If you’re looking for literally like step by step instructions based on previous answers to questions, then you would want to create a bunch of lists that are referenced from another page

like

Following, it will be a great achievement whoever figures this out

like

Can you paste a pic to help me understand? Hard to picture I just want more details

What's the source of the data? Visio?

I want to put these diamonds into options that can be filled based on the previous response

Post Photo

Hi, not sure if you're still looking for solutions here, but out of curiosity I searched for some resources. I shared two links I found below. Hope this helps and enjoy your weekend!

Summary:
https://support.microsoft.com/en-us/office/create-a-data-visualizer-diagram-17211b46-d144-4ca2-9ea7-b0f48f0ae0a6

Tutorial:
https://m.youtube.com/watch?v=QLDQM6VKVaE

Related Posts

I saw that Orrick had an Attorney's of Color retreat in New York. Does anyone work there who can speak on how it was? If not, is there a retreat/coalition/group for Attorney's of Color at your firm?

like

I see folks talking about Roths/backdoor Roths, and I wanted to verify my thinking. Currently I’m making far more than I anticipate I’ll make in retirement; if I’m wrong, well shit, I’ll be rich. Cont

like

Who pays better for corporate strategy / strategic operations type work: Google or Microsoft?

Bonus Question: What is the highest paying company for this? 🤔🤔🤔

likefunny

I heard BAH doesn't pay out bonuses until Senior Associate, how are bonuses calculated and how big can they be?

like

Anyone start a new job during COVID? Really hoping I finally hear back from a gig.. but hoping the pandemic isn’t another reason added to rejection lost

likehelpful

What is biz ops

like

google recruiter said they would get back to me today once they finished their remaining interviews yesterday. chances i hear back today please wish me luck 😃🙃

like

Hi Bowls,

I am Azure DevOps/SRE Engineer.

I applied most of the companies over LinkedIn for Canada. But didn't get a fruitful response.

Experience:- +8 Years

How to get sponsorship.

Any suggestions!

like

Does anyone know of an area of law, or position where you're called to the scene of an emergency? Or, a situation where you need to be at an event?

I'm getting restless, sitting in an office, or working from home. I want to be in the middle of chaos (this is the reason I like litigation).

like

Has anyone made a good amount as a Pinterest influencer or print on demand/affiliate marketing on the platform? Looking for a good place to start.

like
like

Which company one can join after JPMC?
Profile: Project Management

like

I have an interview tomorrow for role of SM…. With Lockheed;Any suggestions on what to expect please

Hi, I am having 4.5 yrs YOE, Full stack developer
As per the job market, what CTC can I expect ?

Can someone tell me what a producer’s day to day role is in a social agency? This is not snark, I’m thinking of making a move and want to understand the job/ask better. TIA. 

like

I’m looking for a referral for a senior marketing role in a new industry (currently in education). Anyone have one they are willing to connect me with?! (If not, please like this post so I can open my DM’s, thanks!!)

like

Which one to join Optum : Data Scientist (20 lpa fixed) + 15% variable Amazon: Business Research Analyst 17(base) + 2.5(add on bonus) + 10 lakhs (stocks vested for 4 years) [first year 5%] Amazon Optum

Hi everyone

Does S&P Global revise an offer based on a counter offer?

Thanks

I read something interesting that these wildfires would be a bigger deal if they were happening in NYC or DC. Do you agree? Kind of shows how centered everything is around these two towns.

like

Additional Posts in Excel Genius

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

like

Is there any formula where I can change the last comma to be "and"?

Post Photo
like

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

like

I truly appreciate this group.

Post Photo
likefunny

What am I doing wrong in my sum product formula? I keep getting an error message.

Post Photo
like

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

like

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

like

Best way to learn Spotfire? Just watch YouTube videos?

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

why is index match superior to vlookup?

likefunny

Hey guys, did you ever encounter the following problem & know a solution:
Whenever I reference another tab in any given formula in my model, XLS first calculates everything as it should be. However directly afterwards (or sometimes only after saving) the formula vanishes and only the resulting value is left. Hence, all automation etc in the xls does not work.

Any ideas what's happening and how I can solve it without rebuilding the whole model?

like

Time to convert to xlookup

Post Photo
likefunny

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

like

Hello,
How do I randomly pick one name from a list in excel that has identical names?
Example:
Warehouses names
Ana
Ana
Hou
Hou
Aus
Aus

Every name repeats itself several times. But each of them has different lot numbers associated with them. I only need to pick one lot number number from each warehouse randomly. Is there a formula for that in excel?

like

Excel noob here. Can anyone help me write a formula where if a range (column) contains a particular value, then return a value in a different column of that same row into a cell?

like

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Can anyone recommend a specific video on pivot tables?

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