So, I’m interviewing for a job that is looking for someone with VBA. I have no idea what VBA is and how fast can I learn it? Tools, tips are appreciated!!

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

Is VBA coding a core function of the role or a “would be a useful skill”? In either case, don’t try to BS that you know anything. If the former, you should probably withdraw your candidacy, spend a year learning to code, and then try again when the job opens again. If the latter, say you don’t know anything about it but are motivated and eager to learn.

like

Visual Basic for Applications is the programming language used to create ‘user defined functions’ in Microsoft Office products.

Basically, it is a language that allows you to create your own functions. Want to add a button to an excel sheet that executed a very specific data transformation? VBA is the way to instruct Excel to do that.

It is most often used to automate repetitive tasks. Some companies have their own VBA functions (referred to as ‘macros’) that are a key part of their process. For example you might save 3 spreadsheets in a folder and open a 4th sheet with a macro (VBA script) in it. The macro might, for example, instruct excel to open the other excel files in the same folder, copy and paste the data, and then carry a set of specific tasks to create one combined excel file.

Manually this might take someone hours but as long as the data are always in the same format, the macro can do it faster.

like

It definitely would take some time to learn it. Although it will be familiar if you have any other coding experience.

likehelpful

Given that you are unfamiliar with VBA, I’m inclined to believe you also do not have other advanced analytical skills.

By all means, learn a new skill but know that this one will take time and practice. Do not sign up for a job that requires a skill you do not have. It will be miserable for everyone involved, as you will either quickly be fired or long road to be managed out (which means a painful job path).

I’ve worked with someone junior hired into same team who lied about SQL knowledge and it was bad for all involved.

like

Sadly I do not lie in interviews. I should though, but I was honest about my experience. I’m very excited about the role and just wanted to get a head start on preparing for the next round interviews. Thanks for the advice ladies and gents!

You can start by recording what you’re doing in a spreadsheet (there’s a button for that) and then look at the code that is generated.

Related Posts

Interviewing for a data scientist role. They gave me a week for a case study where I’m asked to clean data and then derive data insights (python), and then make a PowerPoint to present my process and results. Any case study samples out there I can reference to? Much thanks!

like

Fishes, I have a job title question. Does it matter if a role is in the same project with different titles? Example: SA, State and Local, Researcher vs SA, State and Local, Business Analyst. The job description makes it sound like they are the same project. However, Business Analyst does have more requirements/qualifications listed than Researcher. I’m coming from industry (3 YOE). Any insight is much appreciated! Thanks :)

like

Hi Guys,

I am an 11+ YOE java full stack developer, recently appeared for a Principal SE interview with 
Natwest group. Wanted to check if I should ask for a B8 or C9 designation and what's the min-max salary range for B8 and C9.

like

Currently going through some negations on an internal role. I’m currently at 88k and they offered me 100k for a position that requires a lot more work. Do you guys think it’s easier to land a higher salary when applying externally rather than internally? Also this is for a territory sales management role. They stated 120k+ is extremely high for that role. What do you guys think? Playing the game?

like

Generally speaking, how difficult is the Google interview process for a software engineer role? My husband has attempted a few times, to no avail.

like
like

Hi fishes,

Anyone who switched from Big 4 global services audit career to other career like accounts/financial analyst.

Please let me know.

like

How does one get into underwriting in the western MA area? I have an associates degree in business and 5 years of insurance experience. I just can’t seem to find a company near me to apply for an underwriting entry level position. I’d rather not start in claims and work my way into underwriting but that’s my only thought process. Thanks in advance!

like

How do you approach a negotiation when you were told the salary cap at the beginning of the interview process?

Is there ever a fair reason to revisit that number?

like

COVID-19... Curious what LA BigLaw thinks about the possibility of Diploma Privilege or a postponed bar exam here in CA? NY decided to postpone despite significant potential consequences (see thread)

Has anyone transitioned from audit to a strategy / operations type role? I’m coming up on year 5 audit and looking to try something new! Any advice would be appreciated

like

Friends, any news for ITA promotion?

like

I've worked as a maid for a long time but am tired of driving to everyone's homes, so I'm thinking of trying out a job as a housekeeper in a hotel. Is there anyone out there who has done both jobs and can tell me a bit about the differences? I would appreciate any advice at all.

like

If you have 9 YOE software implementation, 5 years as a manger at the current job. 1. Which solution architect position should you apply to? Senior or manager solutions architect? 2. What’s above manager at AWS?

like

As an MBB analyst, how do I differentiate myself on my app among the hundreds of other MBB analysts applying?

like

Does any fish have experience prepping and taking the CAMS exam? I would appreciate any advice on study materials, exam preparation tips, and information about the exam.

Is a System engineer role better than DevOps role?

like

Can anyone share the interview process for salesforce business transformation architect? Would there be a case study or presentation?

like

I have a first round interview at TikTok for a head of business development role. I REALLY want the job but don’t want to price myself out or under…does anyone know of a range?

like

Anyone exit to a sports team? Looking at a business strategy & analytics role. Wondering about base pay, total comp, benefits

like

More Posts

Anyone working over a reactjs based project in CTS could you kindly DM me so that I can reach out to understand more about what I can expect in webdev project with CTS?

like

I'm at a career juncture and have decided on a career in anti-money laundering as my new path. I'm also highly interested in additional education to further my career and am eyeing graduate school. Which is best? A law degree or a master's in international relations? Those are where my interests lie. I keep reading that JDs are valued in compliance but am wondering if a different graduate program is better for my goals. I already plan to obtain the CAMS certification. Thank you!

like

Does anyone have alternate sources of income? What are they?

like

Being a realtor is not what I expected! I was so excited when I joined being younger, but nowadays it's all work and too little time off. It's a bit frustrating because I'm not sure where to go from here. I've been doing this for 5 years now. Any help on what choice to make? I do not have a backup plan.

like

I took last Friday and Monday off for Lunar New Year. Last Friday was an optional teacher workday and we had regular school Monday. O had out it into the system back in September and gotten... 1/+

likehelpful

Anyone enter Draw for Off White?

Has anyone ever held two sales roles at two different companies at the same time? My main role is remote and I think I can take on another remote role, what are the odds the companies would find out about each other?

like

So in 2020, firms pay $10 to enter the lottery, then if selected, firms do an application. Doesn't that mean you might get 500k people entering the lottery (especially with outsource comp)? Wtf

Trying to update resume with approx 1 year in FDD. Any good examples or resources?

like

I think I might enjoy audit more than advisory work. 🤷🏻‍♀️

like

Any Dallas M 🐠 to hang out and show me around?

Does Accenture require their employees/consultants to report all of their (including the family) financials holdings?

like

Anyone willing to refer to Clipboard Health or Color?

like

I have 2 Yoe as a full stack and recently I cleared Accenture full stack interview and I am waiting for HR call. My current CTC is 7.4lpa how much hike should I ask from Accenture HR???

Hi Big4 fishes,

With my Solutions Architect profile in Supply Chain , looking for a consulting role.

I find it difficult to get referral, would you please help me to pursue my career with #Big4 please.

like

Hi,

I have the following offers currently, please suggest which should I join:

Qualcomm (Banglore) : 15L fixed, 4.5L JB
Paytail (Gurgaon): 17L fixed, 2L JB

Note that paytail is a startup but the cost of living is less than compared to banglore

like

Good first date spots in East Village? Tips on how to make it a good date?

like

Be a good neighbor

Post Photo
likefunny

What’s up my consulting fishes!! Manager at Accenture, and really enjoy the HC, Org Analytics, CM, Org Design side of things.

I’d like to continue building my skillset here and venture into product development to facilitate strat consulting for the areas above (sorry for the buzzwords).

In this case, is an MBA required to succeed or progress to the MD, partner, C Suite level? Or should I grind my way through the industry given my interests are so pointed?

Would love a convo and/or guidance.

like

Does Alpha do any strategy/M&A work or just implementation type of work in the US? Talking to a recruiter now. Thanks

like

Additional Posts in Excel Genius

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

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

What are your top Excel ninja tricks? Ones that few people know...

like

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Anyone use teammates analytics? Does it work well with large worksheet? I am cleaning up this large Excel sheet, it's taking so long I don't even know if it's taking it's time or what.

like

What are the most typical models you all build

likehelpful

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

This is pretty vague, but what are some formatting tips n tricks for a model? I know the basics (like color code) but borders, titles, font, tables always look weird and I have no idea how to start

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

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