# | Lección | Duración |
1 | Introducción a Planner | 9:08 |
2 | Trabajando con tarjetas | 12:58 |
3 | Trabajando con cubos | 4:51 |
4 | Gestionando Mis Planes | 10:42 |
5 | Actualizaciones en Planner | 8:48 |
# | Lesson | Length |
1 | Introduction | 2:01 |
2 | Navigation | 9:57 |
3 | Create, Save, and Print Documents | 7:36 |
4 | Select, Move, and Copy Text | 6:59 |
5 | Find, Replace, and Go To | 5:24 |
6 | Format Text | 6:56 |
7 | Styles and Format Painter | 4:44 |
8 | Format Paragraphs | 9:42 |
9 | Tables | 9:55 |
10 | Editor, Thesaurus, and Read Aloud | 9:18 |
11 | Graphics | 9:38 |
# | Lesson | Length |
1 | Introduction | 1:51 |
2 | Opening a Word Document | 6:12 |
3 | Navigating in a Document | 6:01 |
4 | Saving a Document | 4:44 |
5 | Getting Help | 3:59 |
6 | Creating a New Document | 4:19 |
7 | Selecting Text | 4:24 |
8 | Formatting Text | 5:40 |
9 | Cutting, Copying and Pasting Text | 6:32 |
10 | Using Bullets and Numbered Lists | 4:23 |
11 | Inserting Pictures and Shapes | 6:09 |
12 | Inserting a Table | 3:16 |
# | Lesson | Length |
1 | Introduction | 1:50 |
2 | Open and Save a Workbook | 5:37 |
3 | Modifying Rows and Columns, Part 1 | 6:11 |
4 | Modifying Rows and Columns, Part 2 | 6:55 |
5 | Managing Worksheets, Part 1 | 4:29 |
6 | Managing Worksheets, Part 2 | 8:58 |
7 | Using Absolute References | 7:42 |
8 | Creating Named Ranges | 7:05 |
9 | Using Named Ranges in Functions | 6:43 |
10 | Working with IF Functions | 8:21 |
11 | Working with Logical Functions | 4:41 |
12 | Creating Functions Based on Conditions | 7:00 |
13 | Tracing Formulas | 6:21 |
14 | Addressing Formula Errors | 9:51 |
15 | Aligning Cell Contents | 9:18 |
16 | Adding Borders and Shading | 8:06 |
17 | Applying Number and Date Formats | 9:04 |
18 | Using Format Painter | 4:46 |
19 | Applying Cell Styles and Themes | 7:38 |
20 | Changing Chart Types | 6:21 |
21 | Changing Chart Source Data | 5:20 |
22 | Creating a Table | 5:05 |
23 | Creating a PivotTable | 6:34 |
24 | Setting Page Layout Options | 7:35 |
25 | Changing Page Breaks and Scaling | 9:35 |
26 | Configuring Headers and Footers | 7:21 |
# | Lesson | Length |
1 | Introduction | 2:14 |
2 | Flash Fill | 8:23 |
3 | Text to Columns | 5:32 |
4 | Find and Replace | 9:08 |
5 | Sort and Filter | 6:09 |
6 | Proofing and Researching Tools | 7:22 |
7 | Group Mode | 4:08 |
8 | Workbook Properties | 4:22 |
9 | Freeze and Split Windows | 6:47 |
10 | Workbook Views | 5:36 |
11 | Custom Views | 4:47 |
12 | Custom Number Formats | 9:33 |
13 | Conditional Formatting for Text and Dates | 4:40 |
14 | Comparative Analysis with Conditional Formatting | 5:02 |
15 | Customizing Conditional Formatting | 7:55 |
16 | Functions in Conditional Formatting | 4:59 |
17 | Nested Functions | 9:37 |
18 | Logical Functions | 5:28 |
19 | Statistical Functions | 7:36 |
20 | Chart Elements | 9:14 |
21 | Chart Formats | 7:36 |
22 | Sparklines | 2:15 |
23 | Graphics | 3:14 |
24 | SmartArt | 4:00 |
25 | Creating Tables | 4:25 |
26 | Table Styles | 4:22 |
27 | Summarizing Data in Tables | 4:36 |
28 | Managing PivotTables | 8:43 |
29 | Web Queries | 3:17 |
30 | Hyperlinks | 5:09 |
31 | Compare and Merge | 4:01 |
32 | Track Changes | 5:53 |
33 | Share a Workbook | 4:21 |
34 | Comments | 8:44 |
35 | Goal Seek | 5:30 |
36 | Forecasting with Data Tables | 5:44 |
37 | Analyze Data Tool | 2:27 |
Lesson Name | Duration |
Sharing Calendars, Part 1 | 7:26 |
Sharing Calendars, Part 2 | 6:42 |
Group Calendars and Shared Mailboxes | 9:21 |
Publish and Export Calendars | 10:34 |
Delegate Access | 6:28 |
Share Email Folders | 8:30 |
# | Lesson | Length |
1 | To-Do and Flagged Emails | 8:29 |
2 | To Do and My Day | 4:43 |
3 | Calendar Basics | 8:14 |
4 | Adding Calendar Events, Part 1 | 8:27 |
5 | Adding Calendar Events, Part 2 | 8:59 |
6 | Calendar Search and Print | 4:01 |
7 | Sticky Notes | 5:26 |
8 | Calendar Board View, Pt 1 | 6:40 |
9 | Calendar Board View, Pt 2 | 8:37 |
10 | People (Contacts) | 9:55 |
11 | Contact Lists and Address Books | 8:35 |