Opinions wanted: I inherited an excel file around 2k rows and 50 columns used to manage stakeholder communications. Mostly free text fields and it feels very chaotic. It will be easy to miss an update/ hard to get a summary of changes without reading most of the columns. Would it be worth converting to an Access Db just for my use? Willing to put in the time to figure it out, but not sure if it will be more/less difficult to manage over time

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

Use track changes under review tab and highlight cells with the changes.

like

Could you move to google sheets where it's easier to see changes, or does your org not use gsheets?

No access unfortunately!

Related Posts

For all Jan joinees, mid year hike is now visible on workday…Cheers

like

Hi, I’m looking to intern/volunteer/freelance WFH; My background is in Communication and Digital Media: I also can assist you with admin tasks. FYI I speak Spanish, in case you need to translate docs.

like

Hi Fishes,

Got Lead Category as Differentiating.
Conclusion on QRMTE - Met Expectations

How much bonus and hike can I expect?
Also, please like so that I can activate DM feature😊. Thanks in Advance!!

like

Skills :- Java, Springboot, Microservices etc.(Java Backend Developer)
YOE :- 4
I have a offer from
Amdocs. As per discussion with HR, I will be allocated to one of the projects from "Digital Delivery" Unit.
Please tell me how is "Digital Delivery" unit, the projects inside it and tech stack. Also about onsite opportunities.

Thanks in Advance:)
Amdocs

like

What are the thoughts around all of the “Karen” videos surfacing ?

like

Anybody working in consulting and OE?

likehelpful
like
like
like

Hey, marketers! I'm just curious: have you ever had a client ask you to do something totally out of left field? Something that made absolutely no sense and didn't make any money for the company?

like

I am having 6.5 years of experience in QA automation. Trying to switch to SDEt role. How much should I ask?

like

Does deloitte have a deal analytics practice?

like

Hey everyone
Wat does this "LWF contr" stands for in
American Express payslip is there any advantage of it as the same is deducted for me but haven't opted for it.

like

My current Fixed component as consultant in Tech Consulting at EY India is 11 LPA
How much should I quote for senior analyst position at HSBC Bengaluru given that ey india appraisals are to be announced and also there might be a market correction in a couple of months

like

Anyone from BSV-IF department at bosch. Is it good?

like

What’s the average base pay jump % do people usually get in the new role when leaving big 4 audit?

like

What are the pay cuts from moving from a big law firm to an in house position at an investment back?

like

Devops openings please. 1.5 yrs of experience

like

What is the cooling period in tcs after resignation is taken back ?

Additional Posts in Excel Genius

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

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

I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

Post Photo

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

likeuplifting

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?

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

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

Does anyone have any recommendations for a really good excel training course? I’m based in LA and would prefer an in person course but if there is a highly recommended online program, I’m open to that too. I’m looking for more detailed pivot table instruction and more advanced classes in formulas and macros macros

like

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

like

Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

likehelpful

Dear auditors, please explain how you pick samples for substantative testing.

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

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

like

How would you create this formula based on picture. In cell C6 I want to return a value ; if (B6 is in column G, and C4 is in column H, then return (formula). Thank you

Post Photo
like

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

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

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

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