My coworker is working with datasets so large that scrolling and filtering feels like an endless task. I know there are smarter ways to handle big data, but it’s easy to fall back on manual steps.

What’s your best strategy for working efficiently with huge Excel files?

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

move to powerbi and link to the excel file for updates

helpful

At the most simple it would be to make a helper column to sort large sets by type (high, medium, low, etc. if col A >= $100).

You can build many formulas for this but building simple helper columns usually is a great first step

Yes helper columns is key

Related Posts

Do you guys mind commenting on the work culture in amazon. Non tech related. micromanagement?

Larsen & Toubro Infotech Ye LTI walon ko delhi ka office band hi kar dena chie. Jab koi mail trail mein rakhte hi nhi NCR walon ko toh location kyu dete ho :( Larsen & Toubro Infotech

like

LTI is Hiring for below Oracle - BU positions

Need immediate to 30 days joiners only

Location: Bangalore/Mumbai/Pune/Hyderabad/Chennai

JDE CNC
YOE :4 - 10 Yrs
Skill : CNC

JDE Finance Functional
YOE: 4 - 10 Yrs
Skill : FUNCTIONAL-FINANCE

OCC (Oracle Commerce cloud)
YOE: 4 - 10 Yrs
Skill :OCC

Oracle Flexcube
YOE :4 - 10 Yrs
Skill: FLEXCUBE

Oracle CPQ CLoud
3-5 years of experience in Oracle CPQ Implementation & Support
location - Mumbai

Interested plz DM with job role to apply

Such a true depiction!!

Post Photo
like

How hard are the Series 7, 65, or 82 exams? Interested in those because I don’t see myself reaching accredited status via capital alone any time soon.

like

What’s a good D30 retention?

like

Hi, is anyone's company looking for a
Market Research, Strategy or Business
Analyst with 2 years experience across
tech alliances, corporate strategy and
SaaS product operations with a top
engineering school background? I'm on
stem OPT and from the U.K., working in
the US and looking to change employers
to explore new opportunities, so
immigrant friendly is a huge plus. It
would be my pleasure to get you that
referral bonus. I'd love to connect via
Linkedin as well.

Hi Fishes,
I am looking for job reference for Software Engineer role in Singapore.
I am currently have 1.4 year of work experience

like

Hello Witch employees.
Can someone help me with job reference.
Thanks in advance

Post Photo
like

Hey guys,

I really need your help.

I recently got a good opportunity in one of the Mncs to work but i was worried as i had absconded from one of the companies just after 2 months of working there due to mental torture.

I have a shown the same as gap for personal reasons in my resume.

Will i have any problem after joining this new MNC during background verification as per the standards?..

Really need your help if anyone has faced this situation or know anything on the same.

Thank you

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

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Hey, I am very much interested in working for Agoda. Are there any referral leads? I applied for a few roles but did not get get any response yet. Any leads would be highly appreciated :)

Is it smart to follow up with HR with an “ultimatum” (don’t know what else to call it)? Still no decision a month after final rd, keep being told positive feedback and I’ll hear by X date but don’t...

like

Help connecting with Senior Partners:

Hello All, I run a technology consulting practice. We work with strategy consulting & advertising teams as their extended technology team.

We have started a blockchain, Web 3.0 & NFT related business unit. We are working with Polygon, Flow Blockchain & Ethereum based solutions.

We are looking for recommendations & introductions with Senior partners in different agencies.

like

Accenture strategy folks.. can someone confirm if work from home is about to end?

My joining is on 16th November. I haven’t received any credentials or login details. My BGV and all the documentation is complete. Can anyone tell me about the onboarding process? Will I be getting any credentials or something like that?

How long is the interview process at CBA? How many rounds of interview for senior poaitions like senior technology businee analyst or Product Owner?
Any feedback on work culture

@CBA

like

Hi Fishes,
Qburst is hiring across roles now. Pay is competent and wlb is amazing. If you fit any of these roles please feel free to DM me for a referral. Happy to help in these trying times.

Post Photo
like

Rough out here.

Post Photo
likefunny

Additional Posts in Excel Genius

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Anyone know what these badges are?

Post Photo
likefunny

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

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Any book recommendations on excel modeling for real world business applications?

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Still don't have xlookup. #fomo

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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