I have an excel sheet which does QA checks on client files , has many checks from column quality check to account match rates between file and checks that all charges from 1 file are available in the other files. There are many other checks also. It’s very slow and inefficient. How can I modernize this? Is there a better for efficient / faster application or tool I can use to build out a templatized comprehensive QA workbook.

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

Use R or Python!

like

And use AI to generate the code for you - - ChatGPT and Github Copilot. It will have bugs but be better than you starting out. Get a proof of concept fast

like

Power query

like

Use a coding language. Build a template .py or .R file.

like

Python

If you’re stuck using excel for any particular reason, even upgrading to basic VBA would help.

If that’s the case I’m guessing you likely have significant efficiencies that could be gained by writing better code.

For example, are you:
-Avoiding using cell formulas via code
-Turning off screen calculations
-Ensuring automatic calculations are off
-Disabling events, animations, page breaks
-Turning on option explicit
-Using “for each” in place of indexed “for”
-Optimizing large memory tasks (e.g., bypassing the clipboard for copy paste, leveraging arrays)
-Minimizing the use of “select”
-Leveraging “with” when performing multiple actions on the same range

Some of these, particularly the first couple, can immediately cut your processing time by half or more.

Related Posts

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like
like

How is SAP projects in IBM?

like

What kind of work does you guys do here am one of the real estate property management licensed agent am looking to employ new workers this week if you are interested am paying $650 weekly message me directly for more details ASAP.........

like

What agencies do you think are the most supportive of women and families? i.e parental leave, work hours, etc

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Does Cannes not understand it's devaluing itself? It's the H&M of creativity. (Well not at $5 a pop but you know what I mean 🤭)

likefunny

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Does anyone have any insight to an agency or ad company that has mainly luxury/fashion clients? Really looking to get into the luxury fashion advertising/marketing niche and don’t know where to start. Thanks! I’m in Chicago, by the way

like

Are there any outdoor basketball courts with rims up in the streeterville/river north/gold coast area?

like

Anyone have lines on directing gigs (comedy or otherwise)? I'm finishing a long-term job and looking to next year. I've won several awards for sorry films I've made, have creative producing experience, and am a very strong writer. Also, loads of spirits brands in my portfolio. Can go freelance or if someone is looking to add to their rosters, I'm totally down. Thanks!

like

AMERICAN EXPRESS India is hiring for Business Analyst role.
Title: Analyst - Risk Management II (Req ID -21022599)
Experience: 4 years

For more openings, kindly go through the below link and share req id for referral:aexp.eightfold.ai/careers?intlink=us-amex-career-en-us-home-findalljobs

JD screenshot is attached.
Kindly DM me if interested

Post Photo
like

Can anyone please please refer me Gartner

Post Photo
like
like

What are the companies willing to sponsor visas into Singapore? Any referral will be helpful thanks.

like

Hi all - just joined the bowl and planning on voting this Nov for first time. Not a Trump fan but not trying be biased as well. Can both sides explain to me the reason why people should keep trump for another year vs a new president? Thanks

likefunny

What does comp look like for IBM GBS at Senior Consultant and Managing Consultant levels? Public sector

like

Welcome! This is a toasty little haven for the misguided (Floridians)

likefunny

How do you detach from work? I’m wired at this point to be so attached that even when I’m off I’m super stressed out, and have to look at emails and keep up or else I get severe anxiety. Anybody?

like

Typical days on a difficult project with a difficult partner

like

Additional Posts in Data & Analytics Consultants

What’s the best/simplest way to understand Sets vs Groups in tableau?

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

What is a data lake in basic terms?

like

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

today I choose violence

Post Photo
funnylikesmartuplifting

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

How hard is it to get an interview for SWE at FAANG outside of on campus recruiting? I’m in GT’s OMSCS program right now, hoping to take advantage of career fairs this fall, but I don’t know if I’ll have enough time to prepare for the technical interviews before then. I’m worried about missing out on the recruiting opportunity and having to resort to applying online/LinkedIn afterwards. Any insights into this?

like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

How is Deloitte’s Analytics and Cognitive practice doing? Saw a couple of open Data Science roles open on their website, are they actively hiring

like

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

like

How does everyone in this bowl feel towards master’s degrees in data science/analytics? I didn’t study this in undergrad so I’m looking to get an analytics degree but I’ve heard mixed reviews.

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