How long did it take everyone here to learn excel? Also, what's the best way to truly learn how to properly use all of the functions?

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

You need to learn to use ALL the functions, just learn the ones you need to get your job done at first.

like

Sorry, meant to type “you DON’T need to learn to use all the functions…”

You cannot learn everything in excel. Learn what you need at the moment, continue on a rolling basis

like

It is less about learning and more about application. You can learn about the "find" or "search" function, but without a need, it doesn't really help. The question everyone should ask is - how can I make this task easier.

like

Been learning it for 35 years. I use maybe 20% of today’s functionality.

It’s like learning how to speak English. Some words we will just never know or use in our lifetime.

Learn the keyboard shortcuts to reduce switching between keyboard and mouse.

Learn the essential functions used in your role.

Practice good basics: save a copy of the original data, work in a duplicate; clean and tidy your data, keep a record of your data transformations; use helper columns, value transparency over cleverness.

I’ve been learning Excel for 30+ years. I learn new features as I need them. Google and YouTube are my friend. When I get a little break in pace at work I try to grab a LinkedIn Learning course. I keep an Excel Tips & Tricks workbook of stuff I picked up in a class and want to remember later.

Related Posts

Hi Accenture people, got offer today, asked HR about project, she mentioned it will be mapped on first day itself and will be connected with project manager. I told her i need details about the project and she said she will talk to project manager and get back to me tommorrow. Everyone says we have to search project after joining only. So any idea if this scenario can happen? Anyone got to know project details before joining? Please share ur views.

like

Manufactruing process improvements tips - for interview prep what all points one should say ?

like

Without asking or confirming, account lead booked an in-person client meeting that requires travel. Who books ~any~ major client meeting without first checking with the team ?

like

Hi frds,

Any openings for automation tester in Chennai. I will be released from my project this month and will be transferred to Chennai. Please help

like

BCG vs Deloitte. Could you comment on the work life balance differences between the two in toronto / Canada.

When did my LinkedIn feed become the sole property of Cindy Gallop?

like

Your child asks you if they should become a nurse. What do you say?

like

Can we create a post for nurse wages in central Fl, with less than 1 year experience. I’m trying to see something

like

Anyone here who is a CA?

How Is Lowe's India for a fresher?

like

I'm searching for job opportunities in Canada anywhere in pharmaceutical or biotechnology company from last 4 months but did not hear back much. I have used linked in, indeed and tried to find my connections as well.

I have 10 years of experience in Serum institute of India ltd in quality control department. I have studied Master's in pharmacy.

What should I do please suggest.
I have applied for so many jobs with new resume everytime as trained by employment agency. most of company required

like

How long does it take to hear back after your final interview for an in house counsel role? I did the final round of interviews for a Bay Area company last Monday and still haven't heard anything. No rejection yet, but the longer I hear nothing, the more I worry they're not confident I'm the right fit.

like

I got offered a position as a Wealth Management Banking Specialist and was offered $75,000 base pay with a 5% increase after a year. I am working on 8 years experience in the industry, investment licenses, and a bachelor’s degree in financial planning. I feel like this is low. Any thoughts?

likehelpful
like

How to make a jump to cloud security when I just have SOC experience? Currently studying for Solutions Architect cert

like

Which is the advanced mobile apart from iPhone?

like

Ek hi KGS ka bowl bnao, else discussions will get distributed..we have at least 3 bowls for KGS

like

Additional Posts in Excel Genius

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.

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

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

Still don't have xlookup. #fomo

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

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

Post Photo
likehelpful

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

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!

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 compare two sheets to make sure they are identical?

like

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

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

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

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