Numbers for iPad Tutorial 2019

Подписаться 36 тыс.

Просмотров 241 тыс.

50% 1

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!
ru-vid.com...
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

Наука

Опубликовано:

22 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 197

@MKMTG 3 года назад

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

@theresajansen34 3 года назад

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.

@mikelyonstiling 5 лет назад

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 😀

@MKMTG 5 лет назад

Fantastic! Glad it was useful!

@stephaniecramer4025 5 лет назад

Fantastic! So easy to understand and comprehend. I would love to see a video on formulas, maybe just the basics, budgeting types etc 😊

@d2cgator120 4 года назад

Excellent tutorial. You have provided a clear top-down picture of its function, with the right level of detail. Thank you!

@simonfrankish7404 2 года назад

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!!

@mikep6843 3 года назад

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!

@frankyfernandes6283 4 года назад

Very nicely explained. I can understand the amount of time that goes in planning the tutorial and recording. Thank you

@chumbawunga1 4 года назад

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.

@TomOnTheRun Год назад

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.

@loeki66 4 года назад

Amazing tutorial! So helpful, thank you very much for taking the time to make this. 🤗

@louderone6042 2 года назад

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! 👍🤙🤙🎶🎶🎶

@edcleaves3957 3 года назад

Thanks - I got my answer. I wanted to sort tables. Your table of contents in the description was very helpful.

@shamanbeartwo3819 9 месяцев назад

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.

@michaelamar7341 4 года назад

Thank you for the iWork tutorials! It's really understandable and helping despite the changes that Apple apparently did throughout this year.

@ruthhennessey4754 3 года назад

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.

@karenragan8333 4 года назад

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.

@markchristmas9698 4 года назад

Great tutorial. Looking forward to checking out some of your others.

@beck8590 3 года назад

Thank you for this video!!! Very Helpful!

@micheleleonidas9206 4 года назад

Great tutorial! Could you do more videos about Numbers? Amazing work my friend!

@christianacosta8035 2 года назад

Thank you for doing this! This is great.

@sunshinebest4432 4 года назад

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!

@roxanagarcia2849 4 года назад

Thank you for this video, easy and simple!

@computer__eyez 4 года назад

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)

@markharris7804 4 года назад

Fantastic! Just what I needed. Thank you👊

@vkchopra1 3 года назад

Excellent explanation of numbers

@Debelebekele 2 года назад

Great work bro, thanks 🙏

@89yamid 3 года назад

Great tutorial! All you need to know to start using Numbers.

@nigelcaughey2119 Год назад

Just what I needed to improve my spreadsheet content. Subscribed

@5satya 2 года назад

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.

@eduardaklaser 4 года назад

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!

@arthurmurfitt7698 2 года назад

Thank you for this video. And I have subscribed.

@johnevans2328 5 лет назад

You are a gifted teacher. Thank you.

@seanb1081 4 года назад

Excellent tutorial. Thank you 😊

@nicklee2872 3 года назад

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!

@guggle86 4 года назад

At last a tutorial that I really understood. Thank you so much.

@norbertkalff2176 5 лет назад

Thank you a lot for taking your time to explain. It helped me a lot to get started with numbers on my iPad.

@MKMTG 5 лет назад

Glad it was useful!

@kolay_aslinda 3 года назад

Great content and simple explanation. Thanks 🙏

@karen96734 2 года назад

Mahalo! So much easier to understand than Excel. You're an awesome teacher!

@duncanmeechan5694 2 года назад

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 😁👍

@albertorodriguezramos1278 3 года назад

Very useful video. Thank you very much!

@justelementt1538 4 года назад

Thank you...extremely helpful.

@pkmanny3325 5 лет назад

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!

@stinki97128 4 года назад

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

@albertleung8789 2 года назад

Thank you for the video.

@plebpunk 10 месяцев назад

This is the best Numbers tutorial i have seen yet! Well done

@MKMTG 10 месяцев назад

Thanks so much!

@mfdriscoll2501 3 года назад

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?

@AJ-ye3nq 3 года назад

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? 🙏

@blueyesterday3920 2 года назад

Definitely liked and subscribed!

@MKMTG 2 года назад

Thanks!

@BDESAI777 2 года назад

Hi thanks foe explaining. Please explain , how to highlight specific filter.

@JohnGarciaLandryGamingChannel 4 года назад

Excellent video. Thank you for your helpful

@maheshmp6901 3 года назад

Thank you.. This was very helpful. I was trying to get the filters options and was splitting my hair.

@bellohob1532 5 лет назад

Thank you it was very useful

@cosmeticaytratamientosfaci682 4 года назад

Thanks you ! Very good explication 😃

@azimuthvega 3 года назад

Thanks, nice tutorial.

@ismat315 2 года назад

Thanks very nice description

@rachelheath1208 3 года назад

Thank you 👍 made that a lot easier for me

@markwhalenschoolofmotoring 5 лет назад

Great video thank you very helpful

@devanarayanas3694 4 года назад

Good One. Thank You.

@stevesimos2861 4 года назад

Thanks for the tutorial. Is there a way to scan a barcode and/or a picture into a Numbers spreadsheet?

@juani1065 5 лет назад

Absolutely brilliant

@thandazanidube6325 2 года назад

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

@phunt1769 Год назад

Excellent. New subscriber

@EstonianBerserker 3 года назад

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...

@Lilxo_22kl 3 года назад

Hello, how can I make a table of students' grades in the numbers program on the iPad. I hope to clarify the steps plz

@michaelirwin4347 2 года назад

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 😊

@sirinatpornvisutrakul6963 4 года назад

Thank you for a solid video : )

@fernovaro 3 года назад

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

@lindadeak7094 2 года назад

The most beneficial tutorial I have found for this! Is there a way to change the colour of the comment indicator?

@donjohnson4635 6 месяцев назад

It appears you move around the spreadsheet with a mouse device. Is that the case and if so, which one? Thanks.

@mehmetaliertan 3 года назад

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?

@gtsam1860 5 лет назад

Could you review the office apps for iPad pro

@omarafricano 2 года назад

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 ?

@hassanwithclash18 Год назад

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

@09824982254 3 года назад

Nicely explained …..

@AjayChauhan-wk9dc 3 года назад

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?

@MrMustang1958 4 года назад

Very good. Thank you.

@arielcromwell 3 года назад

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).

@nthused 4 года назад

Outstanding!

@krishna2641 Год назад

thank you very much

@adelenenaidoo1558 Год назад

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?

@carlboulianne4284 3 года назад

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.

@christosvolikakis1523 2 года назад

How do you change cell size format from points to inches and numbers ON IPAD/IPHONE???

@jackw2894 Год назад

Can you please tell me where to find actions for bullet points and list? Thabk

@lorrainetaylor-bogle9946 4 года назад

Thank you!

@fidasaleem1954 2 года назад

- helpful and easy to understand

@MKMTG 2 года назад

Thanks!

@Maheshkumar-hz2nk 2 года назад

very good explanation

@MKMTG 2 года назад

Thanks!

@thelowmein9143 4 года назад

Did not quite cover all my questions but still very useful.

@eugenegeorge1857 5 месяцев назад

How are you dragging down cells. When I try in iPad it just move the whole table.

@PsychoCookiie Год назад

How do you simply paste the formatting from one cell into another cell? The Apple userguide says to click the "Style" button, rather than copy but I don't see any "style" button.

@VipinChauhan247 Год назад

I cant navigate to next cell with arrows key with my Logitech keyboard. I have to use mouse. Please help. which setting fault.

@robsalvv5853 3 года назад

I have numbers 3.2 on the iPad, iOS 10x,. I don't see an organise button on any spreadsheet or spreadsheet template? Is this a later version function? How do I create sort rules if I don't have that option?

@hurley9772 4 года назад

Is there any way at all to have a sum formula subtract instead of add? Or multiply?

@eugenegeorge1857 5 месяцев назад

At around 6:38 the 5 entries you have below item suddenly are all selected. How was that done?

@LaudaMaestro 3 года назад

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.

@MKMTG 3 года назад

The last time I checked, this wasn’t possible in the app.

@2212manu 4 года назад

Hi, how can I add autofill serial numbers in a particular column?

@ILCGyangcczmyiyan Год назад

how to align the table in center of the page while printing?

@ronmason1710 3 года назад

In Excel, when I have 500 rows, I can split the view, so that I can see the top of the spreadsheet, and the bottom on the one screen, with two separate scroll bars. How can I do this in numbers for iPad?