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
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!
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.
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.
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.
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. 😬
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 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 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.
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!
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!
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!
@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.
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!
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!!!
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!!
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 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!!!
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
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
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..
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
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 🙏.
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.
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.
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
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?
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.
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
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.
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.
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 …
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
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
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.
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.
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. 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.
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.
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
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.
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!
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.
Weird. I'm following along at 17:55 to make the two expense summaries but when I click to sum the whole column for the expense summary sheet on footer line 2 it wants to add the whole column *including* the footer, instead of everything above it.
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.
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. ;-)
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)
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
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.
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
Hi Gary Please help! DATE, CATEGORY, SOURCE, COST OF GOODS, RETAIL PRICE, PROFIT, DESCRIPTION. I've been watching your videos for years thanks for the hard work. I'm a small business. Can you please explain how to figure out the profit please please Thanks Mariam
Not quite sure what you are asking. Seems like a basic business question. If the price you sell something for is "retail price" and the price you buy it for is "cost of goods" then subtract the second one from the first, right?
Hi great video, is there a way instead of having the summary divided into each tax year, to have it between two dates? My business year is 5th April to the 4th April the following year! Very new to this but any advice would be greatly appreciated.
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.
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.
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.
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 appreciate MacMost for the educational tutoring necessary to help new Mac users like myself.
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!
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.
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.
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.
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. 😬
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.
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 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.
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!!!! 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!
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!
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!
@Jase Misael Instablaster :)
@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.
@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!
@Jase Misael Happy to help :)
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 truly appreciate your expertise in this matter. It has opened my eyes to Numbers. Thank you! Thank you! Thank you!
Thank you so much for posting! This is a gamechanger for my small business. Very grateful.
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!!!
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. :)
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.
I like your videos. Good production value, to the point without any filler. Reminders of things I forgot along the way.
I should proofread carefully. Should have said without
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!!
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.
An absolute life saver! And the perfect start to learning the iOS system
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!
Using this format for my book keeping now. Thank you so much
Thanks Gary! Just started watching your videos and they've been very helpgful!
Thank you so much for this video! Organized my business in a short amount of time!
Thank you! finally !!! I've been looking for this for years
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!!!
Excellent Learning Point and Source.Thank You Gary.
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
This is SOOOO helpful! Thank you! And I know very little about accounting. Great video.
Best video on numbers on youtube, thank you
This was so helpful, thank you so much for all your videos.
Gary thank you for all your explanation. I have a question. Can I link cells from different folders in to a table?
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
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..
I'm going to make my teenagers watch this video. Better than a whole semester of econ.
Very clear and straight forward, thanks a lot.
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
THANK YOU THANK YOU THANK YOU!!!! This video was so helpful.
THANKS SO MUCH FOR THE AWESOME INFORMATIONS YOU SHARED
So may thanks Gary ... really interesting video, a lot to learn ...
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 🙏.
I come back here every year 🤣🙋♂(usually cursing SUM...IF)
Thank you this was very helpful.
Thank you for the excellent video!
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 😂
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.
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.
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
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?
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.
Create the template as you like and there is a command in the File menu to save it as a template.
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
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.
Thank you Gary. You inspired me to create some other spreadsheets that would help in my day to day work productivity. Much appreciated 🙏
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.
Have a year column and a month column. Add two filters, one for each column.
Man, you rules! Thanks a lot for all
Really useful stuff thank you Gary
uyeah... nice nice... thanks a lot 💐... is there a posinility in numbers to scrape tables?
Such an awesome video!! thank you for the knowledge you're sharing with all of us!:)
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 …
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
@macmostvideo I got the same situation. Any fix yet? #macmost #macnumbers
THANK! YOU!
Thank you for this tutorial!
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
What time? The video is 47:25 long. At what time in that are you asking about?
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.
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.
Remember to turn off the filter before adding new rows.
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. 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.
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.
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
Me too.
Awesome. Thank You...
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.
Missed it , but thanks for posting it :-)
Great, great, great. I shall pronto get after creating one, instead of paying for apps that do pretty much the same.
Sumif does not populate after entering in conditions (for me at least.) It leaves totals at zero. I used sumproduct instead.
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 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)?
You can set it up any way you like. Use this video to learn the basics and then expand on that.
This guy is the best
Could u use a lookup kinda deal where u can search a specific date or number and find that part of the spreadsheet?
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.
Can you create an addition to they video adding a new page with payroll specifications as well?
Weird. I'm following along at 17:55 to make the two expense summaries but when I click to sum the whole column for the expense summary sheet on footer line 2 it wants to add the whole column *including* the footer, instead of everything above it.
Make sure you click on the right thing to specify the column, or just type it.
@@macmost I seem to be. I click exactly as he does.... hmmmm
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.
th-cam.com/video/r_RRpZhUCzQ/w-d-xo.html
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. ;-)
No you should always only add rows when the filters are off.
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)
How would you incorporate this with a Invoice?
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
Check the cell references carefully. Make sure it is referring to the correct cells.
Thank you
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.
Really helpful. Thank you!
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
Can I split a columns so they have sub columns?
Hi Gary Please help! DATE, CATEGORY, SOURCE, COST OF GOODS, RETAIL PRICE, PROFIT, DESCRIPTION. I've been watching your videos for years thanks for the hard work. I'm a small business. Can you please explain how to figure out the profit please please Thanks Mariam
Not quite sure what you are asking. Seems like a basic business question. If the price you sell something for is "retail price" and the price you buy it for is "cost of goods" then subtract the second one from the first, right?
this was so helpful. thank you!
Awesome spreadsheet! How do you suggest we keep track of receipts? Can you create a columns to import or take a picture or scan a receipt? Thank you.
Hi great video, is there a way instead of having the summary divided into each tax year, to have it between two dates? My business year is 5th April to the 4th April the following year! Very new to this but any advice would be greatly appreciated.
Something like this: th-cam.com/video/p1tqSLkxHdA/w-d-xo.html
Hello! Thank you for your video. How can you import bank transactions into this spreadsheet for Mac.
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.
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.
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.