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

Hey all! Looking for information regarding “Design Camp” at Meta. Would love any documentation that can be shared on how it is organized/schedule, live vs recorded sessions, if you found it helpful, etc. I’ve been trying to put something similar together and lots of people have mentioned Design Camp as reference. Tia

like

Thoughts on account executive/industry manager roles in Google?

like

Which companies & roles pay very well, hybrid work approach, and allowed unlimited pto?

like

Question for yall. How likely is an offer once a company decides to do a reference check? I know I am in the final 2, from context clues in interviews. I just dont want to get my hopes up.

like

Hi Fisher ,
Can anyone guide me or provide the link for how to get job visa for UK or Europe from India, as I am getting job opportunities in UK but they are asking work visa for UK as the company where I am applying are not eager to sponsor my visa?

like

Currently working in-house for a large bio pharma - like the company and most of the people, but the work is really getting monotonous and I just leaned through the grapevine that I am making significantly less money ($15k to $30k) than others in the same level/grade as me. The work I do is equally difficult and I have a smaller team because people have left, so there is no way “type” of law justifies this. I think I just did a poor job negotiating my salary and raise. Any tips on what I can do?

like

If anyone’s interested in knowing more about Tosca - E2E functional test automation tool. Please LIKE and DM

like

I’m an international student with MSc in CyberSecurity. I’m in search of a company willing to sponsor my green card. I’m proficient in Cloud Security with certifications and projects to show for it. Any potential employer can please reach out.

like

Hi

Has anyone from the cognizant registered BH for a car in Pune or Maharashtra? And are they allowing it? As per rules its allowed but I heard RTO is declining the request

Anyone heard of dentalcorp? How is the pay at the Sr manager level?

like

Hi folks, I have been with Amazon for a year and looking to change due to poor wlb. How do I get a interview with them and how high is the bar compared to Amazon india?

Google

like

I am struggling to spend the time to study for the PHR. I have everything I need, but I feel exhausted from the work week every weekend. I’m looking to take it in August.. help? What do I do?

like

Hi fishes, need urgent advice. How is the HDFC Index Sensex Plan? I have invested 75K but it's in loss as all others. Should I continue to average it out or stop investing in it? The loss is higher in this compared to other funds.

likehelpful

Any independent M&A professionals here? Curious what advisory services should cost. We are going to start a roll up. Starting with our agency (7mill revenue) hope to end 2021 at $20 mill.

like

How’s the pay and WLB at the corporate finance/IB subsidiaries of the big 4 compared to traditional MM IBs?

like

How do you best support your students who do not speak English? I have four ELL’s in my 6th grade ELA class and they don’t receive push-in or pull-out Bilingual support during my class. Do you pull them for small group to provide instruction separately or do you just try to use google translate to translate your lessons and the work? Any best practices? I’d love some help.

likehelpful

I am sick of being a realtor! I've been trying for 5 years and have only sold 3 houses. Where I'm from (small Southern town) nobody is buying. Most people's families already own homes and it's just a bummer to see all these nice houses deteriorating over time.

like

Bain & Company McKinsey & Company Bain & Company Boston Consulting Group what are the main services you offer within M&A group?

like

State bar fees while you’re clerking? Please tell it doesn’t just come out of your own pocket during the two years? 😭

like

Additional Posts in Data & Analytics Consultants

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

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

likehelpful

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

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

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

Anyone use Cloudera? What has your experience been like?

Have you ever failed to deliver? What was it and why?

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

Could anyone recommend a set of indices that are publicly available and is a good predictor for consumer spend in home renovations ?

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

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

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

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

It’s been ages since I’ve taken college statistics. Can anyone recommend an online course where I can review and brush up?

like
like

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

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