Numbers Tutorial

Numbers Tutorial

Get Ad-Free Training by becoming a member today!

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.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:03
Opening Numbers 2:44
Creating Spreadsheets 3:41
Numbers Interface 4:25
Changing Backgrounds 5:34
Opening, Closing, and Saving 6:13
Personalizing Templates 7:49
Creating and Managing Custom Templates 10:34
Using Sheets 12:04
Search 13:19
Printing 14:16
Customizing Apps 14:54
Adding and Removing Tables 15:38
Selecting Cells, Rows, and Columns 16:52
Adding or Modifying Rows and Columns 17:11
Merging and Unmerging Cells 17:54
Modifying Table Appearance 18:25
Resizing, Moving, and Locking Tables 19:45
Adding Text and Objects to Cells 20:23
Working with Different Types of Data 22:12
Wrapping Text 24:26
Conditional Highlighting 25:03
Filtering 26:24
Sorting and Alphabetizing 27:26
Organizing Data Into Categories 28:14
Pivot Tables 28:41
Quickly Calculating Sum and Average 30:33
Calculating Values Using Data in Cells 31:44
Formula Help 35:53
Adding and Removing Charts 36:22
Moving and Resizing Charts 37:19
Modifying Chart Data 37:38
Modifying Chart Appearance 38:16
Selecting Text and Placing Insertion Points 39:01
Adding and Editing Text 39:36
Text Formatting 39:51
Using Paragraph Styles 40:15
Applying Styles with Keyboard Shortcuts 40:55
Formatting Characters and Punctuation 41:18
Aligning, Spacing, and Formatting Lists 42:23
Adding and Editing Equations 42:58
Adding Links 43:48
Adding Highlight Effect 44:31
Adding Lines to Separate Text 45:07
Introduction to Images and Objects 45:52
Images 46:50
Shapes 47:12
Lines and Arrows 47:40
Audio and Video 48:46
Image and Video Formats 49:22
Animating Drawings 50:08
Positioning Objects on Sheets 51:30
Resizing, Rotating, and Flipping 52:00
Filling Objects with Color or Images 52:30
Changing Transparency 53:01
Adding Borders 53:20
Adding Reflections and Drop Shadows 53:42
Adding Titles or Captions 54:15
Using Object Styles 54:42
Undo and Redo 55:21
Looking Up Words 56:00
Find and Replace 56:36
Check Spelling 57:26
Comments 58:05
Introduction to Collaboration 58:49
Sending Spreadsheets 1:00:17
Inviting Others to Collaborate 1:01:33
Collaborating on Shared Spreadsheets 1:02:09
Sharing Settings 1:02:38
Shared Folders 1:03:07
iCloud and Transferring Between Devices 1:04:01
Importing Excel or Text Files 1:04:50
Reducing File Size 1:05:17
Packing Files 1:05:45
Restoring Previous File Versions 1:06:10
Password Protection 1:06:55
Keyboard Shortcuts 1:07:55
Conclusion 1:09:57

#numbers #applenumbers

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[MaHmoodOom]

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.

[cloggedaorta]

I love Numbers, Pages, and Keynote. This video deserves so many more views.

[deluisechristoper]

Can you add page break in number like excel so you can see where your printable space ends
thanks so much - great class

[JoannaReason]

thank you for these videos
I am glad I have found this channel

[Jeff-Cao]

Hi 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,

[iankay]

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

[danfontaine]

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

[nusratjahannitu]

I see your excel course. that's awesome.

[swaha]

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?

[margarita]

Interested in having an electronic spreadsheet to keep a balance, making credits, deductions…..totals

[DataScienceAI-rfkx]

can i relational table integrate two other tables. Necessary it works when filtered

[jasonluong]

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.

[Gates-and-electric-fencing]

Can I upload /add images into the spread sheet like photos of contacts

[nandita]

thanks adam hill i from indonesian and i can learn with your explan

[samsan]

Hello, how can we change the size of a checkbox?
Thanks

[louisang]

Hi, how can I find the undo and format function like the excel sheet, thanks

[DesignArtStudios]

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.

[runforrestrun]

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.

[kevincostello]

I understand Google Sheets is not secure. How secure is Numbers?

[tanyapunyo]

sir your exercise table is corrupted i guess, blanks are showing...