Learn How To Use Pivot Tables In Numbers By Example

  Рет қаралды 40,554

macmostvideo

macmostvideo

Күн бұрын

Пікірлер: 94
@Savvycyclist
@Savvycyclist 2 жыл бұрын
One of your best ever. I was so glad Apple added pivot tables, I used them a lot in Excel. Seems much easier in Numbers but you really showed how versatile it could be. Thanks!
@adco
@adco 2 жыл бұрын
Gary has totally got a gift for teaching.
@GerardHammond
@GerardHammond 2 жыл бұрын
This was awesome. As a SQL programmer I hated pivot tables because I didn't do them ever. Now I see they are just fancy SQL statements. Thanks for an a terrific video - it all makes sense now. Pivot tables are just GROUP BY SQL
@MyAmericanMorning
@MyAmericanMorning 2 жыл бұрын
Where were you, Gary, and all this great info, 22 years ago when I was still working?
@keliblum6591
@keliblum6591 2 жыл бұрын
Although I’m going to have to watch this a few times at least to really wrap my head around how it works, this is extremely useful. thank you again very much.
@sflick2558
@sflick2558 2 жыл бұрын
Best. Video. Ever! Thanks, Gary!!!
@Kevin.S.McCarter_PhD
@Kevin.S.McCarter_PhD Жыл бұрын
This is exactly what I needed right now!!!
@marke2401
@marke2401 Жыл бұрын
Thank you Gary! I never realized the value of Pivot Tables until now
@Jimgoodwin846
@Jimgoodwin846 2 жыл бұрын
I just discovered your pivot table video…amazing! I have been looking for a way to total my expenses for categories in my number’s monthly spreadsheet. Thanks so much! Another outstanding video…you’re the man!
@davidcking7
@davidcking7 2 жыл бұрын
Terrific explanation, Gary. Thank you. I'm bad with formulae and functions ... so Pivot tables work very well for me. I've been using Excel but wanting to learn how to use Pivot tables in Numbers. Your video did the trick! I have tinkered with opening my Excel Pivot table in Numbers ... without extensive testing, it does seem to port over well. Thank you for another very useful tutorial!
@RufusROFLpunch
@RufusROFLpunch 2 жыл бұрын
Fantastic! Thank you.
@VivianaWilhelm-dj2bb
@VivianaWilhelm-dj2bb 11 ай бұрын
Wowwwww such a great video!! You really helped me complete my survey task for university. Please keep doing more videos. :)
@victrolux
@victrolux 9 ай бұрын
I inherited a Pivot table from a coworker in Excel. I love it… but am too scared to try to invent one from scratch. I find your techniques here in Numbers much more intuitive. So I will begin to explore creating a Pivot table to track my e-bike riding… where I routinely document my rides… miles, climbing, # of battery used, effort level, etc. Would also like to make graphs and charts from it too. Thanks!
@Jimgoodwin846
@Jimgoodwin846 2 жыл бұрын
This is great. Pivot tables is exactly what I needed…only I didn’t know that there was such a thing. Exactly what I need for my monthly spreadsheet so I can total my expenses in each category (food, fuel & etc)and deduct the amounts. Thank you 🙏 very much…great video as usual!
@macbitz
@macbitz 2 жыл бұрын
What a wonderfully concise video. Thank you!
@carolinebarlow4795
@carolinebarlow4795 2 жыл бұрын
Thanks very much, Gary, for this immensely useful tutorial!
@fmckeagney
@fmckeagney 2 жыл бұрын
Great video, Gary. As always.
@Maynardtkrebs
@Maynardtkrebs Жыл бұрын
Nice- Like the charting of the pivot!
@hensonmarksadueste5248
@hensonmarksadueste5248 2 жыл бұрын
Deserves a like! Thanks!
@jimalix6270
@jimalix6270 2 жыл бұрын
Yet another very useful video, Gary! I've used pivot tables before, but I didn't know even half the tricks you showed in this tutorial. Thanks!
@_marlon
@_marlon 11 ай бұрын
This was great! Thank you!
@ftumschk
@ftumschk 2 жыл бұрын
That was incredibly useful and interesting. Thanks!
@ianh2674
@ianh2674 2 жыл бұрын
Really handy video and good functionality
@johnwade7430
@johnwade7430 2 жыл бұрын
Excellent video - thank you
@noliv5832
@noliv5832 2 жыл бұрын
Great video, thanks!
@iyoutome
@iyoutome 2 жыл бұрын
Thanks brother, you are so easy to follow... 🙏❤🌅🌈
@gustavorlore
@gustavorlore 2 ай бұрын
Thank you, great help.
@loisskiathitis8926
@loisskiathitis8926 2 жыл бұрын
A very useful and informative video tutorial today! Thank you, Gary! 👏❤️
@harryspeechly7953
@harryspeechly7953 Жыл бұрын
Thank you!!!
@desertpatient
@desertpatient 2 жыл бұрын
Thanks bunches
@Trackhoe075
@Trackhoe075 2 жыл бұрын
Excellent thanks Gary Hopefully apple will decide at some point to allow highlight colors which really is almost as useful as the pivot tables
@macmost
@macmost 2 жыл бұрын
Highlight colors? Do you mean Conditional Highlighting? That's always been a part of Numbers. kzbin.info/www/bejne/o2a0nHqPq8uMiM0
@MelissaAtwell
@MelissaAtwell 10 ай бұрын
Wow, this is exactly what I was looking for. Thank you, Gary! One question though before I dive into making Pivot Tables: Can you have multiple pivot tables, based on the same database information? Basically, I’m trying to create different “Views” (like AirTable) of the same data. Thanks in advance!
@macmost
@macmost 10 ай бұрын
Sure, but typically you have one and keep making changes to examine the results. Either way though. Try it and see.
@MersedP
@MersedP 2 жыл бұрын
Thank you very much! I was wondering if it is possible to make a table with groceries from different markets. And then showing/sorting easy way per groceries where cheapest is to buy. And yet better when you make a new sheet or table and you fill in the groceries you want, it shows the supermarket with lowest price. So that you can make a shopping list per vendor. Any ideas how to do that! 😀
@macmost
@macmost 2 жыл бұрын
YesMake a table, columns with stores and rows with products, then cells contain the price. Then in an extra column use LOOKUP and MIN to get the name of the store with the lowest price. For example if there are three products (columns B, C, D) then in column E on row 2 you would have LOOKUP(MIN(B3:D3),B3:D3,B$1:D$1)
@giannakopoulosgeorge
@giannakopoulosgeorge 9 күн бұрын
Awesome work. Can you create a pivot table for multiple sheets?
@macmost
@macmost 8 күн бұрын
A pivot table references exactly one table. If you have data spread across tables that is related, you should look into combining that into a single table.
@giannakopoulosgeorge
@giannakopoulosgeorge 8 күн бұрын
@@macmost Thank you.
@OmarFarooq-s3w
@OmarFarooq-s3w Жыл бұрын
Good presentation and now feel comfortable in moving from excel to numbers for Pivot table. How can I change the field name in pivot table. eg: Cost(sum) to Cost or any other preferred name
@macmost
@macmost Жыл бұрын
I don't think you can. You'd need to change the name in the original table.
@pedropuckerstein4670
@pedropuckerstein4670 2 жыл бұрын
Another great video. I've been using numbers pivot tables for some time now as I migrate away from excel. Speaking of which, I really need the horizontal and vertical split supported by excel. Numbers headers provides the horizontal split, but how to do the vertical split ? - Thanks !!
@macmost
@macmost 2 жыл бұрын
Not sure what you mean. Keep working with the Pivot Tables feature and hopefully you'll see how to get what you need.
@pedropuckerstein4670
@pedropuckerstein4670 2 жыл бұрын
@@macmost I confused you, sorry. when you showed curves, I thought of the feature I wish numbers had, that doesn't necessarily relate to pivot tables and that is splitting the table so that rows and columns could be scrolled by leaving the header row(s) and one or more column(s) intact. I now how to split horizontally by assigning one or more top rows as header, but I haven't figure out how to split vertically, by selecting one or more left columns, so that I can scroll across columns and leave the "title column(s)" static. I use these features in excel after creating a pivot table, when the number of ensuing rows and columns exceed the screen size. In excel it is under view and called split.
@pedropuckerstein4670
@pedropuckerstein4670 2 жыл бұрын
Excel of course also has freed top row and separately, but not at the same time, freeze first column. I want the split feature in numbers as the next step in work flow after pivot table
@macmost
@macmost 2 жыл бұрын
@@pedropuckerstein4670 Numbers doesn't have that. Numbers is fundamentally different than Excel as it has multiple tables on sheets. Excel is basically one big table on each tab. So freezing a table would be awkward. But you do have the ability to keep header rows and columns in place as you scroll.
@pedropuckerstein4670
@pedropuckerstein4670 2 жыл бұрын
@@macmost Yes, multiple tables per sheet, but your last few words stimulated me to research freezing of header rows and "header" columns - under the table tab - been searching for this feature for weeks ! Now to figure out how to write "macros" for numbers similar to excel - have you done a video on that ?
@Jimgoodwin846
@Jimgoodwin846 2 жыл бұрын
Oops I see I already commented once before😳
@florianliefers3593
@florianliefers3593 Жыл бұрын
Thanks for the very useful video. I often find it very difficult to create sample data. Did you setup your data by yourself or do you get this from an open source?
@macmost
@macmost Жыл бұрын
Some open source, but it was too long ago for me to remember. Sometimes I use random numbers: kzbin.info/www/bejne/oHe9lp9-mNhnaJo
@carlodeluca
@carlodeluca 6 ай бұрын
Gary, your videos are always so helpful. Thank You! I have 2 questions: 1- Can we sumarize a bunch of sheets like excel? 2- If have a formula to sum lines 1, 2 and 3 how can I ad a line 4 and the results include this new line? (I can't use the formula to sum the entire column, because I have another data on line 10, 11 and 12).
@macmost
@macmost 6 ай бұрын
No, to summarize multiple tables you would first build the table that contains the data you want, presumably by calling on data in the original tables, and summarize that one table. I'm not sure what you are asking in the second question, but if you have rows in your table that are not data rows, then make them header or footer rows to be excluded from things like sums.
@carlodeluca
@carlodeluca 6 ай бұрын
@@macmost For exemple: 1st line = 10.00 2nd line = 20.00 3rd line = 20.00 4th line TOTAL ONE = 50 (sum formula) If I add a line between 3rd and 4th the total doesn’t update.
@macmost
@macmost 5 ай бұрын
@@carlodeluca But what you your sum formula, exactly? If this is column C, and there is a header row C1, and the values are C2-C4 with the sum formula in C5, is the formula SUM(C) or SUM(C2:C4)? Use the first one.
@carlodeluca
@carlodeluca 5 ай бұрын
@@macmost the problem is: I have line 6, 7, 8 and a sum. Than I have 11, 12, 13 another sum. How can I have 3 subtotals that update when I insert adicional line at the botton of each one? Sorry for my english.
@macmost
@macmost 5 ай бұрын
@@carlodeluca Try to keep your tables where the regular rows represent "records" in a database, and the footers or other tables are where you do calculations. It sounds like you are trying to cram more than one data set into a table. Use multiple tables or come up with another design for what you are trying to do. kzbin.info/www/bejne/fXmtZ61paKh1prc
@MrHitthespot
@MrHitthespot Жыл бұрын
I Absolutely loved this video. Can you do a pivot table based on more than one table? I used your video to set up my checkbook register but want to do a table for each month of the year. At the end of the year i would like to do a pivot table based on all 12 tables. Is that possible?
@macmost
@macmost Жыл бұрын
No, you'd need to create a table with the data you want from the 12 other tables first. BTW, I wouldn't do a table for each month. Why? Keep similar data in one table. Just have a single table for all checkbook entries.
@MrHitthespot
@MrHitthespot Жыл бұрын
@@macmost Thanks, that is the way I set it up so i should be good to go. I have been a Mac user for 8 years now, just upgrading from a iMac 2015 to the Mac Mini M2 Pro. Your videos have renewed my interest in new ways to use my computer. Thank you very much for all you do for the Mac community.
@Vlad-wh1pl
@Vlad-wh1pl 2 жыл бұрын
The main inconvenience of pivot table for me is manual update. I hope in the next update they will add automatic update option, so currently I still use formula-based approach.
@macmost
@macmost 2 жыл бұрын
What's the problem with having to click on button to have it update? (Trying to understand your point of view). I mean if the table changes, presumably you have taken many actions to change it, adding values, changing values, etc. So what's wrong with exactly one more click?
@MyVincenzo67
@MyVincenzo67 2 жыл бұрын
Thanks for this interesting video. Would you know how I can change the data source (like Excel allows) ? I can't find anything else than creating a new Pivot Table. I'm trying to use numbers for personal stuff while using Excel for work; however the more I try the more I find limits in Numbers when I need to do "advanced" calculations. Thank you Gary 🙂
@macmost
@macmost 2 жыл бұрын
A pivot table is tied to a regular table. So yes, you would create another pivot table to do something with another table. Or, change the data in the original table.
@יוגבמרכנתימאמןכושראישי
@יוגבמרכנתימאמןכושראישי Жыл бұрын
Hello. Thanks for the videos, they are really good! I have an Excel file and I want to convert it to a numbers file. The file has many complicated functions. can you help me with this Thank you very much
@macmost
@macmost Жыл бұрын
Just open it up in Numbers. That converts it. If it uses something that Excel has that Numbers does not, then you'll need to come up with a new method of doing that.
@יוגבמרכנתימאמןכושראישי
@יוגבמרכנתימאמןכושראישי Жыл бұрын
@@macmost thanks for the reply. Can I email you the file? See what I'm talking about. Because it's not work for me. I don't understand it too much. I am willing to pay if necessary. Thank you.
@macmost
@macmost Жыл бұрын
@@יוגבמרכנתימאמןכושראישי Sorry, I don't do consulting or anything like that
@MS-uz4ix
@MS-uz4ix Жыл бұрын
Is it possible to incorporate data from other sheets in your pivot table?
@macmost
@macmost Жыл бұрын
Yes, as long as you built a single table with that data first then create the pivot table from that single table.
@pperezir
@pperezir Жыл бұрын
Do you know if I can create calculated fields in numbers like in excel? I mean, creating a field that is the calculation of 2 (or more) fields of the pivot table
@macmost
@macmost Жыл бұрын
I'm not familiar with that Excel feature so I'm afraid I can't be of much help.
@d_rose_a
@d_rose_a 2 жыл бұрын
Great stuff . You’ve been such a help. I have a ? I have a sheet with 5 tables on it. Can you create a pivot table for multiple tables to one pivot table. Also when I create a pivot table, it is alphabetizing the original and I have it in a certain order for a reason. Thoughts? Thanks in advance
@macmost
@macmost 2 жыл бұрын
No. Pivot tables draw their data from a single table. Do these tables contain the same type of data records on each row? If so, combine them into one table. Not sure why it is sorting the original table, I've never seen that. Do you have a Sort set up on that table?
@d_rose_a
@d_rose_a 2 жыл бұрын
@macmostvideo ok I will combine the tables. They are inventory tables for my restaurant. I have it set up as product/quantity needed/in stock/order as the 4 columns with formulas I learned from you for simple subtraction. That way anyone can do inventory and shoot it to a pivot table that has just product and order quantity. But for some reason it sorts it on the pivot table which is a pain because I have the list in the order I need.
@germanbrendagomez522
@germanbrendagomez522 7 ай бұрын
Can you create a pivot table that pulls info from multiple files and sheets?
@macmost
@macmost 7 ай бұрын
No. Not sure of your situation, but if your data records are for the same kind of data, they should be in one table.
@sushilverma2634
@sushilverma2634 Жыл бұрын
when i copy and paste data from pivot table than font, text alignment, cell border etc changes what shall I do
@macmost
@macmost Жыл бұрын
Not sure what you are experiencing there. Just change it after, I suppose. Or experiment with different paste options in the Edit menu (like hold down the Option key in the Edit menu).
@alexanderbenedicto9747
@alexanderbenedicto9747 Жыл бұрын
How could I use this on multiple sheets lets say 100 sheets?
@bradclements2003
@bradclements2003 Жыл бұрын
How do you pivot tables across sheets?
@macmost
@macmost Жыл бұрын
Not sure what you mean by "across sheets." By default a pivot table is created on a separate sheet from the source table.
@TheEricBooth
@TheEricBooth 2 жыл бұрын
Welp, time to organize my board game collection.
@mlukahot
@mlukahot 10 ай бұрын
Good video but way too fast starting at the produce store... No time to think, just click, click, click. But useful, just the same. Thanks.
@fredmoore3886
@fredmoore3886 11 ай бұрын
Gary obviously knows his topic, but his lessons move a bit too fast for me. I taught before retiring and I think most students might have trouble following along. LJusdt a thought.
@macmost
@macmost 11 ай бұрын
kzbin.info/www/bejne/opq9hayfrp6BpLc
@LiannaLovelle
@LiannaLovelle 2 ай бұрын
I don’t. Perfect speed for me 😊
@nikhilck629
@nikhilck629 3 ай бұрын
You can do all this without pivot tables. I think pivot tables just complicate the situation.
@LiannaLovelle
@LiannaLovelle 2 ай бұрын
You can… in a way, by sorting a database. But you really can’t get them to group items in this way at all. You’d have to use formulas for adding up values, for example. I’m using it for budgeting reasons, putting info in a database and pivot table to see what I spent each month. Much easier in my opinion. Click a few times and the table is made.
@ozarkamerican41
@ozarkamerican41 2 жыл бұрын
Really a good tutorial. Thanks
@bevintx5440
@bevintx5440 2 жыл бұрын
Thanks for this great video.
Get Creative With Numbers Spreadsheets
17:02
macmostvideo
Рет қаралды 20 М.
Track Your Expenses in Mac Numbers
11:37
macmostvideo
Рет қаралды 82 М.
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 19 МЛН
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 653 М.
Thank you Santa
00:13
Nadir Show
Рет қаралды 59 МЛН
Top 10 Things Users Don’t Know They Can Do On Their Mac
10:05
macmostvideo
Рет қаралды 55 М.
Understanding Sheets and Tables In Mac Numbers
11:44
macmostvideo
Рет қаралды 80 М.
Unleash the Power of Pivot Tables in Google Sheets
10:18
Teacher's Tech
Рет қаралды 26 М.
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Leila Gharani
Рет қаралды 395 М.
12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!
12:12
MyOnlineTrainingHub
Рет қаралды 361 М.
An Introduction To Using Formulas In Mac Numbers
14:50
macmostvideo
Рет қаралды 234 М.
Advanced Excel - Creating Pivot Tables in Excel
13:11
Technology for Teachers and Students
Рет қаралды 2,5 МЛН
20 Useful Tips and Tricks For Mac Numbers
15:10
macmostvideo
Рет қаралды 334 М.
Working With Pivot Tables In Numbers
42:45
macmostvideo
Рет қаралды 47 М.
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 19 МЛН