•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
is vba, macros easy, for someone who came from sql and python, or are they unrelated?
Our take
Transitioning from SQL and Python to Excel's VBA and macros can be a smooth journey, given your programming background. While VBA and macros may initially seem daunting, their logic aligns with concepts you already understand. With focused effort, you can grasp the fundamentals within a couple of weeks. However, balancing your learning with Power BI and DAX is essential, so prioritize based on your immediate goals. Embrace this learning phase as an opportunity to enhance your data analysis capabilities and streamline your workflows effectively.
i am a fresh graduate who was originally aiming for data science or llm engineering, but the market require experienced people for such roles, so i am transitioning to data analysis, i i aimed for learning excel and powerbi, and so far learned text and list formulas, filtering, sorting and all these stuff, you would see what i learn if you see my posts in this sub from my profile, but now i think the next step would be look up, vba and macros, would they take time, or can i get a grip of them in a couple weeks? i still need to learn powerbi and dax so i am kinda rushing it
but python wise i think i am solid and have more than enough knowledge for the tools and libraries, since it was my main thing for 2 years
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Do you use VBA regularly or have you moved entirely to Power Query and formulas?I have been using Excel for years and VBA was always my go to for automation. Lately I have been seeing more people say they barely touch VBA anymore because Power Query and dynamic arrays cover most of what they need. I still use VBA for things like automating reports across multiple files or generating custom email bodies from data. But I am wondering if I am behind the curve. For those of you who work in data heavy roles, what is your current workflow? Do you still use VBA regularly or have you replaced it with other tools? Curious if I should be spending more time learning Power Query and the newer formula features instead of maintaining my VBA skills. submitted by /u/ProfessionalOk4935 [link] [comments]
- how did you improve your workplace's legacy vba macros?I recently transitioned to a non-clinical role in a public health care system. part of the on-boarding was a 12 page, 20 step tutorial on how to 'do the macros'. The workflow simplified is: - Get source data from EHR/BI - Open the excel online (microsoft 365) "Daily Review" workbook in the desktop ms excel. (hopes and prayers it doesn't crash) - copy data (columns of patient ID, demographics, medications... you get the idea) from EHR, paste into this Daily Review - run macro (click a button) which cleans, filters, applies conditional formatting i think - save - go back to excel online and resume editing there. The VBA code was created (not sure if it was written coz it has no documentation) by a colleague who is on extended mat leave. I can see a lot of 'modules'. Can't tell which is active. There are probably lots of historical decisions. The daily review file with its many many sheets is saved in multiple locations in case newcomers like me or others break it by accident. I am told we can't change anything like move a column closer to the beginning coz well we can't. I don't know VBA but could probably figure it out if I watch a tutorial on it. I am linux user and know basics of C, python and make good use of my claude code with the pro subscription but never really worked with spreadsheets. I am wondering if anyone was in a similar situation and how you managed it. Is moving to office scripts (typescript) a viable alternative? Any other life improving tips would be appreciate it. Or maybe I should just give up and focus the energy elsewhere? submitted by /u/Neat-Badger-5939 [link] [comments]
- Fastest way to automatically manipulate excel files, ideally without opening them.I’m (re)designing an automated system we have that uses macros to: a) extract info from an individual “instruction” file (using VBA class variables to store the data) b) creates folders, copies over files, updates named ranges in certain files, copies certain tabs from certain files into other files, creates .csvs of certain tabs within files. Lots of stuff, but all essentially creating new excel files and using their contents to manipulate or create more excel files. c) repeats for multiple other individual files Basically, a lot of using vba to open some or other file, edit it, save it, repeat. This can only really go as fast as Excel can run, since everything gets bottlenecked by eg. opening and saving some large Excel file. I’m sure there must be a way to read / manipulate certain parts of Excel files without necessarily opening them in instances of Excel, which is the major time/resource consuming bit. Is python with the Pandas library any faster than VBA for this sort of thing? Everyone is always praising PowerQuery but not sure how it could potentially fit in here. submitted by /u/PedosWearingSpeedos [link] [comments]
- How did you go from basic Excel to advanced level?I’m currently comfortable with basic Excel functions, but moving to advanced features feels a bit overwhelming. There are so many formulas and tools, and I’m not sure where to focus. For those who improved their Excel skills over time, how did you do it? Did you follow a structured learning path or just learn as needed? Any advice on what to focus on first would be really helpful. submitted by /u/ModernWebMentor [link] [comments]