Numbers Tutorial
Video Overview & Insights
Numbers Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Thank you so much. This was really an awesome video. I would like to also learn how to insert a calendar pop out in a cell so that I can select the date from the calendar instead of typing the date manually?
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
geee dude more than 2 min of introduction waffling . sorry moved on
Exercise Files: https://tinyurl.com/mw8hze7s
Who it's for: Beginners and anyone who wants to learn more about Apple Numbers.
👍
What it is: Apple’s highly-regarded spreadsheet app, a cornerstone of their iWork Suite and similar to Microsoft Excel or Google Sheets.
What you'll learn: We’ll start with the basics like opening spreadsheets, adding tables, and using columns and rows. Then, we'll jump into working with data using tools like pivot tables, conditional formatting, formulas, functions, charts, and more. Next, we'll go over sprucing up your spreadsheets with images, borders, colors, and more. Finally, we'll cover collaboration with sharing, working together, and iCloud integration.
How to save template and customise table in iPad?
Start 0:00
Introduction 0:03
How do you keep table the same size and you want to add another row automatically
Opening Numbers 2:44
Creating Spreadsheets 3:41
That wrap text - life saver!
Numbers Interface 4:25
Changing Backgrounds 5:34
Very good video. Being an expert Excel user, then migrated to Numbers at launch, I found this video helpful even at this late stage of use. I have one chart that I had to create and populate and add functions manually. It was tedious and would love to automate it. I am going to rewatch this to see if I missed something. If it isn’t here, can I email you about the issue I am having?
Opening, Closing, and Saving 6:13
Personalizing Templates 7:49
kindly provide complete and detail learning in "advance VLOOKUP" with very large exercise data
Creating and Managing Custom Templates 10:34
Using Sheets 12:04
Instructions unclear. Accidentally made a kitchen table. What do?
Search 13:19
Printing 14:16
Hello, is it possible to change the sheet in a different color? Different sheets with different colors I mean? Thanks, Johan
Customizing Apps 14:54
Adding and Removing Tables 15:38
Thanks for this learning video - so many clear and useful tips! Moving over to Apple Numbers :)
Selecting Cells, Rows, and Columns 16:52
Adding or Modifying Rows and Columns 17:11
I converted my excel file over to numbers, now I have ROWS and COLUMNS that I don't use or need on the right side and under my work. How do I eliminate them ?
Merging and Unmerging Cells 17:54
Modifying Table Appearance 18:25
What are the differences between youtube courses and learn it anytime website
Resizing, Moving, and Locking Tables 19:45
Adding Text and Objects to Cells 20:23
Such a great video! It was super detailed, had a perfect pace, and your humor made it so enjoyable to watch. Thanks to you, I’m finally going to start using Numbers on my Mac to do all sorts of things. Keep up the awesome work!
Working with Different Types of Data 22:12
Wrapping Text 24:26
I'm trying to make a duplicate for my budget spreadsheet from 2024 and when I create the formulas and type the amount the formulas deletes it self, can you help please
Conditional Highlighting 25:03
Filtering 26:24
- I found this fairly confusing especially in the first 30 minutes- maybe it was part of a course where people were given demo files to match the ones he uses. A lot of information skimmed over quickly in a rather random order. Seems to be aimed at preparing a presentation or illustrated brochure rather than a spreadsheet. Presents some complex/advanced topics eg pivot tables and how to make charts very quickly. Probably would need a whole video on them, rather than the few seconds 'it happens by magic' here. Hard to keep track of his tiny cursor so allow many hours to follow the vid/flip back to your screen for your own sheets.
Sorting and Alphabetizing 27:26
Organizing Data Into Categories 28:14
Hi, how can I find the undo and format function like the excel sheet,thanks
Pivot Tables 28:41
Quickly Calculating Sum and Average 30:33
Thank you for your content. How do you write txt in the boxes and move down within the box for more txt? Every time I click return to move txt inside the box it takes me to another box instead of staying in the same box for more txt. Thanks
Calculating Values Using Data in Cells 31:44
Formula Help 35:53
How to autofill like this 👇🏻 on Numbers macbook
Evening 2pm - 5pm
Morning 10am - 1pm
Morning Here autofill
Evening
Evening
Morning
How i can do this ?
Morning, Evening i write it but after this i want in other cell autofill timing according to the shift.
Adding and Removing Charts 36:22
Moving and Resizing Charts 37:19
I love Numbers, Pages, and Keynote. This video deserves so many more views.
Modifying Chart Data 37:38
Modifying Chart Appearance 38:16
Can I upload /add images into the spread sheet like photos of contacts
Selecting Text and Placing Insertion Points 39:01
Adding and Editing Text 39:36
Am finding this very confusing, as he jumps all over instead of focusing an in-depth tutorial of each template, but one at a time. And he goes fast, so I have to pause multiple times to take notes and study what he did. He keeps mentioning topics I want to learn, but then says that he'll 'go over it later.' I do NOT like it when instructors do that, b/c they almost never actually return to the topic!!! Anyway, I am slogging through it but it's confusing and frustrating, imho.
Text Formatting 39:51
Using Paragraph Styles 40:15
just use excel lol
Applying Styles with Keyboard Shortcuts 40:55
Formatting Characters and Punctuation 41:18
Hello, how can we change the size of a checkbox?
Thanks
Aligning, Spacing, and Formatting Lists 42:23
Adding and Editing Equations 42:58
I understand Google Sheets is not secure. How secure is Numbers?
Adding Links 43:48
Adding Highlight Effect 44:31
0.25 = 1/2 ? wtf
Adding Lines to Separate Text 45:07
Introduction to Images and Objects 45:52
Numbers is fine as long as you don’t plan to share the files with others, especially when there are formulas. Opening Numbers files in other spreadsheet programs like Excel and Google Sheets will eventually cause problems. The danger is the problem may not be apparent until later. When you share spreadsheets with important data like financial information, stick with one program and make it consistent.
Images 46:50
Shapes 47:12
Loved your video! Great voice and instruction. However, I need a more in-depth tutorial on using the equations at the end of the tables. That part stumps me. Can you do a follow-up video on that? I checked Learnit and it has more PC based classes. I'm superior in Pages and Keynote but have been terrified of Numbers for decades. I just need a quickie vid.
Lines and Arrows 47:40
Audio and Video 48:46
And the office supply table the same I can’t see it please
Image and Video Formats 49:22
Animating Drawings 50:08
I have a Mac ,
Positioning Objects on Sheets 51:30
Resizing, Rotating, and Flipping 52:00
We’re is the casting calls template? Please
Filling Objects with Color or Images 52:30
Changing Transparency 53:01
thank you for these videos
I am glad I have found this channel
Adding Borders 53:20
Adding Reflections and Drop Shadows 53:42
Interested in having an electronic spreadsheet to keep a balance, making credits, deductions…..totals
Adding Titles or Captions 54:15
Using Object Styles 54:42
How to fix running log
Undo and Redo 55:21
Looking Up Words 56:00
Can you add page break in number like excel so you can see where your printable space ends
thanks so much - great class
Find and Replace 56:36
Check Spelling 57:26
Thank you so much brother, I'm a Google Sheet user, but Apple Numbers is so easy and minimalist. Again, thanks for the helpful tutorial.
Comments 58:05
Introduction to Collaboration 58:49
I just lost 5 days work in Excel. I am here to learn Numbers --it seems safer. One question. Can I save a Numbers file so my accountant can open it in Excel?
Sending Spreadsheets 1:00:17
Inviting Others to Collaborate 1:01:33
iphone numbers recents how to use serial number new Indian
Collaborating on Shared Spreadsheets 1:02:09
Sharing Settings 1:02:38
Hi Adam,
I created a calendar using the calendar template from Numbers.
The format looked like it was horizontal but it seems you can change it to any dimensions. So I made a horizontal dimension with a lot of space in the cells so I created a more horizontal format but when I tried to export to a PDF it broke the calendar into 3 parts so that each page of the PDF only had 1/3 of the calendar.
Is there anyway to fix this calendar so it will print all in one page?
Shared Folders 1:03:07
iCloud and Transferring Between Devices 1:04:01
how are you able to get this on computer man?
Importing Excel or Text Files 1:04:50
Reducing File Size 1:05:17
Totally enjoyed your presentation! My need is I'm leaving Filemaker behind, too costly. I need to make a spread sheet from an imported CSV file from my Bank and one for my Credit Card co to keep track of my finances. I've managed to do this but wonder if there's a more efficient way of doing it. A future tutorial would be great. Don't know why but having trouble coloring every other row. My transactions are so many it's difficult to follow all the categories across in the header column Thanks
Packing Files 1:05:45
Restoring Previous File Versions 1:06:10
can i relational table integrate two other tables. Necessary it works when filtered
Password Protection 1:06:55
Keyboard Shortcuts 1:07:55
Hello Adam. I am on a Mac using Numbers. Just need to find out why the "Find and Replace" search does not work. Could you please help? Thank you.
Conclusion 1:09:57
#numbers #applenumbers
I signed up but still gettings ads
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Thank you so much!!!!
Any illegal reproduction of this content will result in immediate legal action.
sir your exercise table is corrupted i guess, blanks are showing...
More User Perspectives
Why do some functions work on desktop Mac version but not loading numbers from iCloud? I notice things I can’t do on the iCloud version. In fact I hate working through iCloud version of numbers. Can’t save actual numbers file to where I want, so best to load and run from inbuilt app on the mac.
@runforrestrun1965how to change numbers to words eg: 100 to hundred
@ranjeetsinghbamrahHi Adam, is there a Solver function in Numbers? Set one cell to a target value and change another related cell value to get the target value. Thanks,
@Jeff-Cao