I joined this group to learn how to use excel. I've tried many tutorials but I still can't grasp it.

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

Google/youtube has everything you need. Eventually you’ll master it

like

Invest in yourself and try her. She’s great. Miss-excel.com

smart

Grasp what? There are so many levels to excel. Build your foundation and go up from there! Takes time and effort!

Experience is important.

First identify what you want or need to do. And then break down into smaller parts how to get the data, transform, clean, assure and then output that data into the desired output.

You can google anything you're stuck on and you don't need to have a superslick formula either. Sometimes having 3 or 4 seperate helper columns is just way easier as long as it works.

Use AI, best tool !

Related Posts

Hello all,

Please help me decide to join from these company:

Wipro - 22L fixed + 2L variable ,
Concentrix- 23L Fixed ,
Dxc - 24 L Fixed + 2L variable,

Yoe - 9
Skill- Sql

like

Anyone want to grab a drink?

like

I give the clients gold, but they decide instead, they want me to paint it with sh*t.

likefunny

What is IT Due Dilligence? Is it more IT Audit? Better? Worse?

like

I am a technology trainer for MERN and MEAN stack. My current CTC is 9Lac, should i consider switching.
Am I underpaid or is the CTC justified.? I have 6YOE

like

Own a Sub 41, but getting a Hamilton Khaki Field 42 as an everyday later today! As excited as I was picking up the Sub 😍 Thoughts as an everyday watch? Will post pictures if I pull the trigger!

like

Hey everyone! Does anyone have a list of top companies in the US that are truly diverse and inclusive. I’m disabled poc and a recent grad as of December 2021 and I’m looking to start applying to other jobs as my current company has not been accommodating at all. TIA!

like

Does MS provide any reimbursement for WFH setup ?
If someone does not have a personal laptop/desktop, does MS provide a laptop for WFH ?

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

I can’t handle the networking thing sober.... I’ve been sober 4 years and I still find it incredibly difficult... also a young professional

like

Republicans will be the first to lock their gated communities when climate change gets out of hand.

likefunny

Feeling lost in my career (10 yoe, 9 in consulting). Anyone feel this before and how did you get through it (career coach, books, etc)?

likefunny

God, I miss my nice/peaceful commute home. Listening to a podcast in traffic was one of the highlights of my day

like

Got so comfortable with being on my own that I really think I will die alone.

likeupliftinghelpful
like

30th birthday present watch accessory ideas.

A lot of knowledge on here so asking for some help. It’s my partner’s birthday and I’ve no idea what to buy him. He’s a watch fanatic - Pateks (sports and dress), Audemars (sports and dress), Rolex (sports), Omega (sports).

I’m obviously not buying him a watch for his birthday (in his dreams!) but any idea for some good accessories? He’s already got a PP watch winder, and has bought multiple nice straps for the dress watches. I’m completely lost.

like
likefunny

What is exactly the location? Kharadi or Viman Nagar?

Additional Posts in Excel Genius

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

Would anyone be willing to teach me vlookup?

like

How do you fix microsoft excel cannot paste data error?

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.

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?

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

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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

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

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

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

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

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

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

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

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 are your top Excel ninja tricks? Ones that few people know...

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

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