Learn Apple Numbers for the first time on a Mac
HTML-код
- Опубликовано: 26 сен 2024
- #Apple #Numbers #iWork
Former Apple Store Creative Frank Funk discusses the basics of Apple Numbers for beginners making spreadsheets and formulas.
ApplePodcasts: apple.co/37Z2VDW
Spotify: spoti.fi/3oV36pR
Stitcher: bit.ly/3kL0lVG
Google Podcasts: bit.ly/3e5GFJv
Pandora: pandora.app.li...
Amazon Music: amzn.to/3e4d2Z2
Twitter: / thinkdiffpod
Facebook: / thinkdifferentpod
LaunchpadDM: www.launchpadd...
From the perspective of former Apple Geniuses and Creatives at Apple retail, we aim to enrich our listeners with personal customer stories. Also, coverage of Apple news, live reactions during Apple Events, and so much more. We love to educate and talk about everything at Apple. We challenge you to Think Different.
An excellent introduction to Numbers, delivered in clear, plain speech. Thank you 🌻
This was so helpful. I’n new to the MAC platform and it was stressing me out that I couldn’t figure out how to use numbers. I really hate Google sheets and since I didn’t want to pay for Excel, I figured Id have to learn Numbers. I learned so much in this short video.. thanks so much.
This is great feedback. Thank you! Watch our other content like Pages!
Wow, this was great training for numbers in mac. Love the speed in his voice and was clear and kept it simple. mac is already hard to understand it its self so is nice to find someone who can explain it without rushing
Wow what a great complement!
Loved this! Simple to follow-to the point without a lot of fast talk!
Thank you SO MUCH!! I was initially intimidated, but I didn’t give up! Your pacing of this tutorial was top tier!! 🎉🎉🎉😅
Thank you. Trust me. This is easier then you think. We have many more videos in our Numbers Playlist.
Where is my (THAT WAS EASY) button!?
EXCELLENT PRESENTATION!!! This is really great for someone who is both math challenged and computer "semi-nude", like me. My fiancé and I will be moving in together soon and this is a great way to track expenses and see where are money is being spent. Wish you gave raveling seminars.
We are planning to do more training video.
Thank you for carefully showing some basics for getting started with Numbers. Please, do more instructional videos with Numbers. I'm needing help with a spreadsheet for yearly expenses and income, and am stuck at showing categories automatically updating totals.
Great idea! Thank You!
Thanks a lot! It’s the best tutorial in RUclips! It’s simple and practical! Please create a tutorial on formula functions especially multiple sub totals in a column.
Thank you for the feedback! We are planning to make a short video on this. Thank you for the advice.
Perfect basic summary for those who have experience with spreadsheets. I know excel really well, but there were a few nuances I learned here that were helpful.
Happy to help!!!
Great. Step by step.... and for beginners. None of that speed-induced or rushed AI language. Thank you!
Thank you very much for the feedback!
Thanks for introducing me to Numbers on my Mac :)
You are welcome.
Love this & would like to have more so I can learn to use numbers more efficiently
Check out our recent video.
Thanks I appreciate it this video really got me on my feet using Numbers again and yes I would like if you made more videos on Numbers because I love the way that you explain it step-by-step so I simply thanks
Thank you for this awesome feeback
Great information for this old man just starting to use a MacBook Pro
I am new to MacBook bandwagon and I find your video tutorial really helpful! Thanks a lot! :)
Our pleasure
This has been helpful. I use Numbers but saving is ALWAYs a problem!
We are happy to help!!!
@@APPLE1TO1 but I need more help
Wow. I just learned so much in 9 minutes and 32 seconds
Thank you!
Thank you so much for this🙏🏻really helpful as a newbie in Mac❤️
Thank you so much!
Got to admit that I am a relative newbie to using Mac OS as well as using the in-built 'Apple Office' offerings. I am an IT professional by trade and have extensive knowledge of Microsoft Office. I thought I would give the Apple apps a try and I am quite impressed. I was slightly disappointed with the lack of a mail merge facility in Pages however I believe that there's a good reason for that in that Apple wants to move away from a paper based office. In all however, a decent collection of free tools which can all very easily be exported to Office compatible applications. Great tutorial albeit basic but so far so good.
Thank you for the feedback. I agree the Mail merge would be a nice feature but it is free compared to 150 bucks a year.
Amazing tutorial, you got my like bud. Thanks!!!
Yeah, it was great! Thanks a bunch. I’ll look out to see what else you’ve done with numbers. I’m having a bit of a struggle with adding and deleting rules, and increasing the width of rows 🙏
We have a whole playlist that can help with that. It's a drag and moving the rows. Also, you can click the arrow to fit the content. Rules we have a few videos that might help.
Numbers is wonderful spreadsheet app easy to use for first time learners.
Wish Apple could add more modern Excel formulas and bring some desktop features to its mobile devices
What desktop feature is missing you like?
thank you for making this video
My pleasure!
@@APPLE1TO1 is it the same with iPhone
Thank you so much I’m learning how to use my Mac and this was truly my speed! Yes please do more vids like this!
We have: ruclips.net/video/sHRrtFRQT44/видео.html
Great video! Watching this in 2022 👍🏼
Thank you very much for the feedback! We have more videos in the works.
Omg , thank you. I’ll probably watch 5 more times
Love that feedback. Thank you. Many other numbers videos to see.
Hi I bought my iMac last July and it has taken this long to fathom out how I can generate a spreadsheet for expenditure etc... I will give this tutorial a try. I am a novice at 65 so will let you know how I progress.. Can't wait to get started.. 🤞🏽
Wish you a lot of luck. There are templates you can find online to help. Just google Apple numbers expense template.
Thank you for inspriing us to make this new budget video: ruclips.net/video/FuEctkAKuas/видео.html
Thank you for the video!
Glad it was helpful!
Thank you for sharing with us. Your lesson is very clear and well-paced.
Thank you very much. I hope the other lessons we provide give you that same feeling.
Very helpful, learned right away and applied to my task
Happy to help. Thank you
great start for me thanks!
Your welcome. We have a whole playlist on numbers
Thanks so much! I’ve been battling with this today, I wish I’d seen this earlier!
Thank you very much for the feedback
Wonderful. Thank you!
Our pleasure!
Thank you so very much ❤
Happy to help!
Thank you, a newbie here, very clear and focused on the information. Well done.
Thank you for the feedback and we already have another numbers video on the channel and more to come.
Thank you
Very helpful
just what I was looking for thank you
Happy to help!
Thank you!
You're welcome!
thank you this was SO helpful
Thank You for the feedback.
This was incredibly helpful. Thank you so much!!!!!!
Thank you for the feedback
GREAT simple training - fantastic! Thank you.
Thank you for the feedback!
Extremely helpful video!! Allowed me to "blow the dust" off of my brain much faster. :)
You are welcome
Great Tutorial! Thank you. I think the error was because you didn't click enter, Is that right?
You are welcome. We believe that's the reason.
What a great video! Thank you for making this tutorial!
Thank you very much
Thanks!
Wow Domenick! Thank you. merry Christmas.
This was very helpful. And Yes please, may I have another one Sir!
Thank you. We have a whole playlist, dedicated to numbers
@@APPLE1TO1 Yes, I am watching another one now. I am specifically looking for a help video that gives clear examples of how to use the tool bar “copy style” tool and then the “paste tool icon”. I must be doing something fundamentally wrong, because it rarely works for me. Do you have a video that covers that?
@@nickt2159 we don’t have a video on this but going over the ToolBar is a good idea for a future video.
Great video, thanks!
Thank you David!
THAT WAS AMAZING..
Awesome! Thanks!
Thank You Frank for this amazing, super simple video. Really help me and my daughter with her first Mac and numbers. We have a question. How do you go backward if you want to exit (numbers) and see your other existing work in numbers. So far we have been closing the current page that she may not be done, needs to come back to, closing it (red dot upper left) and just opening numbers again(clicking on the icon in the bar section below) to find another needed. On a regular PC, we just click backward to see all other projects/work in files/folders.
When you have an existing spreadsheet open and you want to retrieve a different named spreadsheet just click on “spreadsheets” in the upper left hand corner. It will take you to the recents and select the new sheet you want. That is on an iPhone or iPad. If on a Mac go to file open new or open or recent
great video! super helpful! thanks
Thank you. We have a new video coming out today to expand on numbers.
Excellent job! Thank you.
Awesome. Thanks
is there a way to subtract a number form the total? for example my subtract my overhead from the total profit for the month?
Yes, without seeing your spreadsheet i would suggest adding a row for "Overhead" and place it either before or after your "Total Profit". I would format that cell as numeric with negative number shown in red. Your "Total Profit" calc should reflect the net of profits less the negative number of overhead
Can we export the Academic Calendar on Numbers to CSV file without scattering the pages?
Likely not. There are multiple formulas and tables. It’s very difficult to do this. Using the regular calendar app may result with what you are looking for.
Or I would select only the items you need to export and see if that works.
I can not read (see)the top or the left side of the "page" after the first few minutes. (see)
Awesome!
Thank you for the feedback
How would you work out VAT automatically on this on a expenses spreadsheet though?
Great question. I found this article. Let me know if this helps: discussions.apple.com/thread/6349482
Thanks 💕
You're welcome 😊
Excellent! Thanks!
You Are Welcome!
How do you go back? Once your in your spread sheet but want to go back and look at another one how do you go back without closing the whole app and starting over?
You can go to the menu bar at the top and do File>Open. File>New if you need to look at another template.
to the left of column A, is a numbers line. the number 1 is located in the header. How do I get the number 1 below the header? Also, lets say i have a number of bills on the first of the month, how can i put those in the number 1 cell?
It doesn’t work like that you can add a header above it but I will always be known as column one row one. Also this might be difficult to answer with this specific question without doing any kind of zoom.
is it able to handle a lot of rows like for example over 1000?
I seen videos showing 70000 rows
how can i make a cell auto-expand to fit a lot of text? Can't find the answer anywhere!
So under the text section under format, there is a section called wrap text in cell. That will adjust based on the size of the cell.
Very good for true beginners. Do you have a video that explains numbers vs. excel? I’m well versed in excel and I’m trying to move to numbers.
Def something we could create. I think numbers is real easy for basics of tables. Excel will be more compatible with more functions you use. Numbers having a check box and pop up boxes make it very unique but doesn’t work in excel for example.
Great video! Maybe a redundant question or I just missed it, but how do you incorporate paychecks with this spreadsheet?
You have to manually enter items.
you're the best
We aim to please. Thank you.
How do you get to templates in an IPad ?
ok, open numbers, click omn the + sign in the top menu. That should put you in the "
Choose a Template" area. thanks for the question
How do I Export a document to an email that someone else can open?
When you go to File, Export to, choose the format you want. There are options for PDF if you don’t wanna have another person edit the content or Excel if the other users are Windows based.
Thank you!
You're welcome!
I do not have grid lines. Any ideas?
I would need to look at the file. But highlight the table. Go to format. The grids line options are there.
So, after you entered 1500 the 1st qtr. column updated by adding the 1500 to the other column. But, how did you configure it to do that?
What if you didn't want to add them together?
When there is a value in 1 cell, you can go to another cell hit the = sign, and select that cell. it will be the same. You may need to explain this a little better so we understand the question
Please show us how to arrange a text vertically in a cell - I m not able to get TXT of the cell vertically
The best way is to create a text box and change the angle. Then copy and paste to fill in the spots. There is no easier way I found.
@@APPLE1TO1 n how to make TXT box in numbers application in my ipad
How do I make a cell wider?
support.apple.com/guide/numbers/resize-rows-and-columns-tan3e89d0c0f/mac
how do i change the background color on 1 cell
Click on the Cell - Under the format button on the top right choose cell, Fill. Choose your color.
@@APPLE1TO1 cant say thank you enough
Hi mate can you please help me with this ( I wanna to letter X to equal -25)
Thanks
Use substitute formula: discussions.apple.com/thread/251305811
@@APPLE1TO1 sorry I didn’t understand it as I’m not expert in numbers.
I want to write in cell # 1, how do it!
I don’t understand are you talking about A1? Just click there
@@APPLE1TO1the 1 on the numbers line is on the header. I want the header to be above the number 1. I’m using the numbers line to correspond with the days of the month. If I have a bill on Jan 1, I want to put the name of the biller next to it.
Show what you are saying on the screen at the same time.
I can only see "choose a template."
The pictures on the page "choose a template" have such small printings of letters I can not read them.
Also use a pointer to show where you are reading .
Thank you for the feedback. Perhaps you can find a channel that better suits what you are looking for.
How do I get rid of the page number on my spreadsheet. I didn't add a footer. It only shows up when I click on Print. I cannot find anything on the format side bar about page numbers? Help.
support.apple.com/guide/numbers/print-a-spreadsheet-tan0f8a5f969/mac
hey, is there any way to export data from a pdf sheet to mac numbers? (without using any third party software)
Afraid not. You will likely need Adobe Acrobat for something like this!
You can try to copy and paste as your free option.
Enjoyed your tutorial very much. I am having a problem and can’t figure out how to get around it. I have one column that sometimes has a Roman number in the cell. If I type in 224/2 and return it changes to 112. If I type in 224/1 it changes to 224. Any ideas, thanks?
Jan if I am understanding your question correctly. 224/ is telling numbers to divide 224 by the number after the slash in this case 2 which equals 112. When you key 224/1 the result is 224.
If you don’t intend to divide just key in the whole number and hit return
If you are trying to key a Roman numeral the cell ir column should be formatted as alpha not numeric. But all Roman numerals are letters so it will default to alpha.
Hi how I can make it show for example if something is valued at 0.10 and there is 1000 pieces of them, so the total worth is 100. Can I can make this?
Or how I can make it to add +1 % for example if I have 1000 on the A , how I can make it show 1010 (+1%) on the row B?
Please email thinkdiffpod@gmail.com and we have an answer for you.
Hi Frank, is it possible to save a spreadsheet in numbers as a jpg or jpeg? I need to use one in iMovie. Thanks!
So the best way to do that is making a PDF. Then open in preview. Export as Jpg
Thanks for the quick reply! @@APPLE1TO1
Grid lines are defaulted in a template. Maybe this article can help: support.apple.com/guide/numbers/change-table-grid-colors-tane80651fe1/mac
this is like sheets from google chrome.
It’s close but you are able to change tables and have multiple tables
I am building a Spreadsheet with almost 200 rows of songs. I want the first song to be in row 1, not row 2. How can I add a row ABOVE row 1 where I can show song title, artist, year, lyrics, etc. (Sep 16, 2023)
If your right lick or 2 finger click. There should be an option to add a row above or below
Maybe I don't understand. Whether I click on 0 or 5, nothing happens ABOVE row #1 Nothing is added
@@quabledistocficklepo3597 sorry but without being there it’s gonna be hard. We have a lot of numbers videos I recommend watching to find more possible clues.
Your answer indicates that you didn't understand my question. No matter; Apple tells me that what I want is impossible to achieve. I can't understand why that should be, but I'll accept that answer. I have no choice.@@APPLE1TO1
Apple tells me that it is impossible.@@APPLE1TO1
0:45 🤣🤣🤣
The joke that is Excel
Where can I find more video tutorials for the numbers app on your channel?
Check out our playlist section and you will see a section for numbers.
You didn't say how you got the little box to pop up in the cell for the = sum to get the total to add up...sorry, I am a dinosaur.
When you hit the = sign, that is the default feature to do a formula.
❤
You need to get this course accurate before you "teach" someone else.
Ok. Tell us what is not correct and we can update it. Very broad statement. 51 comments say differently
Disappointed
In what?
Yawn
You are more then welcome to make your own video and see if you can do it better.
That's not very nice.. For novices like myself it has been very helpful..☺
Thank you so much! Better than a college class!!
Thank you. Check out some of the other videos on our channel with numbers.
Thank you!
Your welcome
Thanks!
That is awesome! We appreciate that!
How do you add a header?
This should help: support.apple.com/guide/numbers/add-or-remove-rows-and-columns-tan504013a74/mac
I can’t see the whole screen (cursor) during the narrative.
What was missing in video that you need to see?
Thank you 🙏
You’re welcome 😊
I've got to take some time to wrap my head around the differences from Google Sheets.
Numbers is better! Simple. And not requiring an internet connection.