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

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

Most of those courses are geared towards beginners. Intermediate users should focus on specific skills that they know they lack and you can probably find some videos on youtube for those. Intermediate is a very loose term, though. Just because you can use sum/sumproduct and can build a basic 3 statement model, doesn’t mean you’re an intermediate Excel user. Have you looked into financial modeling world cup to test your skills and learn from the solutions?

like

Agree. What do you do at EY? I feel like we won’t really get to practice advanced or even intermediate evel excel in Audit

Wall Street Prep

Related Posts

Product Sales Manager professional,having 6 years of experience in managing exporters & Importers portfolio (Trade Asset & Forex) in Banking industry and 2years of experience in Capital Market as an Assistant Manager Professional in broking Industry.Looking for better opportunity.

like

What is the difference between Direct Manager and Matrix Manager

like

Looking for a 2bhk in and around Kharadi, for family. Please share if you have any leads.
TIA

like

Is it too late for me to start investing? Feel like with current market, I probably will end up 📉

likefunny

What is a CLE you’d actually be interested in?

like

Any gay 🐠 in MSP area wanna get some drinks?

like

Thoughts on switching to fidelity versus Ameritrade?

like

I have a stamped H1B expiring in Sep 2022 (can be extended for 3 more years) and I currently work with Deloitte USI in India with no onsite travel yet (haven't used it even once)

I am switching to a FAANG in India. Can I potentially use the H1B to talk them into transfering me to US offices in the future? (Not now)

like

I got admitted to hospital since I was unwell. How can I apply for cashless medical claims as I downloaded one form from general medical insurance plan. Can someone suggest me

like

Any recommendations for next steps or areas to grow for a partner success manager? Recommendations on industries to look at?

like

Does anyone know of any remote positions for reinsurance accounting?

like

Do I REALLY have to keep doing self assessments for the rest of my life, so that I can wait two months because of additional reviewers...so that finally hear if my assessment of myself was correct? Because I really don’t care about what I think. I just want to know if I’m either going to get promoted, my boss thinks I’m a rockstar and I’m on track to get promoted in a decent amount of time (even though NOBODY can answer that because they’re afraid of a lawsuit), or if I’m getting fired ASAP.

like

3 year experience. NYC, 55K, am I under paid?

like

How many people agree that China held back their numbers and do you think that could start a war?

like

Has anyone taken tennis lessons and have recommendations? Played for 4 years before so not a beginner, except I also haven't played for ~5 years since.

like

How much can I expect for 6+ yoe working in QA and currently leading a QA team of 5 for 2.5 years.

Current CTC is 13L pa.

like

Looking into lordstown motors today, and it looks like the truck might happen after all, with deliveries starting by the end of this year. How crazy is that?

like

Career site development looking into Attrax, recently acquired by smart recruiters which we just implemented.

Any thoughts on formal career site vs. out of the box career page that's kind of basic?

Additional Posts in Excel Genius

I wonder if there is a quick guide for excel ??

like

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

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

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

How can I make these dates sortable with a filter?

Post Photo
like

What are the most typical models you all build

likehelpful

Anyone have recommendations for good hands on courses to increase proficiency in excel? I want to learn how to do vlookups better and use if/then statements and manipulate large sets of data to create dashboards. I know YouTube but I’m asking for courses that I could put down for development as part of my performance review.

like

Does anyone know if it’s possible to return multiple values using a vlookup or index match for duplicate values?

What are your favorite excel macros to make you more efficient at work?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

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

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