Benefit from ad-free training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise files: https://learnitanytime.com/p/exercise-files-numbers-tutorial
Who is it for: Beginners and anyone who wants to learn more about Apple numbers.
What it is: Apple's popular spreadsheet app, the 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 working with columns and rows. Next, we'll move on to working with data using tools like pivot tables, conditional formatting, formulas, functions, charts, and more. Next, we'll move on to enhancing your spreadsheets with images, borders, colors, and more. Finally, we'll cover collaboration with iCloud sharing, collaboration, and integration.
Join Learnit Anytime for ad-free training, exams, certificates and exclusive content:
https://www.learnitanytime.com
For private group training, please visit:
https://www.learnit.com/private-group-classes-workshops
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Opening Numbers 2:44
Create spreadsheets 3:41
Interface of Numbers 4:25
Change backgrounds 5:34
Opening, closing and saving 6:13
Customizing templates 7:49
Creating and managing custom templates 10:34
Using leaves 12:04
Search 13:19
Print 14:16
Customize apps 14:54
Add and remove tables 15:38
Selecting cells, rows and columns 16:52
Add or edit rows and columns 17:11
Merge and dissociate cells 17:54
Changing the appearance of the 18:25 table
Resize, move and lock tables 19:45
Add 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
Sort and alphabetize 27:26
Organize data into categories 28:14
Pivot Tables 28:41
Quickly calculate the sum and average 30:33
Calculate values using cell data 31:44
Formula help 35:53
Add and remove graphics 36:22
Move and resize graphics 37:19
Editing chart data 37:38
Changing the appearance of the 38:16 chart
Selecting text and placing insertion points 39:01
Add and edit text 39:36
Formatting text 39:51
Use paragraph styles 40:15
Applying styles with keyboard shortcuts 40:55
Character formatting and punctuation 41:18
Aligning, Spacing, and Formatting Lists 42:23
Adding and editing equations 42:58
Add links 43:48
Added 44:31 highlight effect
Add lines to separate text 45:07
Introduction to images and objects 45:52
Frames 46:50
Forms 47:12
Lines and arrows 47:40
Audio and video 48:46
Image and video formats 49:22
Animation of drawings 50:08
Positioning objects on sheets 51:30
Resizing, rotating and flipping 52:00
Filling objects with color or images 52:30
Change transparency 53:01
Add borders 53:20
Add highlights and drop shadows 53:42
Add titles or captions 54:15
Use object styles 54:42
Undo and redo 55:21
Search for 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
Invite others to collaborate 1:01:33
Collaborate on shared spreadsheets 1:02:09
Sharing Settings 1:02:38
Shared folders 1:03:07
iCloud and transfer between devices 1:04:01
Importing Excel or text files 1:04:50
Reduce 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.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments