Hi there,
Which Excel courses you recommend for a beginner?

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

Honestly, courses aren’t the answer. Hard to retain info from watching videos aimlessly. School of hard knocks is the best way to learn, and google google google. Easier to retain when you are faced with a problem and you have a goal in mind, and then that formula (or combination of formulas) will be in your arsenal forever.
Sure, there are classes you can do for basics, but they won’t be any better than simple YouTube videos that teach you basics like SUM, AVERAGE, etc.

likehelpful

School of YouTube with a major in practice and a minor of correcting your mistakes

like

I highly recommend that you check out these brilliant people who have great content on YouTube and LinkedIn; Oz du Soleil, Claire Squibb, Wyn Hopkins, Paula Guilfoyle

Quite a lot is considered more advanced stuff but there is some beginners info there as well.

However, best advice is dive in with actual spreadsheets from your sector. When I first tried to learn pivot tables it didn't sink in at all however when using actual data from my workplace that I understood it was a lightbulb moment.

Google is also your friend.

like

Check out the courses on LinkedIn Learning. They include activity files so you can follow along and practice

like

Check out the “learn excel and get a job” or something similar on YouTube by ExcelIsFun. Great stuff to get caught up.

like

Microsoft offers a bunch- but haven’t personally tried them.

like

Leila's videos on YouTube (and Udemy). i like her soothing voice. the best way to learn is to ask yourself "how can i do this with a formula" and then go figure it out

like

I like the ucolorado one on coursera because one of the courses in the specialization is just practice exercises, which I found very helpful

like

Glad to know that banks are still hiring token liberal arts majors (jk, I was one). Here are some starter tips which may help:
1. Cells are where x is solved for. You will be writing the equation on the right side of x= . f(x), if you will. You can only pull data into a cell, you can’t push it out (experts excepted).
2. Don’t move forward until you learn how to use absolute and relative cell notation - know the difference between using A3, $A3, A$3 and $A$3 in a formula.
3. For your ease in editing & troubleshooting your own work, don’t be embarrassed to write simple and short formulas at first. If you need to choose the larger of the sum of two sets of numbers, write the formula for the first sum in one cell, the second in another cell, and the formula comparing and choosing the largest in a third cell. This will help with your logic, too.
Linked in courses are good, but you will learn best with real problems that you must solve. Sketch out the logic first, if you need.
Many industries and professionals with different needs use Excel, and you should make sure that the class targets your need. Statistical analysis? Database manipulation? Financial forecasting? Calculating the opening balance sheet of two merged firms? Calculating the tax loss carry forward on a VC backed growth company? If you’re involved in calculating debt compliance ratios or workouts, knowledge of how to pull together a 3-statement analysis is fundamental. Some of those classes are expensive, though. To see what I mean by taking the right course, look at all that is offered by www.wallstreetprep.com. I’m not endorsing them, have never taken a class from them. But the list of courses & descriptions should give you a good idea as to what direction you should go with training.

like

Thanks everyone for your inputs. Highly appreciated

I’m probably showing my age by recommending a book instead of a video or class. But “The Excel Bible” was a good one. The same author also wrote a book about Excel and VBA, which was also very helpful in automating some grunt work.

Related Posts

Switched from Tcs as a Java developer to Amdocs Was assigned to Ces delivery unit . I was keen to work on java stack but came to know that there is limited technical learning . I have a offer from Tech Mahindra for Java dev? Kindly suggest or advice.YOE 1.6
Tata Consultancy

like

Hello,

I have done my cyber security certificate CISSP with 9+ yrs exp can anyone tell me how can I move in to that role and how much salary I can expect l.
Thanks in advance !

like

CFA or CAIA?

Could anyone shine some light on how to go from consulting to the investment side of PE?

like

Can anyone share the mapping of Deloitte levels to Proserve levels? I am a Senior Manager at Deloitte and recruiter just called me for a senior advisory consultant role but that feels like 2 levels back at least from a Deloitte perspective.

like

Hi Fishes,
I am an Senior iOS developer. YOE is 8.5. Currently getting 13 LPA. Getting promotion in a month with 25 to 30 percent hike which comes nearly 16.8 LPA. I cannot able to relocate now due to family dependency reasons. I heard iOS developer salary market is good. I am having a very good work life balance in the current company. I am in a confusion. Should I look for opportunities with PWFM or stay in current company? Am I making low pay as per market trends?

like

I recently had an interview with a very promising pre-IPO company in the AI/ML space for a SE leadership position. The interview feedback was better than I expected, but with a twist. They have already given the offer to someone else, but they still want to bring me on board and they asked me what I would like to do. I am in the process of gathering more info, but it is tempting to ask about pivoting into product management. What would you do in this situation?

like

IMO I’ve never seen more pharma jobs open. And I keep seeing so many people in non-pharma looking for new jobs... well, we’ve got them. What’s the disconnect? Why do you think people won’t make the switch?

like

A recent post graduate looking to penetrate tech sales industry. I have 18 months experience of derivatives portfolio management and 16 months experience of customer service with a knack for marketing

I would love if one can guide to work on certifications or affiliate courses or suggest me companies to venture into for an entry level tech sales opportunity .
Location : Vancouver,BC or Remote opportunities in Canada.

like

Hey, a Private Banking analyst with 0.5YOE here and I'm starting to realize it's not the role for me. I'm really interested in FinTech roles, but wondering how I can pivot to Fintech roles that typically require 1+ year of experience in IB, consulting, or SWE? Would love to connect with people in this industry to learn more about their roles!

like

What are the pros and cons of joining a Captive Organization for Salesforce ?

It is true that in service based consultings the learning curve will be better coz we'll get to work on a lot of projects compared to a captive organisation ?

How should one decide? Can someone list out the pros and cons of both. It would be really helpful for a lot of people.

Thanks in Advance!

Hi there, I'm looking into expanding my skillet as a Software Engineer (web dev).

Well, which programming languages or frameworks are on-demand to learn for a high-paying web dev job?

likesmart

Fifth year labor and employment associate at Big4 L&E firm (think Littler) and am considering making a move into big law (think Jones Day, Goodwin, etc.) Any thoughts on if it’s worth it this late in my associate career? Also, do those big firms take 6-8 year L&E laterals?

like

Mulling over an offer to join Industry (Banking) - salary match at VP level (10+YOE) + discretionary bonus (FO role) + better WLB. Not seeing a path to promotion at current firm (rejection for multiple years with no specific/satisfactory reason provided - met delivery + sales KPIs - bad managers/backers). Thoughts?

like

I am looking to change my career from agency to product marketing or management. Are there any tips or anyone I can talk to consider making this transition? Thanks!

like

I’m a tax senior in big 4. Which role in the industry has a better career trajectory in terms of growth and pay: senior accountant or senior tax accountant? I do a lot of tax provision and starting to find tax interesting but I’m not having a lot of luck finding openings for in house tax roles.

like

I’m a financial advisor (Series 7 and 66) and I really wish I would have become an accountant or investment banker. I like advising, but it’s a grind to find people to make new clients to sell to in order to survive. Are there any exit strategies for a successful young 26 y/o advisor to move to investment banking or a salaried advisor job?

like

I have been working in SEA region last 4 years. I feel burned out. I have 10yoe, I have try to move to other country but I pretty much suck in LeetCode. I want to take some time off to unwind, finish some personal business, and really prepare for interviews. I would like to hear from you. Should I quit to my current manager(5th so far) or wait after mid year performance review, when a new boss will take over my team? I'm thinking on giving them 2 months notice period. By contract is 1.

Thanks

like

I’ve been a creative strategist, account manager (both agency) and an ad sales operations manager (television/digital media) and I’m tired of bouncing around. I’m trying to narrow down paths that I can take now, but am at a loss. There are so many ways I could go. Because of my last two roles I have a great interest in creative operations type positions, but I’m not quite sure how actually land the job. Any thoughts?

What kind of roles do you guys recommend for a pharmacist trying to pivot into pharma? Where can you go to see all the different types of roles available? I graduated with my PharmD in 2019 and I did a managed care residency and am now at a healthcare startup so my background is primarily on the health plan/digital health side

like

More Posts

Current: 15L Fix
Loc : Hyderabad (Able to manage and can earn 6-7L extra with freelancing)

Offer in hand
Loc : Chennai
Offer : 20.5 Fix
Variable: 4.2 L
Stock : 3.2 L

YOE : 5 Years

Could you please suggest is it worth moving Chennai with this offer?

like

I am new to United Silver and I purchase economy tickets. Is the best strategy to check in exactly 24 hours ahead and switch my seat to an open economy plus seat?

like

Need advice. This year I am sitting 16 of my final professional exams. I have a dissertation to do. I have my traineeship to finish. Is adderall a good idea?

like

CFP & ChFC looking to change firms. Currently in a bank program, but not a large portable book to bring over to the next firm. Over a decade experience and about to finish up my MBA. Currently nowhere near the income level I want to be. Any suggestions for a good program to go to for my next move?

like

Reliable place to fix scuffed leather shoes? Preferably Chelsea area

I’m sure you don’t get many of us industry peasants here but I’m looking for advice.. I’m 24yo in ERM, doing a M. Statistics, CFA L2 in June, what should I move into if I want to get to MBB in 5y?

like

New joiner. What should I get with my $250 wfh stipend? I already have standing desk, dual monitor, portable monitor, and good headset, not too sure what else I need, but it’s free money. Thanks.

like

So, I'm sure this has been discussed. What would be a cut off for when to leave without necessarily burning bridges? End of October? End of November?

like

How many of you biglaw associates are on your grind trying to recruit people to earn a big referral bonus? I’m treating it like a side gig. Ironic that my firm does not give associates any kind of origination credit. If they took the same philosophy with business development, I would direct my efforts there too.!

likefunny

Fun fact you can turn your iPad into a portable monitor with the app “duet”.. working from bed just got easier!

like

Anyone experienced cognitive symptoms or brain fog associated with Covid?

like

Has anyone tried indoor gardening in NYC? Thinking this could be the best time to do so but not sure where to start.

like

Any tips for the functional interview for Amazon’s Contracts Manager position? Studying the leadership principles but don’t want to overlook the functional portion.

like

Changing my title to Copingwriter

likefunny

How dangerous is crown heights these days?

like

SALARY CHECK - what is the base salary for SIP consultant at ZS London office?

like

Which field in IT will have high demand in future and less competition ?
We know AI ,machine learning ,blockchain but
Looking for something unique which will be in demand future and not most people can do it ?

like

Hi Fishes,

I got offer from legato and Altimatirk. Can you please help me decide which is better wrt to career growth, work life balance and hike perspective.
Skill: java Microservices

Has anyone invested in a franchise? Is it worth the time as a side gig potentially turning into a path for business ownership?

like

Does anyone know if in a dissolution of a 50/50 split-interest LLC goodwill can be attributed solely to one member such that that member gets more than his 50% distribution?

like

Additional Posts in Excel Genius

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

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Would anyone be willing to teach me vlookup?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Any book recommendations on excel modeling for real world business applications?

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!

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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?

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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

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

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

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

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

What are your top Excel ninja tricks? Ones that few people know...

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

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