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
Posting as :
works at
You are currently posting as works at

Excel is not intended to manage large data sets (hundreds of thousands) or rows. Your best bet is to use SQL.

I always recommend Access - it's made for heavier lifting than Excel, and it's usually included with the Windows license that includes Excel. You can filter, group, count, sum, etc.

Used to run queries on tables with millions of records without a problem. If that gets too big, there are other solutions out there, like SPSS for example.

Use power bi

Related Posts

When will work resume from office?

like

They don’t want me to work today

Post Photo
likefunny

I see Jason Peterson found a new gig.... #KeepingUpWithTheKardashians

Post Photo
likefunny

This scene was all to real. I have lived it , & seems like currently can’t escape it. Can anyone else relate to having to work twice as hard just to get a fraction of others ?

Post Photo
like

Hi all,

I work in the Centre of excellence for a consulting company. Our CTO wants to prototype an indexing/search app to share docs and he wants to use AWS for the cloud service. I’m looking for some guidance around the basic cloud architecture principles. Can anyone explain high level how the architecture should look like? Thanks in advance

like

Offer from Deloitte Cloud Strategy as SC?
$150 + 10k sign
YOE: 3.5

1. Comp seem worth it?
2. How’s WLB?
3. How’s remote working?

like

Morgan Stanley I'm considering an opportunity in compliance at MS. Wondering if anyone has pointers on comp/bonus/benefits to expect at VP level in New York. Are compliance eligible for stock comp?

like

Anyone goes to Equinox to mingle 😉😜?

like

Recent transplant to the area. One, not use to the weather yet ... and two, any recommendations on must-try restaurants? I love trying new foods and dining at different eateries, so I'm making a list of places to try!

like

Since moving in house from PP I’ve been astounded at how often business folks want to set up a zoom call to walk through contracts and rewrite language on the fly. Not only is it terribly inefficient, it leaves virtually no time to actually think through things, especially when dealing with long, complicated contracts for things like software purchases. Just wondering if anyone has any good tips for how to politely point out to people how bad of a process that is, assuming others face the same?

likefunny

Hi what will be the take home if fixed is 14lpa and 18lpa respectively?

like

Thoughts on going to pharma?

like

Anybody can become angry that is easy, but to be angry with the right person and to the right degree and at the right time and for the right purpose and in the right way, that is not within everybody's power, and is not easy ~ Aristotle

#thoughtoftheday

Post Photo
like

Hello Fishes from PwC AC Bangalore,
After completion of 6 Months Probation Period, do we get any official document for confirmation ?
If Yes, is it uploaded on any portal or HR/Coach/RL shares it ?
When it's shared ? Just after 6 months completion or later ?

like

We're weighing Docusign vs HelloSign for an e-signature solution. Anyone use these products and find any major issues or limitations?

like

Looking to connect with someone who works at the Slalom DC office. Would be in interested in joining your Federal practice. Happy to share resume, chat, etc. 7+ YOE PM/Data Strategy/Analytics in Federal space and another 3 prior to that.

like

Rogue thought for the day, why does every airport have a duty-free that sells bottles of perfume and booze? Of all the things at the airport or in general I don’t feel like paying taxes on I (cont)

like

I started a new job last week and still have no idea what I am doing. My manager is never in the office. I am just going there and sitting on my chair and doing nothing. I am thinking of looking for another job. Any advice

like

Is there a good reliable source for demand letter templates? I transitioned into my own practice from big law transactional work and don't have a nice repository of demand letters. Much of my solo work is dispute resolution which necessarily means I need to bulk up on my resources.

like

Hi Fishes, wanted to know how the appraisal cycle in Nagarro works. I had my last appraisal in September 2021. When will my next appraisal will happen this September or later?

like

Additional Posts in Excel Genius

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

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

Do you guys use specific color scheme to make you spreadsheet looks pretty?

like

I want to learn more about excel. Are there courses that you would recommend?

like

Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

like

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

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

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

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

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

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

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

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

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

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

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 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 scenarios would you use offset vs. and index/match formula? Also, what does including >1 [width] do to the offset formula?

Im trying to grasp why if I isolate the offset formula (currently being used within a sum product), I’m getting a spill error.

like

Does anyone know of any sampling marcos available online or resources to assist in creating one?

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