I am trying how to learn how to use excel, what are some material or resources that helped you learn the software?

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

Exceljet is very helpful. It walks you through step by step on new functions and gives you sample data to play around with

like

Use GenAI/chatgpt to write formulas and answer questions.

like

There's a subreddit on Reddit where people talk about specific Excel problems. You can learn a lot by lurking there, essentially picking up pointers from other people's questions and answers.

like

Try and recreate your paycheck statement in excel. That will show you how tough do math and organize your information.

like

To do math*

YouTube tutorials

likesmart

LinkedIn learning, which is free through some libraries and workplaces

like

YouTube

like

YouTube and ChatGPT. You can learn almost anything with these two tools.

like

Accented men on YouTube and stackoverflow

like

Thank you everyone for the suggestions!

Couple thoughts come to mind. First Coursera offers several, some free, some cost. The other option is open up help f1 and start looking at the topics, those you're familiar with skip and those your not look into the help content.

The only thing I would suggest is paying attention to the version your using, not all are the same. Make sure your learning is related to your version.

In my opinion I would advise anyone wanting to expand there Excel knowledge to understand that a large % of what is done in Excel should not be. I would recommend exploring Microsoft Access, or Database fundamentals.

Related Posts

My dad technically left big law after a month of it in 1968. He went on to have an amazing career in both law and politics. Has even been deemed important enough to have his own Wikipedia. Sky’s the limit!

like

Any suggestions for good training courses for tech recruitment?

like

Hi,

I joined mphasis a few days back. Now I have a better job opportunity (HCL) with 20% more. Can I exit in 20 days from mphasis with prior information or should I abscond, if i abscond what are the consequences

I'm looking to leave the legal field. Its really toxic for my ADHD and I feel miserable everyday here. How can I pivot my career towards government/policy roles without having to take a huge step down in income?

like

How do I go from SDR/BDR to being a Sales Engineer?

like

I have been in Recruiting and HR for 11 years and thinking about making a career move. Ild love to hear from anyone that’s made a career move from HR to a different role.

I have FAR and REG left for CPA. Not sure I really want to stay in Big 4. Want to move to Corporate Finance, FPA, or IB. Thinking of just pausing CPA and studying for GMAT. Never given time to study f

like

Looking to finally go get my SPHR having the PHR for the past 6 years. Still value and pursuing and obtaining?

like

I have an interview coming up for internal audit manager. Currently in external audit. When asked about my experience in ERM - what would you say Is transferable skills that I can leverage in my answer?

like
like

Please help! I’m a CRC who manages Investigator- led clinical research projects and I want to transition to a PM role in industry (I would slightly prefer not a PM role in clinical trials since I don’t have clinical trial experience.) I’ve applied to PM roles at many biotech companies (e.g. Charles River, ICON, Paraxel) but only got 1 interview which didn’t work out. Which companies should I look to for an entry level PM role? Any good startups to consider? Anyone have any insight or advice?

Any advice for moving from being a lawyer to secondary advisory or private fund groups that combine this with placement/fundraising?

like

What’s the shortest amount of time it’s respectable to be in a job before leaving?

like

My I-140 has been submitted and I have an exciting job opportunity back at home which I will accept and can join whenever in next 6 months. Does it matter when I quit (pre or post I-140 approval)?

How did you decide what field of law enforcement you wanted to be in?

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

Can anyone help me understand what c9 grade means in NatWest job grade? what are next two grades after c9?

like

I’m thinking about transitioning to In-House from a big law firm where I practice Employee Benefits. Will employers consider me without the typical “corporate” or “litigation” experience?

like

Is IB worth the sacrifice of WLB? Obvious pay is really good but are the prestige and pay worth it if you’re planning on only doing it for a couple years?

Currently working at an IRA with great WLB. Honestly I love my job, the firm, and people I work with.

Also doing MBA part time at a T15 school. Thinking about switching to IB but I’ve done my research and I think I would burn out of IB in two years but I might be ok with that for the opportunities after.

like

I want to exit to MBB but if that’s not a possibility what are the next best consulting firms? Looking for at least midsize firms (non-boutiques).

like

More Posts

Are text message breakups acceptable? Better than complete ghosting right

like

What’s everyone doing today babes 🧐

like

How many annual leave days do you get? (I’m in the UK and a company i’m considering offers 25 days off a year)

likefunny
like

Does anyone live in Milieu in west loop? What are your thoughts on living there and are there other good parking options besides there garage? (We have 2 cars and $600/mo. in parking seems too brutal)

like

Hi Fishes,

If anyone is looking to buy Life/Health insurance product please connect, we can avail good deals and discounts.

like

Salary negotiation tips?

like

I'm a pca in TN with around 8 years of experience. I am making 13 a hour. Is that low?

like

Thoughts on the new Chase Freedom Flex?

like

Got an offer fr vmware worried about job security should I join or not as I have heard frequent layoffs happen there specially in india VMwware ,kindly suggest what to do !

like

Hello fishes, I am looking for a part time UI UX role to expand my knowledge on a single product.
Let me know if there are any opportunities available.

like

Hey guys
I'm being offered a new grad product development engineer 2 position in AMD Canada
Can someone help me out with the salary range for this role?
Thanks!

like

Anyone familiar with sobi? Interviewing for a dir role in the US and curious how the company is and the culture is like.

like

60p8o Estate Planning Attorneys bowl code

like

I've been asked to provide a start-up life sciences co. with reccos for D&O insurance. Does anyone have any reccos to share?

like
like

My practice in S&C is transfering to SONG, effective September 1st. What is the likelyhood of getting f* from a compensation standpoint ? Zero chance that I put SONG on linkedin 😩😅

likefunny

Has anyone seen any decent MQD run ideas for Delta recently? I’m about 8k MQDs from diamond. Seems the Aeromexico method is on hold until they are fully back up and running. Thanks!

like

How much time does it take for HPE for offer letter?

I'm applying to minute clinic. An advice for the interview?

like

Additional Posts in Excel Genius

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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!

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

likehelpful

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

like

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.

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

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

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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 created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

Would anyone be willing to teach me vlookup?

like

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

Still don't have xlookup. #fomo

like

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

Post Photo
likehelpful

Anyone know what these badges are?

Post Photo
likefunny

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

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