Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

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

I found the Ultimate Excel Programmer course on Udemy is good and cheap. I will say that it isn’t the most finance oriented but it gets the job done. At least for me

like

do we (deloitte) have access to udemy?

Udemy is a public website open to everyone. Cheap courses to learn whatever you want

Related Posts

Looking to transition out of a clinical role to a “clinical data/tech role” to help bridge the gap between healthcare tech and implementation to healthcare companies/field clinicians. Any recommendations to look for healthcare tech companies or getting started for a clinical data training?

likehelpful

Is is really easier to make partner at regional firms - less politics, more transparency around partner track, etc.? Getting tired of nobody in Big 4 being able to tell me what it takes to be a partner other than keep volunteering for people (aka work as much as you humanly can).

like

Is it worth pursuing a management position coming from being an engineer? What is your opinion on trying to go this route?

like

Has anyone exited consulting into independent consulting (1099/W2) roles directly with a company (or companies) and made lot more money then they would on their last consulting job?

like

Can anybody help with reference -
Have experience in VB.net project from last 3.5 years and finding it very difficult to get good company. 30sepLWD.
I wish to work in .net core and willing to put all possible efforts to learn. Have seen companies asking for ajax, MVC, javascript, API ..i am putting efforts to learn but for now need some good company offer urgently.

Sometimes reading or hearing about things from Partners makes me feel like it's not a worthy goal, but it's been my career dream for a really long time. I'm still pretty young, but wondering if I'm fooling myself. Do you ever regret choosing this career path? Or would you not have changed a thing?

like

To all the folks currently at Google, how has working at Google been like?

Do you have career fulfillment wrt:
- Your role & learning
- WLB & weekends
- Your pay & how much you feel valued
- The ppl you work with daily

Are you happy?

like

I accepted a job at an MBB company a month ago, not thinking I’d get the job at Apple I was interviewing for at the same time. Ended up getting the offer, and accepted, so I had to go back to MBB company and tell them the job was no longer right for me. The manger was pretty mad (understandably), and I feel bad doing it, but I have to think about what’s best for my career. I never had interest in MBB, they head-hunted me, whereas Apple was the company I’ve aspired to work for for a long time.

like

Any JD or JD/LLM exit to a smaller law firm? Have a friend with a smaller firm (around 5 attorneys) who primarily does real estate closings, subrogation, general small business law type stuff. He recently brought up the idea of a role at his firm that intrigued me. I see positives as: the opportunity to branch out and potentially do non-tax legal work, the chance to have a more direct role in business development, and maybe better hours(?). On the other hand, I’m concerned I am trading...

like

What’s a better brand name on your resume to move to tech companies and possibly international opportunities
EYP or A&M (PEPI)?

Grateful to receive offers from both and now the dilemma starts. Which firm to go to 🤷

Can do consulting for a few more years but hope to move to FAANG in next 3-5 years as we are planning to start a family

like

Does anyone know the sweet spot or years of experience you need to be a head of strategy? The other day I was told I had too many years of experience, and they wanted 7-8 years versus my 15 years. I thought that sounded ridiculous but I thought I'd check.

like

What is the value in professional certifications? ACCA, CFA, CIPD, etc.

like

Industry vs. academic research, what have your experiences in either been like and which do you prefer?

like

Hi Fishes,
I am currently working in stock market industry handling customer service desk.Right now i am in process of learning SQL & Python to transition into data analytics role n then later to Data science. I came across a post which states that it's already a saturated market. I have total exp of 9 years. Now i am confused how to go about it. Which firwill hire profile like mine or should i stop pursuing it. If there is anything else i can learn please advice. Thanks for help in advance.

Hi All,

I have 4 years of experience as a Salesforce developer.
Can anyone suggest good product based company for Salesforce developer.
I have extensive development experience on apex,Aura,integration. After after spending 3 years in service based companies, learning is very low pace now. So wanted to switch to a product based company.
Attend one interview in sirionlabs and got offered but not sure how it is.

like

SAP consultants - which certification do you recommend as a sap security associate?

like

Currently get a Master of Science in Project Management and the concentrations are Agile PM, Analytics, Construction Management, Leadership, Leading and managing technical projects, Organizational communication, Project business analysis, which one should I pick and any advice and recommendations?

like
like

🐟 fam, need your help. Considering a senior role at Amazon in their Solutions Architect group. What are some of the exit opportunities 2-3 years down the road.

like

All- I'm wondering if this community has insight on the market for Counsel at amlaw 25-50 firms (transactional practice). Specially curious about current base + bonus comp, stated billable hour expectation, hourly rate and messaging on advancement to NEP.

like

More Posts

Have you been invited to join The Human Gathering?
Did you do it? Was it worth it?

Need advice. Moved into a new apartment in November. Before we even moved in, we noticed some of the windows had gaps in the sealing, leaking air. Landlord “fixed” some. We have increasingly noticed issues with the windows, including airflow, rain, and this morning, snow inside our unit. Previously our landlord gave us $100 off rent to compensate for heating bills. But the snow is too far. What rights do we have as tenants? He claims he’s replacing the windows in the spring but we’re skeptical.

like

Adidas 😂😂 phone booth

Post Photo
likefunny

For those in a in-house position in Florida, can you please share your annual salary? Trying to get an idea of what to expect…

likehelpful

How do you deal with waking up every day with a sore neck?

like

Layoff folks, how are you guys doing? I'm DREADING the upcoming busy season being a new senior handling new clients in a new company...

like

Is it not appropriate if I want to switch to another cleaning lady because she constantly changes our schedule due to family reasons? She canceled on us last week for family plumbing issue, and she is MIA now telling me her father passed away. I know it’s hard to deal with all those things but we also need cleaning. She was always a 30min-1hour late for the past year and half, but she cleans well. And I don’t know how to comfort her except adding a bit more tips.

like

Any tips on coordinating a job search with a spouse? Spouse and I are both job hunting, and aligning on criteria for the right cities, roles, industries and other factors is complex. Should we pick a city first and focus there? Should the least flexible one get a job first? Something else?

like

Anybody from Infy team working new IT portal ?
Are they guys making you work over weekend now? How you guys are managing stress ?

like

I forget things a lot and my attention span has drastically reduced.
Anybody else facing these ? 🙁

like

Austin vs LA vs NYC as 23M? Currently a transplant in Austin from Philadelphia and have been here for about year. While I love QOL for COL here, it feels a little one dimensional at times. I resigned my lease for another year just to give me time to think a little more. I definitely miss the feeling of a big city (lived in Tokyo for a little and visit LA/NYC often) but that obviously comes at a price. Any thoughts?How do the lifestyles differ?

like

Is there any resources someone can point me to about the potential legal issues and more information from an HR perspective about contingent employees (temps, contract workers, part-time workers) versus normal FTE’s?

I’m working on a project for an HR class and finding good sources with real evidence about this from SHRM and news publications has been rough. Thanks!

like

Hello guys, which training we need to do to become SME in RBS. And where can I find that

like

Hi Guys - Can anyone help me with referral to Selenium QA automation lead role. YOE - 7.
How much CTC can be expected considering current market trend? CCTC: 17.5

like

Has anyone taken the CA brokers exam? Thinking about taking it as I enter my second year working in real estate.

like

How much time is take for became financial manager in luxury sector?
Is better after a long period in audit?

like

Fishes, I need to get my PF transferred from IBM but because some typo in the name from IBM's side PF transfer is failing. Spoke to PF office and they suggested to speak to IBM and get it corrected. Can anyone share details of someone in IBM who can help in this matter?

like

Dumb question but what’s the difference between EFF and DFF flex fields in Cloud?

like

Any one hiring in Chi Town for an AD?

Has Amazon (retail tech teams) improved in terms of work life balance since they introduced the new work life balance related leadership principle or is it still the same - dependent on if you’re lucky to get a team which has a good balance?

like

Additional Posts in Excel Genius

I have multiple sheets with same columns that I want to combine in a single sheet within the same workbook without having to copy paste . They all have same column names and each one has a header row. How to do this ?

likesmart

Please do excuse how dumbed down the example is, I’ve had to replicate the problem on a much smaller scale with all sensitive data removed.

“Location” refers to a location of stored data and “User group” refers to the user that has access to the location.

I am attempting automate the finding of all instances of where the “U1” user group occurs but exclude it if another user group also has access.
Continued below….

Post Photo
like

I’m experiencing a delay when I switch between different workbooks where it would take at least 5 seconds until I can click into the new workbook. I’m losing productivity especially when I’m doing a copy and paste task between different spreadsheets. Anyone else experienced this before and know any potential solutions?

like

New to Fishbowl, would love some likes! Or you can comment with your favorite IF statement in Excel. (Long formulas encouraged!) 😉

like

Noob here:(
Lead wants me to limit values in 5 columns - achieved
Now she wants me to implement - If 1st column is filled and others' are empty, raise an error. Tried ISBLANK but it removes drop-down

like

Will index match fall by the way side with the Advent of xlookup?

like

Does anyone else find it frustrating when co-workers find out that you’re good at Excel, they feel the need to ask you how to do EVERYTHING, how to data sort, how to use basic functions and try to pawn off work to you because “your proficient in Excel so you’ll get the job done faster??”
I didn’t mind helping at first, I’ve started telling them to start googling it or saying “I’m not sure how to use SUMIF 🙃”

likefunny

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

Hello everyone .. what is the quickest way to learn the excel program inside and out

like

Is there easy way to remove only spaces at end of a cell? For example (Mid West ). Want to only remove spaces after West

like

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

I would like to create a geographic heat map in excel using a list of addresses that will be continuously added to and would like the map to update as addresses are added. TIA

like

My sheet has multiple cells with Notes. Whenever I reorder rows or add new columns, the notes go completely out of whack (get displaced or squeezed). Any quick fixes? Also why does this happen?

Any ideas for how to reshape a dataset from wide (panel) format with two column header rows to long (pivot) format while keeping one column header row?

Post Photo
like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

How do I convert a google doc link to excel?

likesmart

Just got a new personal laptop. Is there a good way to get Microsoft Office for free? I’m looking for a download rather than the subscription usage

SUMIFS wildcard question: is there a way to pick up values based on the cell containing a wild card? (So not an in formula wildcard)
Example: I have scenario A1, A2, & B1
Some criteria apply to both A1 & A2, and I would like to not duplicate the criteria. So when the user selects scenario A1, I want to pick up criteria A* & A1, but not A2. For selecting scenario A2, I want to pick up criteria A* & A2, but not A1.

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