Numbers for iPad Tutorial 2019
Vložit
- čas přidán 19. 06. 2024
- This is a tutorial for Numbers for iOS. Find out about the latest features, and powerful tools that make this as impressive as Microsoft Excel.
If this video was useful, please buy me a coffee!
www.buymeacoffee.com/buzzkeil
Support Bit By Byte and follow:
Facebook: / bitbytehd
Instagram: / bitbytehd
Twitter: / bitbytehd
Video Contents:
0:00-0:33 Intro
0:33-0:56 Creating a new document/template picker
0:56-1:31 Adding columns and rows
1:31-2:42 Naming Document/Organising and Renaming Sheets/Duplicating Sheets
2:42-3:15 Entering data
3:15-6:01 Table Customisation/Freeze Rows and Columns
6:01-7:39 Cell Formatting
7:39-8:12 Undo/Redo
8:12-11:00 Conditional Highlighting
11:00-11:28 Cell Data Format
11:28-15:15 Sliders/Steppers/Pop-Up Menu (Drop-down)/Tick box/Star Rating
15:15-18:05 Cell Actions/Date/Time/Formula/Stocks/Comments/Quick Filter/Quick Formulas (Sum, Average etc)
18:05-21:32 Column Actions/Sorting/Filters (Advanced options)/Smart Categories/Hide Column/Column Fit/Resizing Columns
21:32-22:27 Add a Table/Move/Resize
22:27-26:03 Adding and Editing Graphs/Selecting Multiple Columns/Graph Templates/Interactive Charts
26:03-27:29 Adding and editing shapes
27:29-28:29Adding and editing images/video/audio
28:29-29:49 Drawing/Edit Drawing/Animate Drawings
29:49-31:44 More Menu: Collaboration/Sharing Options/Export to PDF, Excel, CSV/Printing/Find (and Replace)/Settings: Author Name, Autocorrect/Password Protection
Like this video? Click the link to subscribe!
czcams.com/users/TVTechTe...
My Gear
Main Camera (Panasonic GH5)
US: amzn.to/2DmyEMw - UK: amzn.to/2BLjvEi
Second Camera (Leica D-Lux Typ 109)
US: amzn.to/2zDJtrq - UK: amzn.to/2l9MzyX
Tripod (Manfrotto 190 GO!)
US: amzn.to/2DmM23d - UK: amzn.to/2l9bceY
Fluid Head (Manfrotto Pro Video Head)
US: amzn.to/2zEw2au - UK: amzn.to/2zDPjcn
Lighting (Neewer Bi-color 480 LED)
US: amzn.to/2CeuwPr - UK: amzn.to/2E2AoMc
Outdoor Mic (Rode VideoMicro)
US: amzn.to/2E4XC4s - UK: amzn.to/2zEQ1G4
Audio Recorder (Zoom H5)
US: amzn.to/2zEhtnq - UK: amzn.to/2zEEIhf
Main Mic (Zoom Stereo Shotgun)
US: amzn.to/2BKjsIV - UK: amzn.to/2Cf2JhX
Mobile Gimbal (DJI Osmo Mobile)
US: amzn.to/2DoEAVn - UK: amzn.to/2CeuF5C
Get 20GB of FREE cloud storage: copy.com?r=luz428
Get $30 off your first year of hosting at DreamHost: goo.gl/Q1597p
Use the Promo Code: TECHTECH30 - Věda a technologie
If you liked this video, I would be *incredibly* grateful if you subscribed! Let me know if you did in the comments below, always good to chat to new people! :)
If this video was useful, you can leave a tip on my Buy Me a Coffee page: www.buymeacoffee.com/buzzkeil
For someone is barely versed in PC/Excell use, you explained moving to an Ipad/IOS and using this program very easily. Thank you for taking your time and organizing this tutorial as you did. This prepared me well as a beginner.
Very easy to understand...
As a builder, I have enquiries and surveys through to completion, needing to know materials and labour as a constant. This tutorial is helping me to formulate an overview and immediate picture of ‘the state of play’ at any one time.
Very helpful indeed 😀
Fantastic! Glad it was useful!
I need to compile a budget for a restoration project, this video really helped me get to grips with the awesome facilities available in numbers merci mille fois.
Excellent tutorial. You have provided a clear top-down picture of its function, with the right level of detail. Thank you!
Very nicely explained. I can understand the amount of time that goes in planning the tutorial and recording. Thank you
Fantastic! So easy to understand and comprehend. I would love to see a video on formulas, maybe just the basics, budgeting types etc 😊
Thank you for the iWork tutorials! It's really understandable and helping despite the changes that Apple apparently did throughout this year.
Up to now I have used Excel, your tutorial has helped me to get my head around Apple’s Numbers. You have an excellent teaching approach - THANK YOU!
Amazing tutorial! So helpful, thank you very much for taking the time to make this. 🤗
Outstanding content. Having being forced finally to switch from Excel to Numbers due to an unwillingness to subscribe to Office 365, this was by far the best i came across on YT. Well done!!
Great tutorial! All you need to know to start using Numbers.
Thank you for this video, easy and simple!
Thanks - I got my answer. I wanted to sort tables. Your table of contents in the description was very helpful.
You are a gifted teacher. Thank you.
Great tutorial. Looking forward to checking out some of your others.
Fantastic! Just what I needed. Thank you👊
Thank you for doing this! This is great.
Thank you...extremely helpful.
Excellent tutorial. Thank you 😊
I just got an iPad and have never used Excel or Numbers (just Open Office) so this was incredibly helpful. About the only thing that was not covered in this beginner tutorial was how to take a cell/formula from one table and link it to another but I'm sure those kinds of questions would be covered in a formulas video.
Thank you for this video!!! Very Helpful!
At last a tutorial that I really understood. Thank you so much.
Don’t ever delete these. Thank you! Helped greatly for startup business. Can we add tables to a keynote slide? (will check your keynote tutorial)
Great tutorial!
Could you do more videos about Numbers?
Amazing work my friend!
Thank you a lot for taking your time to explain. It helped me a lot to get started with numbers on my iPad.
Glad it was useful!
Thank you for the video.
Great video. Needed to see this video highlighting Numbers on a iPad. Seriously looking to convert to iPad from older generation MacBook Air. Like it! I use Numbers App extensively.
I always like to see videos of whatever it is I am trying to do. I do read the help menus, but I feel I still like to see the how to do. I have had the numbers app for a very long time and made many spreadsheets, however, I have never used it to its fullest ability. I really enjoyed this video and think it will help me a lot. Thank You.
Very informative. I’m using my iPad for my computer and ditching the PC. I’m new to numbers, and figured out dome things myself, but this was very informative for beginners. I just subscribed….just watching this video and playing with numbers, it is so much easier than excel. Any more tutorials would be appreciated. Rock on! 👍🤙🤙🎶🎶🎶
Just what I needed to improve my spreadsheet content. Subscribed
Thank you it was very useful
Great content and simple explanation. Thanks 🙏
Great work bro, thanks 🙏
Very useful video. Thank you very much!
Thanks you ! Very good explication 😃
Absolutely brilliant
Great video thank you very helpful
Thanks very nice description
Great information! Please make more tutorials for iPad. Like how to use the checklist function in numbers and connect your list to forms and graphs. Also, for anyone using the touch screen to get everything done on iPad, how to you make it function better so you are not having to press buttons serval times. Lastly, it appears that editing websites on platforms such as Go Daddy and Wix, as well as using Teachable, is very challenging on the iPad. Actually a lot of websites and apps don’t function well on the iPad. Any solutions for that? Thank you for all time, effort and expertise!
Good One. Thank You.
Excellent explanation of numbers
Thank you very much, there's more here than I can chew, but I coould go back if I needed. You are very kind, and an excellent teacher.
Thanks, nice tutorial.
Excellent video. Thank you for your helpful
Grateful I’ve found you! Still very new to iPad and even though a lot is over my head, your calmness helps. Could you maybe work through a more simple spreadsheet for a non business person-like for phone numbers and emails, birthdays, or recipes? Thanks.
Mahalo! So much easier to understand than Excel. You're an awesome teacher!
Thank you for this video. And I have subscribed.
Thank you 👍 made that a lot easier for me
Thank you!
Thank you for a solid video : )
Fantastic and thorough basic usage. Thank you.
Can you please do a tutorial for graphs, using trend lines/ line of best fit with equations? I recognize that this is not a mainstream request, but many universities sell Apple products but the assignments all use Microsoft products. I’d like to be able to do lab work on my iPad as well. Thanks!
Outstanding!
Very good. Thank you.
thank you very much
Just came across these video tutorials and they have helped me out a ton! Do you know of any free resources like this for iWork suite on the Mac? Considering saving myself some money from paying or Microsoft suite and just using these to see how they fit my needs. Thanks for the great video!
Definitely liked and subscribed!
Thanks!
Thank you.. This was very helpful. I was trying to get the filters options and was splitting my hair.
Great video, made simple & concise! Lots of very useful tips, however what I’m really looking for is... with respect to the “Personal Budget” template, I’d like to add &/or edit the categories which are linked somehow to the graph, any help would be very much appreciated!
Excellent. New subscriber
Did not quite cover all my questions but still very useful.
Nicely explained …..
This is the best Numbers tutorial i have seen yet! Well done
Thanks so much!
Easy to follow video :-)
Thanks for the video, very helpful. Is there a way to fix your document, chart or graft so it doesn’t move left to right when you touch it?
Very good basic tutorial. I am trying to find a way to outline or shadow text. I found how to do it for objects but have been unable to figure out how to do it for text
- helpful and easy to understand
Thanks!
Hi, super video although it leaves me with a question ; how do I close a sheet when I am finished with it and then I want to open a new sheet or an earlier document I have previously worked on . Thank you 😁👍
Thanks for your video. It’s very informative.
May I ask if numbers can make pivot tables from a table? And any add-in to work with like, Smartview for HFM, etc? 🙏
Fantastic video, learnt so much! Explained so well! I do have a question, I may have missed these instructions but I enter several comments in the same column and keep having to go up and down to find the comment I need then copy and paste it into the cell. Is there a way to have the sheet recognise when I start typing a comment that I’ve written the comment before and automatically autofill the cell to save me copying and pasting? Thanks so much 😊
Excelente video for rookies!
Thanks
Thank you very much for this tutorial. I am switching from Office to iWork and the series has been most helpful. Keep up the good work.
Thanks!
Thanks for the tutorial. Is there a way to scan a barcode and/or a picture into a Numbers spreadsheet?
very good explanation
Thanks!
Could you review the office apps for iPad pro
Hi thanks foe explaining. Please explain , how to highlight specific filter.
Thanks for posting this great tutorial. iPad Specific: Maybe I missed it, but please can anyone tell me how to apply a formula to a whole column (on iPad).
Hello! Very good video, do you know how to export only selected cells? Sometimes i don’t have to share all the sheet, only one part. Thanks
Thank you very much. Found this very useful.
Thanks!
The most beneficial tutorial I have found for this! Is there a way to change the colour of the comment indicator?
Thank you very much for making these wonderful tutorials and for putting in the time to make them so organized and very well presented. I have a question, if you don’t mind. I am using a bluetooth keyboard as well. How can I select cells or columns that are not direct neighbors of one another? Another one is; how do you merge cells, rows or, columns? Thanks again. Brilliant work.
The last time I checked, this wasn’t possible in the app.
It appears you move around the spreadsheet with a mouse device. Is that the case and if so, which one? Thanks.
This is cool. Apple made this more powerful than I originally thought.
Glad it was useful!
Hello, i couldnt find the short cut of command+shif+c and v cell format copy on ipad, do you know that is it possible to do this without keyboard?
I really find your video very informative but as a beginner on iPad number I am struggling with spacing when typing two word on one cell
Can you please tell me where to find actions for bullet points and list? Thabk
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 wish having the photo cropped inside the ROW & upon clicking on it, a nice pop up window would come up and blowing the picture larger and then clicking it again to minimize the picture back into the row...
Hello,
How do we copy the style of a cell and apply it on other in iPad or we can say copy the format and apply on other cell?
Hey! I've been loving these videos and found them really helpful. I have one question though : What iPad are you using for this video ?
At the time of making this video, I was using a 10.5” iPad Pro
Buen video, como puedo arrastrar una fórmula creada en una fila pero quiero arrástrala para las filas de abajo , sin usar el mouse ?
Hello, how can I make a table of students' grades in the numbers program on the iPad. I hope to clarify the steps plz
Is there any way at all to have a sum formula subtract instead of add? Or multiply?
Hello, can you help me? How can I divide all the values by one number and find the result quickly in the application numbers, stress=force / area , I have all values of force and the area constant
At around 6:38 the 5 entries you have below item suddenly are all selected. How was that done?
Hi, I have my mane sheet with many working sheet in it. When I use my MacBook and I put my arrow on the mane sheet title, all the working sheet appear and I can select the on I want to use. But with my iPad Pro, it doesn’t work. Do you have I idea what can I do to fix my situation. Thank you and have a nice day.
Hi. I use icloud to access apple programs for work. When using numbers, it works great, but when I convert to pdf - it just turns my doc into a super long 1 page document instead of different additional pages.
Also doesn't allow me to use enter to type in the same cell just a new line. Any help?
Is it possible to create vertical text on iPad?
Hi
I like your tutorial, how do I get on this spreadsheet
Hi, how can I add autofill serial numbers in a particular column?