Building a Basic Business Spreadsheet In Mac Numbers
Жүктеу.....
Пікірлер: 254
@christianb95652 жыл бұрын
I feel like I just took a Master Class. You're flying through things in Numbers that I find an absolute PITA to do with Excel. Thank you for this video
@uptown70852 жыл бұрын
I am a true beginner and honestly I felt as if I needed to know a few things before I watched this, thanks for the lesson I’ll comeback and learn from you after I learn the basic and shake off my frustration.
@flookoco20083 жыл бұрын
You have a relaxed style which is excellent for delivering complex training like this. Thoroughly enjoyed this, thanks Gary.
@tracyamcneal95972 жыл бұрын
I appreciate MacMost for the educational tutoring necessary to help new Mac users like myself.
@joshkidd20753 жыл бұрын
Gary you are so knowledgeable and communicate the features so clearly & easily. I used to use Windows for Mac until I started learning more about Numbers. Your videos helped with that transition.
@GrammyAllen2 жыл бұрын
Wow! This is awesome! I had a bit of a meltdown today because I was so overwhelmed with my bookkeeping. I have dyscalculia and some PTSD over mathy things. I'm going to have to watch this many times. Thanks for this!
@arlynnpaula7795 Жыл бұрын
At 59 and retired I enjoyed your video. Wonderful video. I have been using Excel for years on an old HP with windows 7 😆 and just bought a MacBook Pro 14 so my mind is blown. Took me half a day to watch and take notes then create as you did. I have watched some basics on Mac so I loved the challenge of all the simple things like copy paste etc and when to 2x clicking columns!! Looking forward to watching more of your videos.
@grinchy1689 Жыл бұрын
you are a lifesaver!!! i’ve been searching everywhere for simple software for my small business, but i knew there had to be a way to do this in Numbers, and i created it as i watched your video. ❤Thank You so much.
@1hjehje3 жыл бұрын
I have used Microsoft Office for many years and I was curious to see how feature rich Numbers is when compared to Microsoft Excel. I don't have a Mac as yet, but I think that Numbers will definitely meet all of my needs if I decide to purchase an Apple laptop. Thank you for the excellent video!
@wishiwereasinger3 жыл бұрын
I knew I could do a lot more with spreadsheets than I was doing and this video showed me everything I needed to simplify my tax accounting reports! Thank you!
@odarrien2 жыл бұрын
Thank you for this. Setting up my business accounts for the first time and this is really helpful. I pretty much made my spreadsheet with the formatting you did, I'll add anything needed as I go along.
@joyoffilming9500Ай бұрын
This was the most valuable Mc Numbers tutorial I've ever seen on Yt so far. Just awesome and worth every minute watched. THANKS!
@khill50able3 жыл бұрын
Thanks Gary for a well explained example. I was able to create a spreadsheet to let me know how much I spend in any given year on my Mastercard and where I use it. Very handy.
@alanrenton6059 Жыл бұрын
I think it is great that these videos are so unpolished yet so informative. Being a longterm Microsoft user and converting to Apple products, the transition has been enlightening and while Numbers does everything pretty much that Excel does it doesn't feel as intuitive but maybe that's over familiarity. Keep up the good work.
@38williw2 жыл бұрын
Thanks for that. New to Mac and find your tutorials better than most because you go reasonably slowly. Seniors need that. I’m tired of yelling stop, stop, stop at a video that is going light speed. 😬
@AkashicBeauty Жыл бұрын
THANK YOU!!!! You have guided us all through this process so brilliantly. Thank you so much, I have tried to play around with the Mac Numbers app for sooooo long & I just couldn't figure it out. Without you creating this video I would still be using pen & paper trying to calculate everything & given up on trying to work out how to use these sheets. This whole video is worth the watch & will help any one with their personal accounts or businesses forever THANK YOU!
@ki5462 жыл бұрын
Your video was extraordinarily helpful. I made my personal and business financial spreadsheet with an automated dashboard! Now I don't have to hunt down my mistakes, I can just use the formulas you showed me and display things so nicely. Thank you!!!
@judyniderost3623 жыл бұрын
Thank you Gary! Your tutorial was awesome. I built my spreadsheets as I watched your video and now I am ready to start doing my bookkeeping. I love your videos!
@jasemisael646
3 жыл бұрын
sorry to be off topic but does any of you know of a way to log back into an Instagram account? I was stupid forgot the account password. I appreciate any help you can offer me!
@nickolasreuben4025
3 жыл бұрын
@Jase Misael Instablaster :)
@jasemisael646
3 жыл бұрын
@Nickolas Reuben thanks so much for your reply. I got to the site thru google and im trying it out atm. Looks like it's gonna take quite some time so I will get back to you later with my results.
@jasemisael646
3 жыл бұрын
@Nickolas Reuben It worked and I finally got access to my account again. Im so happy:D Thanks so much you really help me out!
@nickolasreuben4025
3 жыл бұрын
@Jase Misael Happy to help :)
@dianemcfadden61602 жыл бұрын
I am overwhelmed !! I am going to have to watch a lot to catch on. I enjoy doing the green spreadsheets and now, I know why..
@sideshowsiren11 ай бұрын
Thank you so much for posting! This is a gamechanger for my small business. Very grateful.
@snks4pets3 жыл бұрын
I truly appreciate your expertise in this matter. It has opened my eyes to Numbers. Thank you! Thank you! Thank you!
@e11drops2 жыл бұрын
I just want to thank you and tell you that you saved me lot's of time, I wish I looked for you on my first year in business. :)
@paladdin15003 жыл бұрын
Thank you! finally !!! I've been looking for this for years
@K.A.N3 ай бұрын
THANKS SO MUCH FOR THE AWESOME INFORMATIONS YOU SHARED
@kakman19582 жыл бұрын
I've just stumbled onto this when it appeared in my YT feed. Great job!. I've never really explored Numbers beyond using it a 'smart calculator' but this video has revealed so much more it can do.
@CJ4Z1JC3 жыл бұрын
Gary, thank you for this video! its just what i was looking for! trying to get our family organized on our finances and track where all of our money goes!! And most importantly where we are spending the most!! I saw the Personal Budget template but I wanted to do several different things and you answered my questions with this video. Thanks again!!
@samuelfarnham26533 жыл бұрын
An absolute life saver! And the perfect start to learning the iOS system
@nadiaibarrola9562 Жыл бұрын
Thanks Gary! Just started watching your videos and they've been very helpgful!
@photom32 жыл бұрын
I like your videos. Good production value, to the point without any filler. Reminders of things I forgot along the way.
@photom3
2 жыл бұрын
I should proofread carefully. Should have said without
@adriandeb27102 жыл бұрын
Best video on numbers on youtube, thank you
@sablebreeze47172 жыл бұрын
This was so helpful! I love that event though it was a long live it was just full of constant helpful information. Thanks so much!
@caroletomaszewicz737 Жыл бұрын
Hi - This is brilliant! Thank you. I grew up with Excel, so this is a brilliant quick root around, and helped me develop exactly what I needed for my small business. Well done. And again, thanks for the work and support.
@edwinprabhakar23192 жыл бұрын
THANK YOU SO MUCH, MOST USEFUL VIDEO AS I AM A BEGINNER AND LOVED THE WALKTHROUGH.
@The.Memes.2 жыл бұрын
Using this format for my book keeping now. Thank you so much
@trevorstafford1375 Жыл бұрын
Really useful stuff thank you Gary
@nassrahmed27382 жыл бұрын
Gary thank you for all your explanation. I have a question. Can I link cells from different folders in to a table?
@LC.1012 жыл бұрын
You made my day! It's so helpful! Thank you so much!
@zzzzt2 жыл бұрын
How do you add a recurring expenses / fixed costs such as insurance premium or software subscriptions (that use automatic debit payments)? so that we don’t have to input them manually every month
@Gigi222257 ай бұрын
Thank you for the excellent video!
@amyseefeldt4192 жыл бұрын
This is SOOOO helpful! Thank you! And I know very little about accounting. Great video.
@dominiquedixon2 жыл бұрын
THANK YOU THANK YOU THANK YOU!!!! This video was so helpful.
@eithuzarsoe55423 жыл бұрын
Excellent Learning Point and Source.Thank You Gary.
@OfficialBobbyChulo3 жыл бұрын
Thank you so much for this video! Organized my business in a short amount of time!
@korinacarnes2 жыл бұрын
This was so helpful, thank you so much for all your videos.
@DH-kq2bf3 жыл бұрын
I was just looking for this, I need to become a Patreon. You always have helped me out big time. If I'd file my contribution as a Patreon, what would that fall under, profesional services or something else? You are the best
@patystour88472 жыл бұрын
Thank you for sharing this video!! It was really helpful for me since I have a new MackBook and didn't know how to use the new Number style. :-) After watching this video you helped me to understand this new system on MackBook 🙂 Have a great week!!!
@DObrandYOU Жыл бұрын
Thank you this was very helpful.
@marinaxlove2 жыл бұрын
This was incredibly helpful. thank you so so much for sharing your knowledge with us!!!
@GrammyAllen2 жыл бұрын
Hey Gary! In ONE WEEK, I went from meltdown over bookkeeping with paper to a fully built spreadsheet! I have a General Ledger and a Profit & Loss summary sheet with totals both for YTD AND a Running Total! Now, Can we make it play a "Ta-da!" sound or event when I click that it matches what the bank has? 😁🤣 Thank you SOOO much!! -G
@jeanlucvassort64112 жыл бұрын
So may thanks Gary ... really interesting video, a lot to learn ...
@bobpug2 жыл бұрын
Gary ..you're a pro..What I would really like to know is how to protect formulas so they don't accidentally get deleted by a novice user...Also using a iPad you lose a lot of functions or they are really hidden well..
@rocky54app3 жыл бұрын
Very clear and straight forward, thanks a lot.
@Fnoteabewmedia3 жыл бұрын
Hi Macmostvideo, thank you for your valuable teachings I am learning a lot. But I just want ask you one think, I have a new external hard drive usually I am using it in windows but not working in my iMac. I would be pleased if you make a video about it or if you have old videos can you plz send me the link ? I tried to search but I couldn't find any. with more respect 🙏.
@rdelamora3 жыл бұрын
Man, you rules! Thanks a lot for all
@chelsiem43597 ай бұрын
Hi Gary, excellent video! Thank you so much. I had a quick question regarding cell 'total 1' I noticed the amount does not change depending on the year. I wondered if you/anyone else had the formula for this so it changes depending on the year? Many thanks
@macmost
7 ай бұрын
Not sure what you mean. Can you be more specific? This is a 47-minute video that I recorded 3 years ago (have made probably 500 videos since then). What is the formula right now and what do you want it to do that is different?
@justineprecepa3 жыл бұрын
Thank you for this tutorial!
@ToddHudsonAtl2 жыл бұрын
I'm going to make my teenagers watch this video. Better than a whole semester of econ.
@puppetman318 ай бұрын
Awesome. Thank You...
@Brendonluvr242 жыл бұрын
THANK! YOU!
@keniahernandez20283 жыл бұрын
Such an awesome video!! thank you for the knowledge you're sharing with all of us!:)
@pastorsurya6 ай бұрын
I can't thank you enough for your help. I created one following your footsteps. What's the best template for a tiny nonprofit ? How to make a 'statement of activities' in numbers? Please guide. I am 0 level learner and have the need of doing bookkeeping as I have a nonprofit with almost zero income but have to keep the records.
@macmost
6 ай бұрын
There is no one-size-fits-all solution. Each business has different needs and each user has different abilities. If you really want to build your own (as opposed to using an accounting app/site) then you've got to come up with a spreadsheet that is customized for you. You can always work with a bookkeeper or accountant on it and let them help you.
@Good_enough_dude2 жыл бұрын
I love when he’s like “just copy and paste” like bro. How tf did you do that. Nerds forget most of us run on about 1/30th of their understanding 😂
@fast-end Жыл бұрын
uyeah... nice nice... thanks a lot 💐... is there a posinility in numbers to scrape tables?
@redmondfam2 жыл бұрын
I''m new to Macbook and have learned so much by watching your videos, thank you. Question though. What if I want to filter by month and year? I've added a month table like the year table, added the month and if month columns, etc. and the filters but it just isn't working like I thought. Thanks in advance.
@macmost
2 жыл бұрын
Have a year column and a month column. Add two filters, one for each column.
@Robbo_5479 ай бұрын
I come back here every year 🤣🙋♂(usually cursing SUM...IF)
@louisdesrosiers69543 жыл бұрын
Missed it , but thanks for posting it :-)
@KevObispo3 жыл бұрын
Really helpful. Thank you!
@fastscout40796 ай бұрын
Gary do you have your Numbers tutorials in order eg. starting from basic and building up the knowledge base- eg 1st video, 2nd video etc. Loving your tuts .Mick
@macmost
6 ай бұрын
For that I have a course at courses.macmost.com. My regular tutorials don't really work that way: for instance I may talk about a topic and show the basics and advanced tips all in one video on that topic.
@superiorbeing952 жыл бұрын
This guy is the best
@robertarmstrong71303 жыл бұрын
How can I add a collem for inventory for expences to remove from inventory from income sales?
@skysurferdude Жыл бұрын
Gary, thanks so much for sharing your expertise! I downloaded the file you shared but discovered I am getting an error when adding subsequent rows in the "Is Year" hidden column. The formula is not following down the column and is instead marking the cell with a blue triangle note which says "The formula was replaced with its last calculated value." Why is the formula not continuing to function when rows are added and how can I correct it? I have to recopy and re-paste the formula to subsequent rows as a work-around.
@macmost
Жыл бұрын
Remember to turn off the filter before adding new rows.
@rivquah3 жыл бұрын
this was so helpful. thank you!
@ericcorona95363 жыл бұрын
Thank you for the great spreadsheet. I am having trouble with 1 thing though, every time I add a new row, a blue triangle comes up in the “Is Year” column. It says it couldn’t copy the formula. Is there a fix for that? The only fix I have found is to copy and paste the formula into that particular cell
@rodrigosalas3687
3 жыл бұрын
@macmostvideo I got the same situation. Any fix yet? #macmost #macnumbers
@dimogeorgakakos25704 ай бұрын
Hi Gary. Thanks for all the great videos. I added an image of a receipt to my business spreadsheet cell to correspond to the entry but I can’t subsequently open it to see it again when I need to. Any advice? Regards.
@macmost
4 ай бұрын
If you added an image to a cell it is now just the background of the cell. That's all you can do with it. A Numbers spreadsheet is no a good place to "store" receipts. Instead, just put the well-named file in a folder in the Finder that contains your receipts in case you need it. This will also save you from ending up with a massive Numbers file.
@thewearyboy2 жыл бұрын
Maybe I missed it in the video but I was wondering how to make a blank template (without any values entered) out of a created spreadsheet so that I can use it as a blank template. thanks for the videos. Ive learned so much in the past 24 hours from you and I've never used spreadsheets in my life.
@macmost
2 жыл бұрын
Create the template as you like and there is a command in the File menu to save it as a template.
@ruthiverse7 ай бұрын
Hi Gary, great tutorial, thank you!! I have a question about the functionality of a formula within a cell when the filter is on. When adding a new row in the Expenses table and the “Text is true” filter is turned on, the true/false function “a=b” in the “Is Year” cell of this newly created row appears broken: “The formula was replaced with its last calculated value.” I noticed that when turning the filters off this does not happen. Is there a way to make the a=b formula work when having the filter on? Maybe a tweaked formula of some sort? This would make the table more workable in the future when I have years of input in the table. ;-)
@macmost
7 ай бұрын
No you should always only add rows when the filters are off.
@Kuwandi Жыл бұрын
Awsome presentation- my only thing is a “preface” stating that “sheets” feature Carrie’s a relevancy from one sheet to another* … I was not following the jumping between the “ sheets” wholly …
@beckymash122 жыл бұрын
Sumif does not populate after entering in conditions (for me at least.) It leaves totals at zero. I used sumproduct instead.
@ghgomez22 жыл бұрын
One year late, but I did enjoy and learned from this video. I do have two questions. 1) In the cells with a formula in it, how do you protect them from a user overwritten them? 2) On your summary table, if a new category is added in the detail tables, can that new entry be automatically added to the summary table? Gary, as always, you are an excellent teacher and I thank you for sharing that knowledge with us.
@macmost
2 жыл бұрын
1) You can't lock a cell, only a whole table. 2) You'll need to add it to the second table yourself.
@EstonianBerserker3 жыл бұрын
I use NUMBERS app once a month for Inventory for a place I work at. My father has a nice graph sheet of each coin detailed on every line using the BLANK template (NOT CHECKLIST) Now, I want to know if theres a better way to add a picture of the coin on each line without having to take up 3-4 lines worth which makes the graph extremely stretched out & long.
@jacobesquer5966 ай бұрын
Thank you for putting this tutorial out here, its been very helpful but, when I get to 47:25 in this video, you don’t point out which button to click to get my amount in my income summary. I followed this to a tee,but I don’t know if I should hit enter, the green check or what. I am not computer savvy so if I sound ignorant, it’s because I am. Thank you
@macmost
6 ай бұрын
What time? The video is 47:25 long. At what time in that are you asking about?
@jacobesquer596
6 ай бұрын
My apologies, the time was approximately 15:45, but after going over it many time, I figured it out. Thank you for responding so quickly and for putting out tutorials they’re very helpful.
@samstropic7316 Жыл бұрын
This was really useful, thank you. Is there a way, as I'm in the UK, to change the year part to do from April to March (this is our tax year)?
@macmost
Жыл бұрын
You can set it up any way you like. Use this video to learn the basics and then expand on that.
@BestLifePlanet-yk2tn5 ай бұрын
Hello! Thank you for your video. How can you import bank transactions into this spreadsheet for Mac.
@macmost
5 ай бұрын
Depends on the bank. Usually a bank should allow you to download a CSV file. Get that and you can open it in Numbers. Then copy and paste what you want into your own spreadsheet.
@smdd6751 Жыл бұрын
Could u use a lookup kinda deal where u can search a specific date or number and find that part of the spreadsheet?
@macmost
Жыл бұрын
Yes. You can build it that way. You can just use the Find command in Numbers, or you can create something more complex with formulas, filters, other tables, etc. It depends on your spreadsheet skills.
@leondoliveira29952 жыл бұрын
Great tutorial! I would like to set one up with a worksheet for each month. When I copy and paste the worksheet, the formula's keep referring to the first worksheet. How can I tackle that?
@nathaliemarnham5899 Жыл бұрын
Hi Gary, I am new to your channel and right this minute, crying this video. Fro some reason, on the SUMIF I am able to do the formula, but it comes up with 0 on the Office expenses, however when I copy the formula, for the other lines, it works perfectly well. Any idea of what the problem is please? Kind regards, Nathalie
@macmost
Жыл бұрын
Check the cell references carefully. Make sure it is referring to the correct cells.
@cingo193 жыл бұрын
Hi, very nice video, thanks. I have a question. Is it possible to have pop up menus depending on an entry? Let’s guess for example I choose the category “travel”. Then on the adjacent column I would like a subcategory pop up menu where I could choose among train, airline, car, etc... Or if I’d selected the main category as “meals”, the subcategory popup menu would be updated with “restaurant, takeaway, pub, etc...”. Is this doable? Many thanks
@Dynamo-cv1kz5 ай бұрын
Hello, Gary. A couple of years ago, I watched you do a different video on a basic business spreadsheet. I can no longer find it on your channel. Specifically, I remember you setting up the spreadsheet, and then you created a column called the Due Flag and its input was either a 0 or a 1. Does this ring a bell and is this video somewhere on your channel. Thank you.
@macmost
5 ай бұрын
kzread.info/dash/bejne/pJOGtNKTmLipqrQ.html
@elveracochrell733 жыл бұрын
I found it hard to keep up. I tried doing a spreadsheet along with you but I would get a false or a red triangle in the summary column using the expense and summary pages
@coronarolfing
3 жыл бұрын
Me too.
@BURGO19793 жыл бұрын
Thank you Gary. You inspired me to create some other spreadsheets that would help in my day to day work productivity. Much appreciated 🙏
@saulmejia54432 жыл бұрын
Can you create an addition to they video adding a new page with payroll specifications as well?
@carlosm88823 жыл бұрын
Hi Gary, I have grey grid lines and know how to remove them in a table for for some reason some cells keep the grey outlines?
@IDANLEVY1002 жыл бұрын
Thank you
@brittanywood83 Жыл бұрын
Is it possible to create a search cell that would generate an entire sheet? I am working with a class of students and want to use the spreadsheet with one sheet (type in student name, it brings up their data from other sheets)
@muzicozaurus88612 жыл бұрын
I have a question and I now it's not necessarily on this topic. How do you glue together several tables in numbers to make one big one.. they are one under another with the same size on the same spreadsheet. Many thanks in advance!
@pairomay2 жыл бұрын
This is so helpful thank you. Is there a way to add a currency category, so that it if i input CAD or USD in a column that it sends it to a different summary?
@pairomay
2 жыл бұрын
I tried to do it, but don't know how to add a second condition to SUMIF, let me know if this makes sense
@loewencarlin3751 Жыл бұрын
If I want to have a separate spread sheet for each month of the year, is it possible to have them there where you currently can select to view Expenses, Income and Summery? Like the first option would be to select the month, then either expenses, income or summery?
@macmost
Жыл бұрын
Not easily. I would recommend against separating things by month. It will make all sorts of things more difficult. Just put all of the transactions in a table together.
@dannyuong90473 жыл бұрын
Thank you!
@paintersson8 ай бұрын
Do you know of a way I could make a spreadsheet to calculate bread recipes? Like bakers percentages. So if I put a different flour weight in it would change all my ingridients to match.
@macmost
8 ай бұрын
Definitely. I don't know anything about "bakers percentages" but just work out the formulas for each item and build the spreadsheet. It sounds like you just need multiplication (or division) to do that. Should be relatively simple.
@deeapple10962 жыл бұрын
You know what, nm my question below. I realized Box gives me the option to open in Numbers and doing so retains all my Mac preferences. :) Q: I've built a spreadsheet in Numbers and uploaded it to a shared Box folder. Now the horizontal scroll bar keeps disappearing. Does anyone know how to make it stay (both scroll bars) when opening Numbers on the Web via Box? Thanks.
Пікірлер: 254
I feel like I just took a Master Class. You're flying through things in Numbers that I find an absolute PITA to do with Excel. Thank you for this video
I am a true beginner and honestly I felt as if I needed to know a few things before I watched this, thanks for the lesson I’ll comeback and learn from you after I learn the basic and shake off my frustration.
You have a relaxed style which is excellent for delivering complex training like this. Thoroughly enjoyed this, thanks Gary.
I appreciate MacMost for the educational tutoring necessary to help new Mac users like myself.
Gary you are so knowledgeable and communicate the features so clearly & easily. I used to use Windows for Mac until I started learning more about Numbers. Your videos helped with that transition.
Wow! This is awesome! I had a bit of a meltdown today because I was so overwhelmed with my bookkeeping. I have dyscalculia and some PTSD over mathy things. I'm going to have to watch this many times. Thanks for this!
At 59 and retired I enjoyed your video. Wonderful video. I have been using Excel for years on an old HP with windows 7 😆 and just bought a MacBook Pro 14 so my mind is blown. Took me half a day to watch and take notes then create as you did. I have watched some basics on Mac so I loved the challenge of all the simple things like copy paste etc and when to 2x clicking columns!! Looking forward to watching more of your videos.
you are a lifesaver!!! i’ve been searching everywhere for simple software for my small business, but i knew there had to be a way to do this in Numbers, and i created it as i watched your video. ❤Thank You so much.
I have used Microsoft Office for many years and I was curious to see how feature rich Numbers is when compared to Microsoft Excel. I don't have a Mac as yet, but I think that Numbers will definitely meet all of my needs if I decide to purchase an Apple laptop. Thank you for the excellent video!
I knew I could do a lot more with spreadsheets than I was doing and this video showed me everything I needed to simplify my tax accounting reports! Thank you!
Thank you for this. Setting up my business accounts for the first time and this is really helpful. I pretty much made my spreadsheet with the formatting you did, I'll add anything needed as I go along.
This was the most valuable Mc Numbers tutorial I've ever seen on Yt so far. Just awesome and worth every minute watched. THANKS!
Thanks Gary for a well explained example. I was able to create a spreadsheet to let me know how much I spend in any given year on my Mastercard and where I use it. Very handy.
I think it is great that these videos are so unpolished yet so informative. Being a longterm Microsoft user and converting to Apple products, the transition has been enlightening and while Numbers does everything pretty much that Excel does it doesn't feel as intuitive but maybe that's over familiarity. Keep up the good work.
Thanks for that. New to Mac and find your tutorials better than most because you go reasonably slowly. Seniors need that. I’m tired of yelling stop, stop, stop at a video that is going light speed. 😬
THANK YOU!!!! You have guided us all through this process so brilliantly. Thank you so much, I have tried to play around with the Mac Numbers app for sooooo long & I just couldn't figure it out. Without you creating this video I would still be using pen & paper trying to calculate everything & given up on trying to work out how to use these sheets. This whole video is worth the watch & will help any one with their personal accounts or businesses forever THANK YOU!
Your video was extraordinarily helpful. I made my personal and business financial spreadsheet with an automated dashboard! Now I don't have to hunt down my mistakes, I can just use the formulas you showed me and display things so nicely. Thank you!!!
Thank you Gary! Your tutorial was awesome. I built my spreadsheets as I watched your video and now I am ready to start doing my bookkeeping. I love your videos!
@jasemisael646
3 жыл бұрын
sorry to be off topic but does any of you know of a way to log back into an Instagram account? I was stupid forgot the account password. I appreciate any help you can offer me!
@nickolasreuben4025
3 жыл бұрын
@Jase Misael Instablaster :)
@jasemisael646
3 жыл бұрын
@Nickolas Reuben thanks so much for your reply. I got to the site thru google and im trying it out atm. Looks like it's gonna take quite some time so I will get back to you later with my results.
@jasemisael646
3 жыл бұрын
@Nickolas Reuben It worked and I finally got access to my account again. Im so happy:D Thanks so much you really help me out!
@nickolasreuben4025
3 жыл бұрын
@Jase Misael Happy to help :)
I am overwhelmed !! I am going to have to watch a lot to catch on. I enjoy doing the green spreadsheets and now, I know why..
Thank you so much for posting! This is a gamechanger for my small business. Very grateful.
I truly appreciate your expertise in this matter. It has opened my eyes to Numbers. Thank you! Thank you! Thank you!
I just want to thank you and tell you that you saved me lot's of time, I wish I looked for you on my first year in business. :)
Thank you! finally !!! I've been looking for this for years
THANKS SO MUCH FOR THE AWESOME INFORMATIONS YOU SHARED
I've just stumbled onto this when it appeared in my YT feed. Great job!. I've never really explored Numbers beyond using it a 'smart calculator' but this video has revealed so much more it can do.
Gary, thank you for this video! its just what i was looking for! trying to get our family organized on our finances and track where all of our money goes!! And most importantly where we are spending the most!! I saw the Personal Budget template but I wanted to do several different things and you answered my questions with this video. Thanks again!!
An absolute life saver! And the perfect start to learning the iOS system
Thanks Gary! Just started watching your videos and they've been very helpgful!
I like your videos. Good production value, to the point without any filler. Reminders of things I forgot along the way.
@photom3
2 жыл бұрын
I should proofread carefully. Should have said without
Best video on numbers on youtube, thank you
This was so helpful! I love that event though it was a long live it was just full of constant helpful information. Thanks so much!
Hi - This is brilliant! Thank you. I grew up with Excel, so this is a brilliant quick root around, and helped me develop exactly what I needed for my small business. Well done. And again, thanks for the work and support.
THANK YOU SO MUCH, MOST USEFUL VIDEO AS I AM A BEGINNER AND LOVED THE WALKTHROUGH.
Using this format for my book keeping now. Thank you so much
Really useful stuff thank you Gary
Gary thank you for all your explanation. I have a question. Can I link cells from different folders in to a table?
You made my day! It's so helpful! Thank you so much!
How do you add a recurring expenses / fixed costs such as insurance premium or software subscriptions (that use automatic debit payments)? so that we don’t have to input them manually every month
Thank you for the excellent video!
This is SOOOO helpful! Thank you! And I know very little about accounting. Great video.
THANK YOU THANK YOU THANK YOU!!!! This video was so helpful.
Excellent Learning Point and Source.Thank You Gary.
Thank you so much for this video! Organized my business in a short amount of time!
This was so helpful, thank you so much for all your videos.
I was just looking for this, I need to become a Patreon. You always have helped me out big time. If I'd file my contribution as a Patreon, what would that fall under, profesional services or something else? You are the best
Thank you for sharing this video!! It was really helpful for me since I have a new MackBook and didn't know how to use the new Number style. :-) After watching this video you helped me to understand this new system on MackBook 🙂 Have a great week!!!
Thank you this was very helpful.
This was incredibly helpful. thank you so so much for sharing your knowledge with us!!!
Hey Gary! In ONE WEEK, I went from meltdown over bookkeeping with paper to a fully built spreadsheet! I have a General Ledger and a Profit & Loss summary sheet with totals both for YTD AND a Running Total! Now, Can we make it play a "Ta-da!" sound or event when I click that it matches what the bank has? 😁🤣 Thank you SOOO much!! -G
So may thanks Gary ... really interesting video, a lot to learn ...
Gary ..you're a pro..What I would really like to know is how to protect formulas so they don't accidentally get deleted by a novice user...Also using a iPad you lose a lot of functions or they are really hidden well..
Very clear and straight forward, thanks a lot.
Hi Macmostvideo, thank you for your valuable teachings I am learning a lot. But I just want ask you one think, I have a new external hard drive usually I am using it in windows but not working in my iMac. I would be pleased if you make a video about it or if you have old videos can you plz send me the link ? I tried to search but I couldn't find any. with more respect 🙏.
Man, you rules! Thanks a lot for all
Hi Gary, excellent video! Thank you so much. I had a quick question regarding cell 'total 1' I noticed the amount does not change depending on the year. I wondered if you/anyone else had the formula for this so it changes depending on the year? Many thanks
@macmost
7 ай бұрын
Not sure what you mean. Can you be more specific? This is a 47-minute video that I recorded 3 years ago (have made probably 500 videos since then). What is the formula right now and what do you want it to do that is different?
Thank you for this tutorial!
I'm going to make my teenagers watch this video. Better than a whole semester of econ.
Awesome. Thank You...
THANK! YOU!
Such an awesome video!! thank you for the knowledge you're sharing with all of us!:)
I can't thank you enough for your help. I created one following your footsteps. What's the best template for a tiny nonprofit ? How to make a 'statement of activities' in numbers? Please guide. I am 0 level learner and have the need of doing bookkeeping as I have a nonprofit with almost zero income but have to keep the records.
@macmost
6 ай бұрын
There is no one-size-fits-all solution. Each business has different needs and each user has different abilities. If you really want to build your own (as opposed to using an accounting app/site) then you've got to come up with a spreadsheet that is customized for you. You can always work with a bookkeeper or accountant on it and let them help you.
I love when he’s like “just copy and paste” like bro. How tf did you do that. Nerds forget most of us run on about 1/30th of their understanding 😂
uyeah... nice nice... thanks a lot 💐... is there a posinility in numbers to scrape tables?
I''m new to Macbook and have learned so much by watching your videos, thank you. Question though. What if I want to filter by month and year? I've added a month table like the year table, added the month and if month columns, etc. and the filters but it just isn't working like I thought. Thanks in advance.
@macmost
2 жыл бұрын
Have a year column and a month column. Add two filters, one for each column.
I come back here every year 🤣🙋♂(usually cursing SUM...IF)
Missed it , but thanks for posting it :-)
Really helpful. Thank you!
Gary do you have your Numbers tutorials in order eg. starting from basic and building up the knowledge base- eg 1st video, 2nd video etc. Loving your tuts .Mick
@macmost
6 ай бұрын
For that I have a course at courses.macmost.com. My regular tutorials don't really work that way: for instance I may talk about a topic and show the basics and advanced tips all in one video on that topic.
This guy is the best
How can I add a collem for inventory for expences to remove from inventory from income sales?
Gary, thanks so much for sharing your expertise! I downloaded the file you shared but discovered I am getting an error when adding subsequent rows in the "Is Year" hidden column. The formula is not following down the column and is instead marking the cell with a blue triangle note which says "The formula was replaced with its last calculated value." Why is the formula not continuing to function when rows are added and how can I correct it? I have to recopy and re-paste the formula to subsequent rows as a work-around.
@macmost
Жыл бұрын
Remember to turn off the filter before adding new rows.
this was so helpful. thank you!
Thank you for the great spreadsheet. I am having trouble with 1 thing though, every time I add a new row, a blue triangle comes up in the “Is Year” column. It says it couldn’t copy the formula. Is there a fix for that? The only fix I have found is to copy and paste the formula into that particular cell
@rodrigosalas3687
3 жыл бұрын
@macmostvideo I got the same situation. Any fix yet? #macmost #macnumbers
Hi Gary. Thanks for all the great videos. I added an image of a receipt to my business spreadsheet cell to correspond to the entry but I can’t subsequently open it to see it again when I need to. Any advice? Regards.
@macmost
4 ай бұрын
If you added an image to a cell it is now just the background of the cell. That's all you can do with it. A Numbers spreadsheet is no a good place to "store" receipts. Instead, just put the well-named file in a folder in the Finder that contains your receipts in case you need it. This will also save you from ending up with a massive Numbers file.
Maybe I missed it in the video but I was wondering how to make a blank template (without any values entered) out of a created spreadsheet so that I can use it as a blank template. thanks for the videos. Ive learned so much in the past 24 hours from you and I've never used spreadsheets in my life.
@macmost
2 жыл бұрын
Create the template as you like and there is a command in the File menu to save it as a template.
Hi Gary, great tutorial, thank you!! I have a question about the functionality of a formula within a cell when the filter is on. When adding a new row in the Expenses table and the “Text is true” filter is turned on, the true/false function “a=b” in the “Is Year” cell of this newly created row appears broken: “The formula was replaced with its last calculated value.” I noticed that when turning the filters off this does not happen. Is there a way to make the a=b formula work when having the filter on? Maybe a tweaked formula of some sort? This would make the table more workable in the future when I have years of input in the table. ;-)
@macmost
7 ай бұрын
No you should always only add rows when the filters are off.
Awsome presentation- my only thing is a “preface” stating that “sheets” feature Carrie’s a relevancy from one sheet to another* … I was not following the jumping between the “ sheets” wholly …
Sumif does not populate after entering in conditions (for me at least.) It leaves totals at zero. I used sumproduct instead.
One year late, but I did enjoy and learned from this video. I do have two questions. 1) In the cells with a formula in it, how do you protect them from a user overwritten them? 2) On your summary table, if a new category is added in the detail tables, can that new entry be automatically added to the summary table? Gary, as always, you are an excellent teacher and I thank you for sharing that knowledge with us.
@macmost
2 жыл бұрын
1) You can't lock a cell, only a whole table. 2) You'll need to add it to the second table yourself.
I use NUMBERS app once a month for Inventory for a place I work at. My father has a nice graph sheet of each coin detailed on every line using the BLANK template (NOT CHECKLIST) Now, I want to know if theres a better way to add a picture of the coin on each line without having to take up 3-4 lines worth which makes the graph extremely stretched out & long.
Thank you for putting this tutorial out here, its been very helpful but, when I get to 47:25 in this video, you don’t point out which button to click to get my amount in my income summary. I followed this to a tee,but I don’t know if I should hit enter, the green check or what. I am not computer savvy so if I sound ignorant, it’s because I am. Thank you
@macmost
6 ай бұрын
What time? The video is 47:25 long. At what time in that are you asking about?
@jacobesquer596
6 ай бұрын
My apologies, the time was approximately 15:45, but after going over it many time, I figured it out. Thank you for responding so quickly and for putting out tutorials they’re very helpful.
This was really useful, thank you. Is there a way, as I'm in the UK, to change the year part to do from April to March (this is our tax year)?
@macmost
Жыл бұрын
You can set it up any way you like. Use this video to learn the basics and then expand on that.
Hello! Thank you for your video. How can you import bank transactions into this spreadsheet for Mac.
@macmost
5 ай бұрын
Depends on the bank. Usually a bank should allow you to download a CSV file. Get that and you can open it in Numbers. Then copy and paste what you want into your own spreadsheet.
Could u use a lookup kinda deal where u can search a specific date or number and find that part of the spreadsheet?
@macmost
Жыл бұрын
Yes. You can build it that way. You can just use the Find command in Numbers, or you can create something more complex with formulas, filters, other tables, etc. It depends on your spreadsheet skills.
Great tutorial! I would like to set one up with a worksheet for each month. When I copy and paste the worksheet, the formula's keep referring to the first worksheet. How can I tackle that?
Hi Gary, I am new to your channel and right this minute, crying this video. Fro some reason, on the SUMIF I am able to do the formula, but it comes up with 0 on the Office expenses, however when I copy the formula, for the other lines, it works perfectly well. Any idea of what the problem is please? Kind regards, Nathalie
@macmost
Жыл бұрын
Check the cell references carefully. Make sure it is referring to the correct cells.
Hi, very nice video, thanks. I have a question. Is it possible to have pop up menus depending on an entry? Let’s guess for example I choose the category “travel”. Then on the adjacent column I would like a subcategory pop up menu where I could choose among train, airline, car, etc... Or if I’d selected the main category as “meals”, the subcategory popup menu would be updated with “restaurant, takeaway, pub, etc...”. Is this doable? Many thanks
Hello, Gary. A couple of years ago, I watched you do a different video on a basic business spreadsheet. I can no longer find it on your channel. Specifically, I remember you setting up the spreadsheet, and then you created a column called the Due Flag and its input was either a 0 or a 1. Does this ring a bell and is this video somewhere on your channel. Thank you.
@macmost
5 ай бұрын
kzread.info/dash/bejne/pJOGtNKTmLipqrQ.html
I found it hard to keep up. I tried doing a spreadsheet along with you but I would get a false or a red triangle in the summary column using the expense and summary pages
@coronarolfing
3 жыл бұрын
Me too.
Thank you Gary. You inspired me to create some other spreadsheets that would help in my day to day work productivity. Much appreciated 🙏
Can you create an addition to they video adding a new page with payroll specifications as well?
Hi Gary, I have grey grid lines and know how to remove them in a table for for some reason some cells keep the grey outlines?
Thank you
Is it possible to create a search cell that would generate an entire sheet? I am working with a class of students and want to use the spreadsheet with one sheet (type in student name, it brings up their data from other sheets)
I have a question and I now it's not necessarily on this topic. How do you glue together several tables in numbers to make one big one.. they are one under another with the same size on the same spreadsheet. Many thanks in advance!
This is so helpful thank you. Is there a way to add a currency category, so that it if i input CAD or USD in a column that it sends it to a different summary?
@pairomay
2 жыл бұрын
I tried to do it, but don't know how to add a second condition to SUMIF, let me know if this makes sense
If I want to have a separate spread sheet for each month of the year, is it possible to have them there where you currently can select to view Expenses, Income and Summery? Like the first option would be to select the month, then either expenses, income or summery?
@macmost
Жыл бұрын
Not easily. I would recommend against separating things by month. It will make all sorts of things more difficult. Just put all of the transactions in a table together.
Thank you!
Do you know of a way I could make a spreadsheet to calculate bread recipes? Like bakers percentages. So if I put a different flour weight in it would change all my ingridients to match.
@macmost
8 ай бұрын
Definitely. I don't know anything about "bakers percentages" but just work out the formulas for each item and build the spreadsheet. It sounds like you just need multiplication (or division) to do that. Should be relatively simple.
You know what, nm my question below. I realized Box gives me the option to open in Numbers and doing so retains all my Mac preferences. :) Q: I've built a spreadsheet in Numbers and uploaded it to a shared Box folder. Now the horizontal scroll bar keeps disappearing. Does anyone know how to make it stay (both scroll bars) when opening Numbers on the Web via Box? Thanks.