I'm learning to use Pivot Table. Can anyone point me toward the best and most affordable learning resource?

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

Lol do not purchase anything. Find the first person on YouTube you like and go with that.

like

haha that's funny

Lots of YouTube videos on excel pivot table that are free

like

Yes this

Try Udemy. Some public libraries offer free access to courses on that platform if you can’t find something on YouTube.

like

So you type “=VLOOKUP(X, TABLE, Column, FALSE)”

X: is the cell you want to look for in a table

TABLE: is the table with all the data

Column: is the # of the column you want to obtain

FALSE: means you want an exact match

likehelpful

thanks for explanantion

Check your local library's website; mine offers free access to LinkedIn Learning. They have excellent courses for your needs.

like

Just ask chat gpt bro you can even give it data

like

Partially because of title but more because how properly and politely the question was asked.

like

There tons of LinkedIn learning courses! Some really good ones that are like 4 hours but broken down into sections that make it really nice to practice skills. They include practice sets so you’re meant to follow along

like

Udemy has been my go to learning site

Best resource these days is AI. Gemini or Co-Pilot/ChatGPT will even produce unorthodox solutions to complex requirements.

like

I use AI all day for formulas and complex queries

Related Posts

When are bonuses and promotions getting announced in your company?

like

Does anyone have salary information base for a UX Researcher at Meta?

like

Has anyone else noticed that a hugely disproportionate number of latinx big law attorneys seem to be white / white-passing?

like

Hi everyone HELP! I was lucky enough to receive two job offers, one in SNF/LTC one in oncology outpatient setting. Looking for any tips from people that have worked in either setting or both??
Some background I am coming from a inpatient hospital setting. Thank you!

like

Folks who managed to switch jobs in this economy, how did you get the job? Did a recruiter reach out to you ? Or did you go on sending out applications?

likesmart

What's the differences between working at ServiceNow Global Elite partners like Deloitte, DXC, IBM, KPMG versus Elite partners like GlideFast, Infosys, Cognizant, Thirdera, Crossfuze, Highmetric, etc.? Do you feel being treated like a person at smaller companies (Elite partners) rather than just a number at bigger companies (Global Elite)? Do smaller fishes (Elite) lose more big contracts to big fishes (Global Elite)? I'm considering a change and don't know which companies to choose.

like

Hello! I’m new at PBL learning. Where can I find already prepared lessons? I’d like to use other teachers’ successful lesson plans before I try to create my own.

like

Hello Fishes, I have cleared both Technical and Manager rounds in Infosys. I have total experience of 3 years and relevant experience of 2.9 years in Java Full stack development. Currently holding an offer of 13LPA and ctc is 7.8 LPA.

Please help me regarding how much ctc I can expect/ask from Infy?

Thanks in advance.!

Infosys Tata Consultancy Cognizant

like

What is the notice period in tcs during the 3 months probation period?

like

What is tcs vpn name to connect via cisco anyConnect?

like

Anyone here who works Amazon Web Services ? I’m interested to apply for Logistics-related positions.

like

Hello All,

How is Blackstone Project in Wipro?
Is it good to join Wipro or Capgemini. Both Final Discussion in progress.

Tech Scrum Master + Delivery Manager
Yoe - 10+

like

“This report is like a bikini. What it is showing is interesting; what is beneathbthe cover is crucial.”

likefunnysmart

Call me Smoke on the Water, cuz my Ketostix be that DEEP purple. 😉

likefunny

Hi,

I am looking for a IT Recruiter role/ HR Generalist in MNC.
Experience as IT recruiter - 1.2 yrs
Mba in HR and marketing
NP - 90 days

like

Will getting a low tier rating also affect your career when you are switching companies?

funny

I swear gov Cuomo is really surfacing as an amazing leader during this crisis.

likefunnyupliftingsmarthelpful

For all of the negativity out there I thought it would be nice to see some of the amazing things happening around us: (I’m in the US so that’s where my examples are from.)

likeuplifting

Additional Posts in Excel Genius

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

like

Still don't have xlookup. #fomo

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

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

like

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

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

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

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

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?

Would anyone be willing to teach me vlookup?

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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!

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.

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

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 do you fix microsoft excel cannot paste data error?

like

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

likehelpful

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

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

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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