After many years with Windows Computer, I switched to an iMac. I stopped using Office and started exploring Pages and Numbers. These videos are a big help to me.
You are a very good, accessible educator, Gary. I know all of this but you have made it accessible to people who may not understand spreadsheets in a really accessible way 👍 Thanks for all you do.
As an older (70's) learner, I appreciated the easy to understand detailed explanations that you provide in order to learn how to create the desired results on what I'm trying to accomplish. You speak clearly and at a good pace so it allows me to stop the video to rewind it or practice implementing what you are saying very easily. Other educators put too many details into one video making it way too confusing to me. Your method of starting with the basics in one video, without going into too much detail, allows me to understand & remember what I've learned before moving on to the next level on the subject. Thank you so much!
Thanks bunches. I have Microsoft 365 subscription on my two iMac as I thought I would never learn to use Pages or Numbers...but thanks to you, I am learning. I am not renewing my 365 as I have Office 2016 on a PC laptop. Again, you have made the journey into Apple enjoyable. And again, I do enjoy your basics video and hope you never stop offering them.
I just found your page and am so grateful! I’ve been looking for simple concise instructions to use numbers and your video are incredibly helpful! Thank you for creating these to help us learn and use these tools more effectively 🙏🏼. You are sincerely appreciated!
You are so bloody good at explaining things. The vast majority of 'teachers' on here always talk from a place where they assume we must already know the most basic things but you don't do that, you explain it from the root to the branch. Thank you very much! This has helped me more than you could know! New subbie! New Like!
Brilliant. You are a great teacher. I have been doing spread sheets, both Numbers and Excel for decades (literally), and never knew about footer rows until I watched this video. Thank you. And you go at just the right speed
At 72 I have transitioned from PC to Mac and now am forced to forget Excel and learn Numbers! Thank you for this basic introduction that has allowed me to build my spreadsheets again! You made it an easy transition!
You're great...I'm useless 😩. Followed your very clear cut instructions....and ...still mucked up and nothing works. All I want to do is make a list of CD Tracks...So Col 1 is Track Nr. Col. 2 is Duration in mins and secs and in the footer row a sum of track numbers and a total duration. You think I made it? NO!!
I am trying to use the IF function to say if the value in a certain column = 0.00, then the value in another column will =0.00 The particular column also has another = function in it. Could anyone show me how to do that?
guys I am really struggling with a project on numbers, I need a drop down menu to populate one of three numbers dependant on certain sequences of answers chosen by 6 other drop down menus
Thank you subbed and liked. Been using numbers formulae for many years. Changed jobs 5 years ago. Totally forgot how to even start a formula. Thank you I am starting to remember again.
I'm new to Numbers. What am I doing wrong? Entering "=" doesn't put me into a formula mode it just thinks I'm entering the character "=" as part of my data. Entering any cell references after that are also treated as just data. (After I wrote the comment above I tried it the manual way you mentioned at the beginning (insert/formula/etc.) and it worked. Now, every time I enter a "=" it starts a formula. Is it normal that you have to use insert/formula the first time?)
Not sure what you were experiencing there. Pressing = with a cell selected should just take you into formula entry mode. Glad it is working for you now.
Gary, another great tutorial from you. Keep it up. Is there any way we can link our eTrade account and portfolio to Numbers which will help to review it from Numbers. This will help to use the regularly updated Portfolio with various Number functions. Yahoo finance allow to link eTrade and thought may be Mac also has some option to link / import portfolio from eTrade
No, there's no easy way to do that. I'm guessing ETrade has some sort of download function where you could get a CSV, but it would be a one-time download and nothing "linked."
The biggest problem with Numbers is the reliance on clicks. Anyone who's used a spreadsheet for more than a week knows to use Tab, arrows, function keys, and other key combinations to maneuver once you've started a formula. Numbers is a toy. Excel is a tool. It's too bad Apple decided to saddle us with a half-finished app like this.
I was surprised you didn't mention using the yellow dot that appears at the bottom of the selected formula cell to drag the formula down several rows in the column. It's quicker than copying, shift-clicking the cells and then pasting.
Because that, and a lot of other techniques like it, just confuse things when you are dealing with "An Introduction To..." video. Got to keep it simple. You can easily add those shortcuts and tricks later on, after you understand how formulas work.
Great video yet again. As a rudimentary spreadsheet user I only know the most basic functions and tend to often do things in a more complicated and labor-intensive manner than necessary. TIL about footer rows. Many thanks for growing my knowledge so painlessly.
What is the formula for entering the next numeric value in a column ? For e.g: If I have a column that needs to be 1, 2, 3, etc can I do this with a formula instead of typing the numbers for each column?
How do you calculate a row of numbers to show the balance at the end of the row if you know what your balance is? Example: If I enter a number of cost, let's say 7 columns that indicate payments. I want the end of the row to show what balance is left. Thx
Depends on how you have it set up. If you have a column that is "deposits" and other that is "withdrawals" then you take the value from the balance in the row above, add one and subtract the other. Repeat for each row.
I wanted to come on here to say thank you so much for these videos! I am a brand new Mac Desk top user. Just bought my very first MAC computer and received it yesterday and I have to say you are an absolute God send! Thank you for your very helpful videos! I am a dog walker and I like to keep a track of the miles I do from each dog walk and this was EXTREMELY easy and helpful to someone who is not very technologically intelligent. HA HA or at least I didn't think I was! Now I feel like a badass getting to use this computer! Thank you again! :-). Happy new year!
Thank you for all the videos! They are all very helpful. I've used Macs exclusively for 30 years and wouldn't change, but I have never really used Numbers but after watching your video, I will. I learn so much from you.
I retired 12 years ago after having to use MS apps for many years. What many do not know is that a few years be before retiring I did most of my work,on my Powerbook and iMac and then converted them to MS format to use on my windows machine at the office. That God for USB thumb drives.
What a great instructional video. Is there anyway of reading a spread sheet with formulas in it and locking the formula so that they can't accidentally be deleted or changed. I don't find this is an issue on a MacBook but do on an iPad when entering data
You can only lock tables, not individual cells. So you'd need to design your document with data inputs in one table and locked formulas in another table.
wow, I wish I would have found you sooner. You have a clear-sounding voice and I love the pace. I subscribed and look forward to watching more of your videos.
I like his information , however he need to slow down a little, He runs through this like a cat with its tail on fire. We know he understands the program, however we need the time to keep up. Thx Wayne
Does anyone know why my percentage cell '2.84%' shows as actual 0.0284? I am trying to add a percentage to a currency amount but it just keeps doing 0.0284, instead of 2.84%.
Hi Gary, 1.000 likes to you. I worked with DOS > Windows > Office for the last 35 years and consequently I became addicted of Microsoft products. Now I decided to jump in to the Apple's ecosystem and I'm really well surprised. Thanks to your tutorials I'm learning really fast this environment - I'm seeing all of your videos. Thank you very much to you Again, 1.000 likes to you. Regards, António
No words can express how thankful i am 😭 i hv to submit a work tmrw and ur video just saved me from days of working with these numbers 😭 thank you a looot
Hi Gary, Is there any way to create a formula on a spread sheet that has a column with a running total as each new row is added? I want to track my mileage and I have one column with date, one column with Job, one column with Miles and then a total in the footer but I want to have another column that keeps adding the previous totals as I enter data so I can see how many miles I drove in a month or a week.
Yes. Do exactly that. So if column E is miles, then F can be a running total. F2 would have SUM(E$2:E2) so then when you put that same formula in F3 it would be SUM(E$2:E3) and so on. The $ is notation for "Preserve Row/Column" which you can set by clicking on the reference in the formula.
Thanks for the quick tutorial… If I work different hours. With different start times. How do I add up the hour’s..? Let’s say my start time today is 03:30 am and I finish at 18:00 pm How do I calculate this using the formulas..? This is the last piece of the jigsaw puzzle 🧩 that I need to solve. Your knowledge & help would be most appreciated… Thank you in anticipation…!!!
Just subtract. If C2 is 3:30 am and C3 is 18:00 pm then =C3-C2 will give you a duration. See ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ap89xT46y2Y.html
Love your videos. Pages will become my preference over word. However, why anyone would use Numbers over Excel completely escapes me. Just the fact you can’t select your print area in numbers is a deal breaker.
As someone who never prints, I don't miss that. Not that you can't do it pretty easily (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YVxLH5Ps9xA.html). But the way Tables work in Numbers makes it superior for me unless I need some special advanced function that only Excel has.
@@macmost Thank you for the insight. I would love to move to numbers also. Paying the fee every year for a couple of home spreadsheets (Excel) and documents (Word) doesn’t make since when the Apple programs are free. I will give both Pages and Numbers a fair chance. I’m very ingrained in the Microsoft programs, coming over from years of experience. These were used by most companies, including mine. However I’m now retired and would love to switch over for home use. No sense paying when I don’t need to. Again thank you for your comment, and your videos.
Hello Gary, hoping you can point me in the right direction. Loved your video on Numbers Budget and I like the person budget template but the one transaction sheet for a year is over wielding, so I want a transaction sheet for each month. I've tried adjusting the formula to accommodate that but just end up with the dreaded red triangle in my cells. Can you point to to another of your videos or other help. Thank you.
I wouldn't do transactions-per-month. Keep it all in one table. Dividing your transactions into months makes it very hard to do calculations on them. Just have one table with all of your transactions, with one per row. Filter if needed. Use pivot tables if needed. As for errors in formulas, it is just a matter of looking at the error message, then looking at your formula and making adjustments. There's no one-size-fits-all solution to correcting mistakes. You need to assess, plan, try things out, repeat.
Thanks again, Barry. As a 75+er coming back after 6 weeks abroad without a computer, I found this invaluable (again!)! It's amazing what you forget at my age. You are so reassuring. Thank you.
Hey Gary. I appreciate your contribution of knowledge towards helping us novices. A question- if I insert a value into a cell, then I want the next cell below it to show an amount 5% higher than that number, how would I create that formula? I’ve tried B3+5%, but obviously it doesn’t work. I’d appreciate any advice. Thanks🤔😵💫 This just in… a friend advised me to try (B3)*1.05. It worked so I’m good to go. Thanks.
Is there a syntax for finding the difference between 2 values? I think I remember using something like =dif ....etc years ago but it doesn't seem to work anymore. While I can type out (for example) B2-G2, it's kinda awkward. Just asking...
How do I create formulas across tables? I have a table with quantities and another with percentages. I want to come multiply the percentages with the quantities to get the totals but can‘t figure it out.
The simplest way is to use the pointer to select the cell. So you type = in a cell to enter formula mode, then click on the other cells to add a reference to that cell. You can click on cells in the current table, but in other tables too.
If you have the formula in every cell in a column (except header and footer rows) and then add a new row (like by being in the last regular row and pressing Return) then the formula should automatically appear in that new row.
For starters, it uses a different design method. You put one or more tables onto sheets instead of each sheet being one big grid of cells. See ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q7QQDlSWZyk.html
@@macmost Thx. I was entering it like 01:48:34 (For one hour, 48 minutes, 34 seconds). In the adjacent cell, I was trying to calculate Pace based on distance ran. I changed the cell entry from Duration to Text and it seemed to work. Appreciate you replying.