What specific resources do you recommend to learn pivot tables well? Any specific YouTube videos, or anything else?

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

I learned mostly through randomly googling my questions on what I want to achieve in pivot and going through whatever it spills out. Right now you can even use chat gpt

like

The school of Google has provided many a lesson for myself, as well. Lol

like

They are relatively simple. The way to learn are to run through use cases or actual work tasks. YouTube’s a great spot for very specific functions. But i only find myself using pivots for singular tasks or reports. All others, I build / leverage PowerBI, or Tableau.

like

Following. I’m a formula queen but haven’t learned functional pivot tables and would like to!

like

I learned by practicing. Start with one in a new sheet and play around with it.

Also - as you look into the actual process of creating a pivot table (which is quite literally selecting your data; and push the button to create the table): you’ll find that you’ll want the data to calculate a certain way; de-duplicate a certain way; graph a certain way, etc. those are the right questions to be asking … but the broad question of how to learn pivots is too broad to give a good answer.

You’ll need to determine its usage - and run into a problem you can’t solve to learn how to effectively use them.

It’s like reading a book on how to operate a car … but there are different needs … are you operating a rental car company, a trucking company, a door dash service, or just need to go from point A to point B. All take a car … but usage is just as important.

Just a thought…I’ve always found it easier and faster to make my own “pivot tables” with various formulas. This tends to be more versatile both in calculations and formatting. It also doesn’t require any specialized knowledge to use or maintain.

Related Posts

I am an Indian CPA and pursuing my level 2 Cfa. I have worked with family office and Swf and have relocated to Vancouver. Any tips on where to begin my job search

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

like

What are some good books that helped you with consulting? Looking for some good reads.

like

At what point are you too specialized to lateral to internal audit? (PA, consulting, or industry roles) Currently have 2 years of external audit experience and 2 years of forensics: I always thought of internal audit as a decent exit but I’m beginning to get worried about getting too specialized to make that move one day

like

Any one ever worked at Clean Energy Counsel LLP? Have any insights on the firm, career advancement there, business development, etc. Thanks!

like

Looking to return to singapore from the us. Spent the last 10 years consulting in the us - 4 with ibm and 6 with slalom. Any tips on which firms to target or avoid, based on prospects and culture?

like

Hi there! I work for a tech start-up and I've been tasked with revisiting their compensation philosophy and propose a better structure. I think this will also require me to revisit job titles, existing talent and tenure, performance, career paths, and the organizational structure. Any useful tips as I tackle this big undertaking?

likehelpful

Hello! I am a recent graduate of a medical billing and coding program and I’ m finding it really difficult to get a job because most employers are looking for someone with at least 3 years experience. How do I get my foot in the door with no real time experience?

like

How's the job market lately? I'm considering quitting, moving there, then starting my search. Do you think it'd take more than a few months (say, 6 max) to land a good role?

Hi All, i have a total of 7.6 years of experience and i want to move to IT backround. Can someone suggest me any IT course which will help me to switch without BE.

like

Looking for some material for a crash course in IT strategy consulting - books article etc. any recommendations would be appreciated

like

Any recommendations for next steps or areas to grow for a partner success manager? Recommendations on industries to look at?

like

Top 10 books to read about consulting life ?

likefunny

Which company is better for tech management role - J&J or Amgen ? Looking for comments around WLB, internal growth, compensation etc.

like

What are the paths to VC (particularly healthcare centered VC's) from Management Consulting at PwC?

like

New to the US. Currently based in SF, CA. What is the most efficient and cheapest way to gain more CPA credits? Require 30 more credits.

like

Hi Fishies,

Which to join among these ?

Synechron or
Coforge.

Both are offering same CTC.

Any idea about job security in these organisation.

Synechron Inc. Coforge Coforge ltd

@

like

I received my PR and want to start looking for jobs in Canada. Don’t want to transition to current company’s Canadian office as I have burnt bridges here. US Mid tier MBA + 2 years in Consulting contd

like

Where in Healthcare Consulting can a registered nurse succeed? I read about healthcare consulting companies and the services they offer and they appear heavy IT/comp-sci based. What are healthcare consulting specialties where an RN can leverage their clinical background?

like

Things are apparently going to get better after a client will be leaving, I’ll get to work on different brands but I am feeling pretty burnt out from the agency I’m at. Will new clients help? Or should I look elsewhere. Been at the agency almost 3 years, I feel like I need to switch things up for my sanity.

like

More Posts

Hi guys, hcl offered me E3 band , consultant position for its GCP practice. How’s is the project ? Any idea ? My joining is next week.

Sydney, Australia Hiring team!? Please let me know.

Post Photo
like

Heya guys, actively looking for a senior/staff optical engineering position if anyone knows of anything let me know 😬

like

Jr–mid copywriter openings in NYC?

like

How long after interviewing for a lateral position would you expect to hear back?

like

What do you bring to a bridal shower? First one this weekend as a guest. Bride doesn't have registry, okay with cash gift. How much do you usually give?

like

Hi Fishes,

I've got offer from Dunnhumby, Fractal and Gartner for the role of Data engineer. Which one should I go for?

Tech Stack - Python, PySpark, Azure Data Factory and Synapse analytics.
YOE - 2.2
Gartner - 16LPA
Dunnhumby - 15 fixed + 1.5 Joining bonus+ 10% variable
Fractal - 13.5 LPA

likehelpful
like

Hey folks - 1 BR sublet opp in the UWS. Fully furnished in newly renovated unit. I live solo.

Asking $2200/month (well below actual rent).

DM me for details. Have a great July 4th holiday!

like

Hi friends,

I got offer from a product based firm which offered me 24+2(variable) and joining date is on Monday. They have even sent me the laptop and welcome kit. But today I got one more offer from capgemini offering 30lpa. What should I do?

like

Hi Fishes, can anyone explain the job of Senior Knowledge Analyst at the Boston Consulting Group?

like

Feeling like it's only a matter of time before I have to tell the new marketing dept head that the snazzy jargon just makes him sound like a tryhard and alienates our customer base

like

Best ski shop in Denver? Moved here this summer and I'm heading to Vail in the new year and need to pick up new boots and a few other things. Any favorites?

like

Anyone heard of Ravencoin?

like

Any VP corp bank jobs out there?

like

Books or websites to learn more about social media strategy, community management, and smart decision making for social?

like

Do you prefer a 4 day work week or 5 day work week? And why do you prefer it?

like

Help: good place to take a call in midtown near Bryant Park area? Left office keys at home, and am already on my way there 😰

like

Anyone know of adult recreational soccer leagues in San Diego? Any informal pickup leagues should work too. Would prefer something in La Jolla/north county but willing to drive to downtown!

Additional Posts in Excel Genius

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

Anyone know what these badges are?

Post Photo
likefunny

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

like

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

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

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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?

Still don't have xlookup. #fomo

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

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

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

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!

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

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

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

likehelpful

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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

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

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