Best free resources for learning the ins and outs of Excel?

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

Miss.excel on IG teaches a lot of usability, shortcuts, special features. Also YouTube, or free classes on LinkedIn Learning.

like

The most useful learning I’ve done is when I knew excel did something and really needed it. Then I leaned it and used it over and over so it stuck.

I agree YouTube and maybe some trial and error. I can try to answer as well

like

^ this all the stuff that’s really stuck w me has been learning on the fly to get a task done

like

Anything specific you want to learn? Financial modeling or just formulas and shortcuts?

Related Posts

I was tasked with finding a new Vendor Management System and Inventory Management System. I am curious as to what other people are currently using and the pros and cons that are associated. Any info would be helpful.

like

Why companies asking pan card details for L1 discussion...... Is that fine to share the same....... Do any one can use our pan number to any fraud purpose......?

Post Photo
like

Tempted to buy 1 BTC ..

like

I'm under contract for a new build in progress that won't be done until much later this year. I fully expect interest rates will be higher than what I originally estimated. I may or may not try to lock in a good rate early, but I'm planning on renting it out and this throws a bit if a wrench in my margins. I can take it financially, but wondering, If I absolutely needed to get out of buying it, what recourse do I have? Or could I go ahead, and refinance later (who knows rates at that time...)?

like

Help an elderly person: can anyone tell me a high-profile spot that features a tik tok, IG or twitch person? In other words, an influencer who got what could be called a big break?

(I cant think of any, but then it occurred to me I wouldnt recognize them.)

Thanks in advance, hip people

funnylikeuplifting

Minneapolis golfers? Anyone? Anyone? I realize now is not the best time of year for us, but we can talk about it and do our best to daydream.

likefunny

Makes sense, consulting fundamentally changes businesses internally and advertising fundamentally changes them externally, though syncing those two up will be interesting

like

Huh, the word is unkempt. I've been saying unkept all my life. Oops.

likefunny

I want to sell my house but there seems to be water damage and I’m worried someone will lowball me, what should I do?

like

Polling: Salary, location, years in media

VP/Group Media Director

130, LA, 10

like

40+ / M / NYC / 375

like

For anyone going temp-to-perm or anyone who already has, did you negotiate anything into your temp contract about revisiting the option for perm? ie, say, in 6 months, discuss perm options? Thanks!!

Started a new job search about 2 weeks ago. Of the 14 recruiter screening calls I’ve gone through, all went amazingly well, and I’ve only heard back at all from 4 since the calls. Why?

Anyone going to the security/privacy conference in DC this week?

Things I miss most pre COVID - concerts and festivals 😑

like

"Eaten by people in all countries and harmless, the tomato is a member of nightshade family"

In above sentence, 'eaten' and 'harmless' are adjectives? If yes, then why aren't these parallel According to OG

like

Vintage Dom goes for around $150/bottle typically. So is a 6-liter bottle worth eight grand?

Post Photo

Any leads for a room/1 RK near ZS gurgaon office, have my joining from 5th so need to shift ASAP.
Please help.
TIA

like

How job security in Persistent system?
What is the bench period? .Are projects generally short term or long term.?

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Additional Posts in Excel Genius

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

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

likehelpful

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

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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

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

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Would anyone be willing to teach me vlookup?

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

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

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

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

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

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

like

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

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

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

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

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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?

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