Select View:
Courses
Word in 30 Minutes – Working Efficiently
Lessons Include
1 Using Find and Replace 5:21
2 Applying Repetitive Formatting 6:55
3 Using Styles 5:50
4 Creating a Style 2:07
20h
0
0
Word in 30 Minutes – Creating list and Tables
Lessons Include
1 Sorting Lists 3:30
2 Formatting Lists 3:26
3 Resequencing Lists 1:31
4 Inserting a Table 5:17
5 Modifying a Table 4:53
6 Formatting a Table 2:49
7 Converting Text to a Table 4:54
26h
0
0
Word in 30 Minutes – Graphics and Page Appearance
Lessons Include
1 Inserting Symbols 4:33
2 Adding Images 9:44
3 Formatting Pages 2:28
4 Adding Headers and Footers 7:13
5 Controlling Page Layout 5:57
6 Adding a Watermark 2:37
33h
0
0
Word in 30 Minutes – Preparing to Publish
Lessons Include
1 Checking Grammar and Readability 5:53
2 Using Research Tools 5:35
3 Checking Accessibility 7:48
4 Saving to Other Formats 3:53
23h
0
0
Learning Excel 2019 – Expert (TOSA)
Lessons Include
Customizing General Options 4:45
Customizing the Ribbon 7:02- Customizing the Quick Access Toolbar 6:46
Working with Functions
Working with Logical Functions 8:36
Working with Conditional Functions 7:33
Multiple Criteria Functions 5:03
Using Nested Functions 5:13
Using IFS and SWITCH Functions 5:56
Working with Text Functions, Part 1 4:13
Working with Text Functions, Part 2 4:27
Working with Text Functions, Part 3 3:42
Working with Text Functions, Part 4 8:14
Working with Math Functions 6:59
More Lookup Functions 9:44
Using PivotTables and PivotCharts
Creating a PivotTable 11:31
16 Summarizing Data in a PivotTable 8:00
17 Grouping Data in a PivotTable 6:15
18 Formatting a PivotTable 6:56
19 Selecting and Moving PivotTables 3:15
20 Changing PivotTable Options 8:07
21 Adding Calculated Fields 2:03
22 Presenting Data with PivotCharts 4:21
Sharing and Protecting
Co-Authoring, Part 1 6:12
Co-Authoring, Part 2 4:44
Protecting a Workbook File 7:08
Applying Data Validation 7:18
Auditing Formulas
Addressing Formula Errors 7:16
Watching and Evaluating Formulas 4:46
Adding Error Handling 4:34
Working with Information Functions 5:12
Forecasting Data
Forecasting with Data Tables 5:04
Using Solver 6:46
Forecasting with Scenarios 8:16
Forecasting Data Trends 3:23
Creating Sparklines 3:58
More Features
Using Paste Special 5:50
Summarizing Data in Tables 4:32
Creating Custom Lists 5:34
Working with Forms 9:54
Using ActiveX Controls 4:02
4h 3m
0
0
Learning Excel 2019 – Advanced (TOSA)
- Working with Functions
Using AutoFill 7:36
Copying Formulas and Functions 7:09
Using Named Ranges, Part 1 5:00
Using Named Ranges, Part 2 5:25
Using Named Ranges, Part 3 5:08
Working with Date Functions, Part 1 8:55
Working with Date Functions, Part 2 4:17
Working with Date Functions, Part 3 3:37
Working with Time Functions 5:29
Working with Conditional Functions 7:33
Multiple Criteria Functions 5:03
Working with Lists
Filtering Data, Part 1 7:11
Filtering Data, Part 2 7:55
Querying with Database Functions 6:55
Using the Subtotal Function 4:28
Using the Subtotal Feature 6:12
Visualizing Data with Charts
Using Advanced Chart Features 4:29
Applying Trendlines 4:35
Creating a Chart Template 3:27
Inserting Graphics
Inserting Graphics 8:41
Modifying Graphics, Part 1 5:40
Modifying Graphics, Part 2 6:12
Using PivotTables and Slicers
Creating a PivotTable 11:31
Summarizing Data in a PivotTable 8:00
Grouping Data in a PivotTable 6:15
Formatting a PivotTable 6:56
Selecting and Moving PivotTables 3:15
Changing PivotTable Options 8:07
Adding Calculated Fields 2:03
Using Slicers 7:26
Using Timeline Slicers 1:44
Linking and Consolidating
Creating Internal Links 4:08
Creating External Links 9:00
Using Paste Special 5:50
Consolidating Data 6:56
Sharing and Protecting
Co-Authoring, Part 1 6:12
Co-Authoring, Part 2 4:44
Using Compare and Merge 3:04
Adding Digital Signatures 5:55
Protecting Worksheets 10:33
Protecting Workbook Structure 3:01
Protecting a Workbook File 7:08
Automating
Applying Data Validation 7:18
Adding a Dropdown List 4:56
Customizing Data Validation 5:18
Recording a Macro 8:08
Running a Macro 5:32
Editing a Macro 8:27
Using Lookup Functions
Using VLOOKUP, Part 1 5:40
Using VLOOKUP, Part 2 5:14
More Lookup Functions 9:44
Using Array Formulas 6:00
Other
Using Goal Seek 3:30
Inserting Symbols and Characters 2:32
Working with Forms 9:54
5h 35m
0
0
Learning Excel 2019 – Basics (TOSA)
Performing Calculations
Inserting Functions 8:10
Using Absolute References 9:51
Formatting Worksheets
Inserting and Deleting Cells 8:50
Applying Text Formats 8:35
Applying Number Formats 7:24
Aligning Cell Contents 7:17
Applying Themes 3:48
Using Templates 6:01
Printing Workbooks
Setting the Page Layout 6:34
Inserting Page Breaks 8:38
Configuring Headers and Footers, Part 1 5:09
Configuring Headers and Footers, Part 2 4:04
Managing Workbooks
Managing Worksheets, Part 1 5:02
Managing Worksheets, Part 2 7:39
Creating a Custom View 3:47
Working with Functions
Using Named Ranges 5:25
Working with Logical Functions 8:36
Working with Conditional Functions 7:33
Other
Sorting Data 5:18
Creating Charts 5:37
Using Chart Types 2:27
Tracing Formulas 6:22
Addressing Formula Errors 7:16
2h 29m
0
0
Learning Excel 2019 – Beginner (TOSA)
- Getting Started
Navigating the Interface 8:42
Selecting Data 9:15
Using Commands 7:14
Creating a New Workbook 8:04
Entering Cell Data 5:59
Using Excel Help 2:05
Formulas and Functions
Creating Formulas 7:57
Inserting Functions 8:14
Using Absolute References 9:51
Formatting
Applying Text Formats 8:35
Applying Number Formats 7:24
Customizing Number Formats 7:46
Applying Cell Styles 5:20
Applying Conditional Formatting to Numbers 6:45
Applying Conditional Formatting to Text and Dates 7:56
Printing
Printing Workbooks 4:12
Setting the Page Layout 6:34
Sorting and Filtering
Sorting Data 5:18
Filtering Data 5:20
Other
Using Chart Types 2:27
Ideas in Office 365 2:06
2h 17m
0
0
Bocados de Saber: Escribiendo Emails Efectivos
1 Cuando Escribir un Email 4:11 2 Mejores Prácticas para el Email 4:10 3 Escribiendo Emails Claros 3:54 4 Escribiendo Emails Concisos 2:59 5 Escribiendo Emails Completos 3:55 6 Escribiendo Emails Correctos 4:09
23h 13m
0
0
Bocados de Saber – Empatía: La Clave para la Escucha Activa
1 ¿Qué es la empatía? 3:22 2 Empatía e inteligencia emocional 3:25 3 Identificación de las emociones de los demás 3:39 4 Comunicar empatía 2:22 5 Empatía en la era digital 3:55
17m
0
0
Bocados de Saber – Déjales Saber que Estás Escuchando
1 Es fácil no escuchar 2:35 2 Lenguaje corporal y señales verbales 3:21 3 Prestando atención y clarificando 2:22 4 Niveles de escucha 1-3 2:56 5 Niveles de escucha 4-6 4:49
17m
0
0
Smartsheet Basics
1 Introduction to Smartsheet 1 Introduction 2:30 2 Creating a New Smartsheet 9:51 2 Working with Rows and Columns 3 Customizing Columns 7:35 4 Working with Rows, Part 1 6:56 5 Working with Rows, Part 2 6:40 6 Conditional Formatting 5:32 3 Attachments, Links, and Formulas 7 Attaching Files and Links 4:48 8 Creating Formulas 3:57 4 Sharing Tools 9 Sharing a Sheet 10:00 10 Comments and Conversations 5:56 5 Advanced Sharing 11 Automating a Workflow 6:59 12 Managing a Shared Sheet 6:15
1h 17m
0
0