Главная
Study mode:
on
1
Start
2
Introduction
3
Opening Numbers
4
Creating Spreadsheets
5
Numbers Interface
6
Changing Backgrounds
7
Opening, Closing, and Saving
8
Personalizing Templates
9
Creating and Managing Custom Templates
10
Using Sheets
11
Search
12
Printing
13
Customizing Apps
14
Adding and Removing Tables
15
Selecting Cells, Rows, and Columns
16
Adding or Modifying Rows and Columns
17
Merging and Unmerging Cells
18
Modifying Table Appearance
19
Resizing, Moving, and Locking Tables
20
Adding Text and Objects to Cells
21
Working with Different Types of Data
22
Wrapping Text
23
Conditional Highlighting
24
Filtering
25
Sorting and Alphabetizing
26
Organizing Data Into Categories
27
Pivot Tables
28
Quickly Calculating Sum and Average
29
Calculating Values Using Data in Cells
30
Formula Help
31
Adding and Removing Charts
32
Moving and Resizing Charts
33
Modifying Chart Data
34
Modifying Chart Appearance
35
Selecting Text and Placing Insertion Points
36
Adding and Editing Text
37
Text Formatting
38
Using Paragraph Styles
39
Applying Styles with Keyboard Shortcuts
40
Formatting Characters and Punctuation
41
Aligning, Spacing, and Formatting Lists
42
Adding and Editing Equations
43
Adding Links
44
Adding Highlight Effect
45
Adding Lines to Separate Text
46
Introduction to Images and Objects
47
Images
48
Shapes
49
Lines and Arrows
50
Audio and Video
51
Image and Video Formats
52
Animating Drawings
53
Positioning Objects on Sheets
54
Resizing, Rotating, and Flipping
55
Filling Objects with Color or Images
56
Changing Transparency
57
Adding Borders
58
Adding Reflections and Drop Shadows
59
Adding Titles or Captions
60
Using Object Styles
61
Undo and Redo
62
Looking Up Words
63
Find and Replace
64
Check Spelling
65
Comments
66
Introduction to Collaboration
67
Sending Spreadsheets
68
Inviting Others to Collaborate
69
Collaborating on Shared Spreadsheets
70
Sharing Settings
71
Shared Folders
72
iCloud and Transferring Between Devices
73
Importing Excel or Text Files
74
Reducing File Size
75
Packing Files
76
Restoring Previous File Versions
77
Password Protection
78
Keyboard Shortcuts
79
Conclusion
Description:
Master Apple Numbers, the powerful spreadsheet app from the iWork Suite, in this comprehensive 1-hour 11-minute tutorial. Begin with the basics of creating and managing spreadsheets, then dive into advanced data manipulation techniques using pivot tables, conditional formatting, formulas, and functions. Learn to enhance your spreadsheets with charts, images, and custom styling. Explore collaboration features, including sharing, real-time editing, and iCloud integration. Perfect for beginners and those looking to expand their Numbers skills, this tutorial covers everything from interface navigation to complex data analysis, ensuring you can create professional, visually appealing spreadsheets with ease.

Apple Numbers Tutorial

Learnit Training
Add to list
#Business #Business Software #Computer Science #Operating Systems #File Management #Data Science #Data Manipulation #Data Analysis #Spreadsheets #Pivot Tables #Text Formatting
0:00 / 0:00
1 of 79

Start