Select View:
Courses
Excel for Mac Basics
- 01: Getting Started with Excel (10:56)
02: Excel for Max VS Excel for PC (2:50)
03: Data Entry Shortcuts (7:18)
04: Using Formulas and Functions (10:37)
05: Copying Formulas and Functions (5:35)
06: Using Relative Absolute, and Worksheet Reference Formulas (7:33)
07: Modifying Cells, Columns, and Rows (6:54)
08: Search and Replace and Spellcheck (5:57)
09: Applying Text Formatting (12:50)
10: Number Formats and Cell Alignment (11:00)
11: Styles and Themes (3:26)
12: Applying Conditional Formatting (6:31)
13: Creating a Template (3:51)
14: Preview a WorkBook (5:09)
15: Setting Page Layout and Printing a Workbook, Part 1 (5:34)
16: Setting Page Layout and Printing a Workbook, Part 2 (9:10)
17: Working with WorkSheets (5:05)
18: Using Custom Views (5:04)
1h 40m
0
0
Excel for Project Management
- 01: Project Charter (8:04)
02: Requirements Document / Scope (9:23)
03: Issues Log (6:03)
04: Work Breakdown Structure (9:22)
05: Risk Register (11:51)
06: Communications Plan (6:10)
51m
0
0
Excel Power Functions
Lessons Include:
01: Introduction (6:04)
02: DATEDIF (4:45)
03: EDATE and EOMONTH (7:34)
04: CONVERT (4:32)
05: INDEX and MATCH (6:31)
06: INDEX MATCH MATCH (5:48)
07: Rolling Averages (6:29)
08: SUMPRODUCT (6:12)
48m
0
0
Lo Elemental de Planner Office 365 (Office 365 Planner Essentials)
# 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
46m
0
0
Mastering Word 365 – Basics (2022)
# 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
1h 22m
0
0
Mastering Word 365 – Beginner (2022)
# 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
57m
0
0
Mastering Excel 365 – Basics (2022)
# 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
2h 58m
0
0
Mastering Excel 365 – Intermediate (2022)
# 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
3h 32m
0
0
Microsoft 365 Sharing Calendars and Email (2022)
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
49m
0
0
Microsoft 365 To Do, Calendar, and People Essentials (2022)
# 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
1h 22m
0
0
Mastering Microsoft 365 (2022)
- Understanding Microsoft 365
- Setting up email & Outlook on the Web
- Getting organized with flags, tags, folders, and categories
12h 54m
0
0