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

What’s the best product company in US to go into if looking to exit from consulting? Anyone with similar experience that they would like to share ?

like

What are some good professional goals to set in your first five years of practice? For context, commercial lit associate at boutique firm, so lots of opportunity for hands on experience. Just want some ideas of what I should be thinking about and aiming for. Thanks!

like

Dear legal recruiters who used to work as attorneys: are you glad you made the switch? I think recruiting could be fun but I know how much I ignore recruiter emails daily so it makes me think it’s touch to place people and make a consistent income. Thoughts?

like

I don't know if this is a recent change but I’m seeing postings for junior copywriter/community manager roles. Have these roles always been attached or posted at a junior level? Is this merged role worth considering as someone young in the industry with more traditional intern and freelance copy experience.

like

Hi! If anyone has experience going from Transaction advisory Services to IB please DM me.

like

Ex healthcare workers in Tech/Sales Engineering/ Healthcare consulting;
I have my masters in nursing/FNP (1 yr) making <K70 (Indiana) due to low patient census in my role. No desire for a different FNP job nor to return to bedside nursing (RN 5 yrs). I have heard of some individuals with remote positions making >K100 with little to no experience in tech or consulting after doing a boot camp or cert?
If you pivoted; What’s your current role/ Income & what did you do to complete the transition?

like

Need help, I have relevant experience and good reputation among team. I want promotion in this cycle to manager level but the thing is the seniors I have, managers and senior managers are with PwC SDC for long time, so they are not ready to promote me with 4.5 years of experience. Can you please guide me on how can make it work?

like

Recent PhD in life science looking to get into biotech VC. Can’t find much information on applying for these roles. I’ve heard that it’s not uncommon to go in without business/finance experience, but is it actually rare?

like

Anyone ever move from an internal role to one with external clients? I manage a learning function for a line of business and pondering the next move: industry, startup, consulting...

Hi 🐟 s,

is there a way for tech consultants to become partner ? i am sure there would be but what would be the fastest ? is the bowl reckon quick shifts or sticking to the way on top .
love to know if there are any experiences .

like

Anyone in the PEPI group willing to provide a referral and a chat? Currently an M2 with 8YOE in Operations and manufacturing. Trying to determine whether I’m better off going for Mgr or Director.

like

I am from Digital Marketing field and planning to switch to data analyst. Any help in this?

like

What exit ops are there outside of testing controls all day? Getting tired of this. Resume is ready

likefunny

I studied finance in undergrad and had a couple of internal audit internships. I only started a few month ago but I never saw myself doing IT Audit and I don’t like it thus far! Would I need to get a CPA in order to move into audit or something more finance/accounting oriented like FDD, Valuation, etc.? (Still need to get to 150, thinking of doing an online MAcc)

like

If money was not a criteria, what job would you do?

like

I’m a pharmacist and currently doing an MBA. I have only 2 YOE as a pharmacist and I’m trying to find a career path that will suit me. I completely regret choosing pharmacy and I want to reorient myself. Any advices as where to start applying? ( FYI I particularly enjoyed finance during the master)

like

Getting ready to study for the CAMS exam. Do I need anything extra besides just studying the study guide and practice exam over and over. I’ve read online about people using AML assassin; is it worth it?

like

So... I have questions for change/org effectiveness practitioners who have successfully leveraged their experiences to acquire high paying, high level roles in industry. How did you do it? What was your path? What would you recommend to others so they can make the most of their careers? I’ve included my reasoning for this Q, below!

like

Just got promoted to ACD. Will be taking on more leadership roles. Any books, workshops, resources that helped you learn leadership skills?

likeuplifting

A good friend of mine graduated from Parsons this past summer, has degrees in Journalism and French, is a talented photographer and designer (which I feel I have a pretty decent eye for after working at a design-driven branding agency for half a decade). And I’m certain she’d make a fabulous junior AD or content strategist. Unfortunately she, like many in this pandemic, is still without a job. Any advice for her and/or shops/hiring managers/non-traditional job hunt tips to steer her towards?

like

More Posts

After my RL meeting I knew it was time to go back to grinding Leetcode even harder

likesmart

Whats PDP-GrowthINV ?

like

Hi,

I am looking for a career transition from a civil engineering( work ex. 3+ ) to Business and data analytics, can anyone advise me with dos & don'ts.

like

Please tell me what is the maximum Standard Chartered GBS can offer for 5 YOE in Band 07 role. I need to take a call on this by end of the week.
Anyone knows what is Band 7( Assistant Manager/ Manager)?

like
like

Tax SM’s at RSM - what is your salary for a medium-high COL for 2-3 years of tenure?

like

Hello fishes/sharks, what is the average hike conidering an average performance, and what is the tentative promotion cycle for band 30 BA

Answers need not be accurate, tentative works

like

What value do TPMs provide? In my company all they seem to do is tell other people to work on things they’re already working on, and incessantly nag people on slack for status updates and timelines which you’ve already provided.

like

Has anyone ever been "let go of"? Either laid off or fired. How did you get through it?

like

Hey, has anyone done the GW Boot Camps, especially Data Analytics Program? Appreciate any good insight on their programs.

like

Moving across the country to LA. Any pro tips in the relocation process to make the experience less of a hassle? Just me and my dog making the move.

like

Data Scientists: What were the skills you were interviewed on and what are the skills that you use in your day to day job? Let’s create a thread.

like

HCL Technologies vs FIS Global which should i join? YOE is 11+ as BA. HCL is offering 3 lakhs more than FIS. Please help to choose

like

Are we getting paid tomorrow since it’s a holiday weekend? I believe Juneteenth weekend we got paid on a Friday even though pay day was Tuesday

like

Hi guys, Yoe 12 yrs banking domain Present ctc 14.5 lpa infy and serving notice period.

How much can be negotiated in for global logic ( hr round pending)

Already holding offer 23lpa in wipro TIA GlobalLogic

What’s something you learned about engineering only after you got your first job in the industry?

likeuplifting

Does Labs India match offer(Software Engineering). Already working in labs since a year. Got 2 diff offer's from faang's.

like

Hi fishes! Can anyone suggest some good places to discover in the Yemlur office? Most of my teammates are in other cities so there's no one here to show me around.

Additional Posts in Excel Genius

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

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 can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
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

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

like

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

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Would anyone be willing to teach me vlookup?

like

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

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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

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

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