My job is willing to pay for an Excel course, I'm looking for a really robust training that covers everything from formulas and functions to Macros and VBA. Anyone have any good suggestions?

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

Anything on Udemy is good. Just look at the ratings and number of reviews

like

Check out Maven Analytics. They have a great 10 week immersion course. I took it. Loved it!

like

If you are going through w the training also look into Microsoft’s certifications to become an excel expert just something that looks good on a resume

like

I'm pretty sure there's also free training modules in some of them, at least with the PBi one.

They only charge for the test so in theory you should be able to get to a good enough level to pass the exam for free.

Get them to shell out for Miss Excel's courses. On-demand, lifetime subscription with access to updates. Kat does a great job explaining, but you can always play back the video as many times as you need.

like

Also make sure it has office scripts in there too

Related Posts

I have hit my wall. I cannot do public accounting any longer. I cannot deal with the constant focus on compliance, billable hour and the general unproductive behaviors/mindsets. I remember a day when we were here to help clients. Now I just feel like we are here to bill clients. I want to go help someone build something.
Now I just need to figure out how a director with a tax background can have transferable skills to something else...

likesmartfunny

Made M1 this year.Advisory practice. Secret to fast track SM? Utilization vs Selling work what should be the focus? Any tips who made M1 to SM within 3 years?

like

Received a buyout offer but thinking of turning it down to recruit for more growth oriented roles as that’s where my real interests lie. Any thoughts on starting a career in buyout vs. directly in growth?

like

If you were to transition from bedside which path would you choose?? Education, Quality management/coordinator, Administration?

like

Hello everyone. I am looking to transition into the medical writing field, but I don’t seem to have the right type of experience. I have technical writing experience, but I don’t have experience with clinical studies or clinical trials. Does anyone have any advice on how I can gain more experience in this field? I am pursuing the AMWA Essential Skills certificate and am working on a master degree, but any other information would be greatly appreciated!

like

Typical exit ops for M&A operational due diligence?

like

Is it difficult landing an in-house position as only a second year corporate associate in big law? I know some people who went in-house straight out of law school and some who had no transactional background but went in-house after just a year of practice. Not having that same luck on my end.

like

Any recommendations for learning about and getting into screenwriting, and taking vague ideas from my head and fleshing then into something more concrete?

like

Guys product development vs
advanved tech stack with service.
Which is better ?. Why ?. The reason
I'm asking is, I worked with Big data
and tools in my old company. Now
moved to Product devlopement.
This one has cloud and all but still
felt like not that much advanced
What do you say?

like

Hello! I am a recent graduate of a medical billing and coding program and I’ m finding it really difficult to get a job because most employers are looking for someone with at least 3 years experience. How do I get my foot in the door with no real time experience?

like

How do PE exits look like for emerging market funds in Middle East (e.g Abraaj group type firms)

Hello IBMERS,

Can anyone help me know about band 07b in IBM. Designation - Senior Advisory Consultant.


What are the roles and responsibilities for this position?

Hello Friends, Please help me out which paid online platform is best for java full stack developer. I have 7 years of experience in java and want to enhance my skills more. There are many in markets like:- upgrade, great learning, scaler, simplilearn and many more. Please suggest which one is best. Or anyone here joining any of these platforms yet?

Please tell me about work culture, increment , growth and wlb in Philips Bangalore.
YOE: 2 year
Role: SDE 1 in Philips Healthcare.
Tech stack: Java SpringBoot

like

Exit strategy: Where do people work after a career in Advertising or PR? Add examples of your past colleagues.

like

I’m currently doing IR work but would like to do something more on the technical side (ie: more forensics or technical). Does anyone know if forensics firms or any firm that offers a mix ? I have both a Cipp-Us and cyber/ Sec+ certs.

like
likefunny

I'm being asked to be involved in product pricing for the first time, and lack any knowledge or experience in that area. Any suggestions on courses or books or websites? I'm considering the Pragmatic Marketing pricing course, so would be interested to hear from anyone who has taken it.

like

Hi all. I’m looking into potentially transitioning to PE with a background in Finance Transformation consulting @KPMG of 4yrs. Do I stand a chance? Any advice on how to best approach this would be super helpful, thanks.

like

More Posts

What are your thoughts on Porsche’s consulting subsidiary? Would it compete with T2 or T3 when it comes to industrials and automotive?

like

Why my proceed button is disabled in Wipro embark platform for laptop collection mode? My joining date is on 14 Feb tomorrow and my onboarding is not completed yet. The status is showing on embark as onboarding has started. Please reply.

Post Photo
like

Pwc AC Do you have any opportunities in life insurance QA I am open to relocate anywhere

like

I want to leave my captive company. I don’t think I am ready to be totally on my own even with a cluster group etc. There is an option to be subcontractor in another independent company. I can write she said like 300 companies in many states, it would be helpful because I have many friends out of state. Is taking 25% of sales for giving CRM and companies too much? Seems like a lot. It is like “owning your book” but I assume I would pay a high price if I want to totally manage myself in a futu

likehelpful

Human interest stories might not be where the money is, but making the switch has saved my sanity after the tragedy I’ve covered the past few years.

like

Are any other counselors getting pulled constantly for testing? I am in NC and my district is in person 2 days a week and remote 3 days a week with A on Mons and Tues, B Thurs and Frids, and group R fully remote. So when we test, we have 3 different groups 3 times the testing and not to mention the accommodations...

like

Moving to the area for work and was wondering if I live off of the San Bernardino metrolink line, when I bring the train in to Union Station and then transfer to the LA metro system, will I end up ...

Thoughts? What could be going on here?

Post Photo
like

Does your firm give you credit for hours that were written off? Sometimes I feel if you don’t lose anything for hours cut from the bill, you have incentives not to be 100% honest w/ your timesheet.

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Anyone from PA Consulting know the ranges for Consultant Analyst and what a typical offer package would look like?

like

I was offered a associate manager job in quality in HCL technologies which is in sector 126.... Can someone confirm how much should I expect... My current package is 6.55 lpa and I have total 7+ yr exp and 5.5 relevant exp in quality auditing.

Hi Everyone,
Need some valid pros and cons for Value Momentum in regards to (WLB, Work options, HR Policies, Onsite opportunity etc)

Welcome Agile practitioners!

A patient of mine essentially asked me to fraudulently bill his insurance the other day. My response was records can be audited at anytime which could result in my license being put at risk. He asked me how many times has that happened? I was like that doesn’t matter. I spent way too much time, money and effort to get to where I am.

like

Hi im looking for referrals in Deloitte Canada. Can any one help, would be happy to arrange a coffee chat to walk you through my experience and resume

like

Secret sports annoyance / confession : I think it’s so arrogant that it’s called the “world” series. At best it’s the “North American” championship based on the teams/countries represented in the MLB 🙄

likesmart

Hello! I was laid off from Better Mortgage on March 8th, 2022. I have a compliance background with one other organization. My role at Better was a End to End Mortgage Coordinator. This role focused on compliance and mortgage management. I'm searching for a compliance analyst or officer role in financial banking. Any leads or referrals will be greatly appreciated. TIA! At this time I am #opentowork

like

Hi Fishes, I've 5.7 YOE in digital marketing and i have an offer from PS for Senior Media Analyst Role in Digital Marketing Domain. After seeing all the layoff post i'm getting scared. It would be helpful if you could please let me know if anyone if fired from Digital Marketing Domain.

DOJ is Oct 31st, i dont have more time. Please comment if you know anyone from Digital Marketing.

Additional Posts in Excel Genius

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Anyone know what these badges are?

Post Photo
likefunny

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

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Would anyone be willing to teach me vlookup?

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