What is the best online tool to pick up VBA?

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

Depending on what you are trying to do, learning power query (built into excel so nothing extra to install) will likely be more beneficial in the long run. It also has the advantage of also being the basis of power bi so you get more bang for your time. VBA has been all but deprecated by MS at this point so it’s not going anywhere, but they aren’t going to expand it any further. The power platform is where they are making their investment. Unless you are trying to write specific interactive programs, you can likely get to what ever you are trying to do with VBA in power query.

like

If you mean training then I would recommend Wise Owl tutorials on Youtube.

like

I mostly learned by doing. I broke down what I wanted to do into the smallest possible pieces and then googled how to do them. I learned so much along the way.

like

I’m assuming you are asking about free tools specifically. If not, I’d like to piggy back your question and see what we learn.

like

Python

What a snake 🐍

like

Related Posts

I like how I ask randos on forums to give me crypto advice and kick myself when somehow I only hold coins that missed out on this run….

like

Hi 🐠🐋🐟

Can anyone let me know how much inhand i will get after using 80C 80E 80D?

And let me know is it good to package for DevOps engineer with 5.6 yoe.

Note: I am not showing off here just want to know the In hand as I am new to this package.
HCL Technologies Tech Mahindra Tata Consultancy Accenture

Post Photo
like

I love making fun of KPMG, but I'm going strong with my EY memes while I can.

Post Photo
likefunnyuplifting

Any idea where is Uday Odedra joining??

like

Can someone at UBS help me to get referral for M365 SharePoint
Job reference 247978BR
Please dm me.

Post Photo

Does UBS provide onsite? How easy/difficult it is process wise?

FAR, what a pain..that’s all

likefunny

I want to start learning DevOps, what is the right path to learn DevOps? Does TCS has good projects for DevOps.. Suggest me any combination with DevOps.

like

How do you handle rude clinicians in the workplace? I always have an attending talking down to me.

like

Planning a trip to Austin, young couple looking to move here from DC what neighborhoods should I see and or any thoughts on other cities to visit for the same reason.

My partner and I bought our home back in 2020. We got a good deal, low rate. But we want to move into a more spacious SFH. However, as we all know this market is crazy. Everything we want costs $620k+ and bc of rates it makes our mortgage estimates $3500+. We are currently paying $2k. And it looks we need to sell the house simultaneously as look for a new one or our contingency isn’t as attractive. I know it’s based on personal circumstances. But what would you do? - not move, sell and buy?

like

If you’re new to TX - how long and how did you get your DL & car registration? Appointments aren’t available until 2023… any tips?

like

I struggle with perfectionism and anxiety and this job seems to not help. How can I learn to be less of a perfectionist in a job that highly rewards this kind of behavior?

like

Any book recommendations for grieving the death of an estranged parent?

like

I am a newly graduated fresher mechanical engineer working in an electro mechanical company at Dubai, My current salary is 2500 AED, I would like to know about your comments and suggestions regarding my career which could help me through my future ventures.

like

Hi fishes

I just wanted to know, I have recently joined pwc india, but I want to join PwC AC bangalore.

So plz guide me. Please note I have experience of 6.5yre in AML, COMPLIANCE AND LEGAL SERVICES, FORENSIC INVESTIGATION ETC.

like

Got the invite for final rounds for SFA. Please help!

1) How do I ACE this? Rinse and repeat on PS1/PS2 prep or do more?
2) What can I expect - It’s on Chime and not in person.
3) They’re asking for salary expectations & I found out via research that the recruiter quoted median TC but I’d like top TC (200). Do I need to explain why my expectations changed?
4) Is there value in attending the Pre Recruiter Call/ Candid Calls?
5) How do they expect ppl to take a full day off for “maybe”?

TIA!

like

Hi All,

I have 2 years of Indian experience as a Data Analyst .I have knowledge of tools like Sql,Tableau,Excel and Python. I have recently moved to Toronto Canada. My dream job is to become a Data Scientist. I am looking for jobs right now as a Data analyst. Do you feel I should take time off from job hunt and work on gaining more skills to apply for Data scientist positions??
Should I enrol myself into a school(if so please suggest) ? OR should I just get a job as a Data Analyst??

likesmart

Any Fujitsu data science folks here?
I want to know how’s the data science team at Fujitsu pune - projects, wlb, learning?

like

Additional Posts in Excel Genius

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

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

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

Need help with a formula. I’m downloading bank statements to excel and I’m trying to do a lookup so it fills in the category based on the bank description. The problem is I’m trying to use the entire bank description as my lookup value, but the table array I’m searching only has the first part of the descriptions (because the last parts are all different bank ref numbers). How can I do this?

like

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?

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Why don't recent grads know how to use excel?

likehelpfulfunny

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

likeupliftinghelpful

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

What would you consider "Advanced" or "Expert" level Excel usage?

like

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
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