Why don't recent grads know how to use excel?

likehelpfulfunny
Posting as :
works at
You are currently posting as works at
Highlighted IconHIGHLIGHTED

There are extremes. While some struggle with excel and PowerPoint, others (liberal arts, and business) can code in C#, Python, SQL, Solidity, and leverage PowerBI effectively.

Over the years, after being frustrated of teaching basics, I find myself building training decks across various disciplines I consider 101. Helps me articulate and consistently deliver minimum quality training to bring up my analysts / associates.

Yet if a certain skill is critical, run that as part of your interview process. Had various surprises when I baked such items into a structured interview, an engineer had more appreciation of bank capital than many of my full time junior staff, a history major understood the nuance of correlated risk through reading “too-big-to-fail”.

like

I thought that I was a try hard for keeping a running list of excel short cuts / formula explanations etc to share with my junior analysts

You sound dope af 😂 manager goals

Liberal arts college grad here - the only reason I was semi proficient at excel out of undergrad is because I was a TA and had to help the professor track class grades.
Context is key. A class on how to use excel isn't worth as much as having to figure out how to use excel to make your life easier for actual work.

like
Recent IconRecent

I agree with Strategic Business Manager 1!!! I get stuck on the basics of rows and columns so I never get to building 😒 Not all instructors teach Excel the same. I've learned more from coworkers than in an actual classroom. I don't use it in my daily job, but I'm starting a cleaning business and it would be nice to be able to track my clients and staff. Or! There's an app for that! Clueless. Michele (Ohio)

like

I asked for direction on excel from a professor once and he looked at me like an alien. Got some from another but mostly self taught in my own time.

If a student gets their hand on some meaningful info and applies it in context they normally pick it up rapidly. Met a guy who had about twenty years on me in Banking and he was much better at excel but he sucked at maths, he won't mind me saying, so it was an exchange when we worked together.

like

Right?!? I get why they maybe don’t know PowerPoint but to it know what a cell is?!!

As somebody who has a background in science, who shifted to finance, i would agree that there are many classes where they just aren’t taught. They are given some simple
Models or charting to do. And they often times rather do something simply than use the full capabilities.

Some of the biggest gaps I see is the use of the logic aspect of functions. I’ve been working in marketing for the past 2 years in my company and god forbid you just don’t use a worksheet to do some modeling

like

My 3 know how. Want fight?

They had to have learned it at some point in college. They just need to see how it’s applied and in a way that makes sense. Once you open the their minds, all sorts of nonsense comes out but it gets them to remember their classes.

I assure you I did not learn it in college. I do know someone who went to Towson who told me they offered an excel certification class for one credit

Our business school drilled that **** into our heads

When I was in school (which, tbh, was 10 years ago now lmao), most of these classes were elective. We did have 1 info systems class that had a basic excel assignment, but 1) at the time, I had no idea of the significance and that wasn't really emphasized and 2) I'm pretty sure most people did the bare minimum and gleaned the rest from the TA.

So I definitely learned most of what I know now on the job. I also have created informal courses for others (even created a formal course but that was years ago and it's probably not the best.)

I'd love to learn more advanced stuff, but now I've grown old and infirmed. I...I'm ancient now. I'm different. I'm older. I'm peaceful. I'm an old hag. I've given up on learning new tools.

Excel is often regarded as a lesser tool... which is unfortunate because it can be very powerful.

Graduating in what, though? 2013 Applied Mathematics and I never touched Excel a single time.

I graduated undergrad 3 years ago with a management info systems degree and the tech classes I took were excel, MySQL, Salesforce, Java, HTML, and CSS. The few programming classes I took were all Java which seemed kind of backwards given the rising popularity in python.

Had like a 5week course on it in my Accounting classes but honestly it’s so hard actually applying it because you’re not using it everyday. You’re only exposed to what it can do. Can’t really truly learn it unless you’re using it everyday.

How big is your recent grad sample for you to make this statement?

Perhaps they haven’t had an personal or professional application to use it.

Related Posts

What’s the best grocery delivery service in the city? TIA

like

I’m a newly barred attorney in Atlanta, Ga and I need two things: (1) a mentor who has time to be a mentor; and (2) a job opportunity. I am open to being a staff attorney or junior associate. CAN YALL HELP ME PLEASE?!?

like

Which companies are giving permanent wfh apart from epam, luxoft, to the new?

like

Found a bed bug in a Radisson Red in Campinas Brazil, how many points?

like

Do female and male journalists/reporters make the same amount of money as each other, or is there a pay divide?

like

Interviewing client side for the first time, what are some good questions to ask that one might not think about at an agency?

like

How much raise do you look for when exiting PA in Canada? Looks like 20%-50% is what people get in US

Any CLT,NC businesses looking to hire for a Junior level Full stack developer / Junior Front-End Developer/ Technology Associate /Systems Engineer entry level / IT Support Engineer??

like

Taking my first project with travel. A bit concerned about maintaining a healthy lifestyle while traveling M-Th for 3 months. Has anyone found a way to keep a good routine for staying in a gym/running and keeping a good diet while on the road?

Thanks in advance

like

Is anyone currently in FAAS Digital Analytics practice that can share some insights of what your work experience has been like? Really interested in learning more and potentially pursuing this. Thanks!

like

Please give some reactions to this post to help me enable my DM.

like

How is Deloitte Risk advisory cyber risk( tprm) in terms of career growth.. What kind of job it is is it technical, or business analyst, risk analyst kind of job. I am a person with 1.5 yrs of experience so less knowledge in this matters. Is it something I can make a career in it. Deloitte

like

When Office is opening in Ericsson
I hv got a offer from there
Please tell

like

I never doubted myself, but I doubted you
I'm tired of looking at myself in my rear view

uplifting

What is the typical first level of “off grid” salary (ie 2022 base salary for class of 2013)? Asking for NY, M&A, AmLaw100 market.

like

Looking for suggestions on qualifications I should pursue.

I'm a Junior Project Manager, pivoting myself into the consulting industry. I have a Business Analysis Foundation certificate and considering pursuing Prince 2 Foundation and Practitioner.

Is Prince 2 worth it for my long term goals? And how valuable is it? Is there other qualifications worth pursuing e.g. Prince 2 Agile?

TIA

like

We just did Embark and her breed results indicate that she’s 100% majestic floof

Post Photo
likefunny

Dad got laid off. Drinking got worse. Attempted assault on sis and mom. Had to put up in hotel. No clue on next steps (legal and personal). Project is complete shit show and SM is not getting it. Idk man...

like

Who knows the email for the creative recruiter at Mother?

like

Additional Posts in Excel Genius

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

What is the best online tool to pick up VBA?

likesmart

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

like

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

Need help with a formula. I’m downloading bank statements to excel and I’m trying to do a lookup so it fills in the category based on the bank description. The problem is I’m trying to use the entire bank description as my lookup value, but the table array I’m searching only has the first part of the descriptions (because the last parts are all different bank ref numbers). How can I do this?

like

Today I encountered the strangest bug I have ever seen with Excel+Thinkcell. I have, as always, a separate Thinkcell sheet where I gather and structure the data (from other sheets) I want to make charts of. However, when linking this data to charts, all formulas in the sheet turns into values. This has never happened before. Anyone else seen this and knows what is going on?

like

How do you fix microsoft excel cannot paste data error?

like

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

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

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

How long did it take you to become good at excel? Like fast?

like

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

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

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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