Numbers Tutorial
Numbers Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime...
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:
www.learnitany...
For Private Group Trainings please visit:
www.learnit.co...
Manuals: bit.ly/30xZb59
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.
Пікірлер: 73
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.
@LearnitTraining
7 ай бұрын
Happy to help!
Can I upload /add images into the spread sheet like photos of contacts
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.
@LearnitTraining
3 ай бұрын
Excellent advice!
thank you for these videos I am glad I have found this channel
@LearnitTraining
6 ай бұрын
You are very welcome!
Can you add page break in number like excel so you can see where your printable space ends thanks so much - great class
@LearnitTraining
7 ай бұрын
To insert a page break in Apple Numbers, you can either: Choose a row or column to insert a page break, and use the formatting tool to insert the page break. Place vertical and horizontal 'guide lines' in the document showing where the break will happen. In the View menu, choose Show Rulers. 0 on the rulers is the top left corner of the printed area of Page
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,
Fyi...break this down into specific tutorials. Easier for searching an issue....this video is pretty much overload. Nice voice and easy to listen to but IN THE WEEDS
@LearnitTraining
4 ай бұрын
Thanks for the tip
Thank you so much!!!!
@LearnitTraining
10 ай бұрын
You're welcome!
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?
I see your excel course. that's awesome.
@LearnitTraining
Жыл бұрын
Glad you like it!
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
@LearnitTraining
8 ай бұрын
We are working on videos that will focus on finance and spreadsheets this coming year.
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.
@LearnitTraining
9 ай бұрын
This article may help: support.apple.com/guide/numbers/find-and-replace-text-tan71c6a7a38/mac
Hello, how can we change the size of a checkbox? Thanks
@LearnitTraining
Ай бұрын
To adjust the size of a checkbox in Apple Numbers, follow these steps: Cell Formatted Checkbox: If you’re using a cell formatted as a checkbox, the size is fixed. You can’t directly change it. However, you can resize the checkbox by adjusting the font size of the cell. To do this: Select the cell with the checkbox. Go to Format > Font > Bigger (or use the shortcut ⌘+). Note that this will also affect the font size of other content in the cell. Character Viewer Checkbox: If you inserted a checkbox character from the Character Viewer (display-only), you can resize it: Insert the checkbox character into a cell. Open the Text Inspector (⌘+T). Change the point size to resize the checkbox. Remember, if you want the checkboxes to be active (i.e., toggleable), use the checkbox data format. The ballot box characters are for display purposes only1. Hope this helps!
@samsan5445
Ай бұрын
@@LearnitTraining i try but it doesn’t work..
And the office supply table the same I can’t see it please
Interested in having an electronic spreadsheet to keep a balance, making credits, deductions…..totals
@LearnitTraining
6 ай бұрын
It really helps tracking financial data!
I understand Google Sheets is not secure. How secure is Numbers?
@LearnitTraining
2 ай бұрын
Apple Numbers provides some security features to protect your spreadsheets and data. Here are some aspects of its security: Password Protection: You can assign a password to a Numbers spreadsheet on your Mac. This ensures that only those who know the password can open the spreadsheet. Passwords can consist of almost any combination of numbers, uppercase or lowercase letters, and special keyboard characters. If you forget your password, there’s no way to recover it, so be sure to choose a password you won’t forget or write it down in a safe place. Touch ID Integration: If your Mac has Touch ID (fingerprint detection), you can use it to open your password-protected spreadsheets with your fingerprint alone. Version-Specific Passwords: If you add a password to a spreadsheet or change an existing password, it applies only to that version of the spreadsheet and subsequent versions. To prevent others from restoring an unprotected version of the spreadsheet or an older password version, stop sharing the spreadsheet, add a unique password, and then share it again. Integration with Apple Devices: One of the biggest advantages of using Apple Numbers as an Apple-exclusive user is its integration with other Apple devices. Whether you’re moving between iPad, Mac, iPhone, or the web, your documents are accessible and secure as long as you save them to iCloud. Additionally, it’s worth noting that Apple takes security seriously across its ecosystem. For example, when it comes to Apple Pay, the Device Account Number (used for transactions) is never stored on Apple’s servers, isn’t backed up to iCloud, and is isolated from the actual operating system of your device. Apple also doesn’t store or have access to the original card numbers when they’re added to Apple Pay. Remember to keep your passwords secure and choose strong ones to protect your data!
Excellent video. Thanks a lot.
@LearnitTraining
11 ай бұрын
You are welcome!
can i relational table integrate two other tables. Necessary it works when filtered
@LearnitTraining
8 ай бұрын
This article may help: apple.stackexchange.com/questions/170053/linking-between-tables-in-numbers
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?
@LearnitTraining
7 ай бұрын
To save a Numbers file as an Excel file, you need to: Open the Numbers document you want to export. Click on the "More" button or the "Numbers" heading in the top-left corner of the Mac menu bar. Select "Export To". Click "Excel". Enter a name for your file.
thanks adam hill i from indonesian and i can learn with your explan
@LearnitTraining
Жыл бұрын
My pleasure!
We’re is the casting calls template? Please
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.
@LearnitTraining
10 ай бұрын
Hello Run ForrestRun! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
sir your exercise table is corrupted i guess, blanks are showing...
@LearnitTraining
10 ай бұрын
Hello Tanya! We just tested the files and they seem to be working right now.
@tanyapunyo2074
10 ай бұрын
@@LearnitTraining when i used 2-3 blanks where showing in pivot table...
how are you able to get this on computer man?
Hi. How can I some online information such as sport results to Numbers? Let's say soccer results. And I want to Numbers update the results every weekend. Excel does that but don't have it, don't want to use it.TIA!
@LearnitTraining
Жыл бұрын
Hello Murat! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
I signed up but still gettings ads
@LearnitTraining
10 ай бұрын
Hello Mary! You can find all the ad-free videos here: www.youtube.com/@LearnitTraining/membership
How to fix running log
I can't use filter for merged cells?
@LearnitTraining
11 ай бұрын
This article may help: support.apple.com/guide/numbers/filter-data-tan28bd63a8a/mac
how can I add progress bar?
@LearnitTraining
Жыл бұрын
Hello AboValdez! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
The big problem with numbers is printing , you can not select like in excel the print area .😅
@LearnitTraining
Жыл бұрын
Excel is still the superior program but Numbers does most of the heavy lifting you need on a Mac
Can I actually do return inside cell to wrap text as I want to?
@LearnitTraining
Жыл бұрын
Hello Андріана Чижик! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
how to change numbers to words eg: 100 to hundred
@LearnitTraining
11 ай бұрын
Hello Ranjeetsingh! You can get help from our instructors at Offsite, our online community - www.offsitebylearnit.com
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.
@LearnitTraining
22 күн бұрын
Noted!
@margaretq1089
22 күн бұрын
@@LearnitTraining My motto is: You cannot dumb it down enough for me. I need things dumbed waaaay down. Thank you for your understanding.
iphone numbers recents how to use serial number new Indian
@LearnitTraining
7 ай бұрын
👍
I have a Mac ,
James or Adam?
@LearnitTraining
Жыл бұрын
Both!
@heyt54
Жыл бұрын
@@LearnitTraining interesting.
0.25 = 1/2 ? wtf
@LearnitTraining
3 ай бұрын
👍
just use excel lol
@LearnitTraining
Ай бұрын
We think Excel is the superior program too! Numbers however is free for Apple users.