Numbers Tutorial
ฝัง
- เผยแพร่เมื่อ 5 ก.ค. 2024
- Numbers Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
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.
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.
Happy to help!
Excellent video. Thanks a lot.
You are welcome!
thank you for these videos
I am glad I have found this channel
You are very welcome!
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,
Thank you so much!!!!
You're welcome!
I see your excel course. that's awesome.
Glad you like it!
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?
Can you add page break in number like excel so you can see where your printable space ends
thanks so much - great class
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
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
We are working on videos that will focus on finance and spreadsheets this coming year.
thanks adam hill i from indonesian and i can learn with your explan
My pleasure!
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.
Excellent advice!
can i relational table integrate two other tables. Necessary it works when filtered
This article may help: apple.stackexchange.com/questions/170053/linking-between-tables-in-numbers
Can I actually do return inside cell to wrap text as I want to?
Hello Андріана Чижик! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Interested in having an electronic spreadsheet to keep a balance, making credits, deductions…..totals
It really helps tracking financial data!
how are you able to get this on computer man?
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.
Hello Run ForrestRun! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
We’re is the casting calls template? Please
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.
This article may help: support.apple.com/guide/numbers/find-and-replace-text-tan71c6a7a38/mac
how can I add progress bar?
Hello AboValdez! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Hello, how can we change the size of a checkbox?
Thanks
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!
@@LearnitTraining i try but it doesn’t work..
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!
Hello Murat! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
I can't use filter for merged cells?
This article may help: support.apple.com/guide/numbers/filter-data-tan28bd63a8a/mac
And the office supply table the same I can’t see it please
How to fix running log
I understand Google Sheets is not secure. How secure is Numbers?
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!
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?
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.
how to change numbers to words eg: 100 to hundred
Hello Ranjeetsingh! You can get help 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 .😅
Excel is still the superior program but Numbers does most of the heavy lifting you need on a Mac
I signed up but still gettings ads
Hello Mary! You can find all the ad-free videos here: www.youtube.com/@LearnitTraining/membership
sir your exercise table is corrupted i guess, blanks are showing...
Hello Tanya! We just tested the files and they seem to be working right now.
@@LearnitTraining when i used 2-3 blanks where showing in pivot table...
I have a Mac ,
James or Adam?
Both!
@@LearnitTraining interesting.
iphone numbers recents how to use serial number new Indian
👍
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
Thanks for the tip
0.25 = 1/2 ? wtf
👍