Instructor | ToIT
Excel: Data Analysis with Pivot Tables
- 01: Preparing Data (10:38)
02: Create from Local Data Source (10:33)
03: Create from Multiple Local Sources (12:27)
04: Create from External Sources (7:12)
05: Summarize Table Data (9:54)
06: Organize Pivot Table Data (12:19)
07: Filter Data Part 1 (9:54)
08: Filter Data Part 2 (12:46)
09: Format Pivot Table (14:19)
10: Refresh and Change Data (10:53)
11: Pivot Options Part 1 (9:53)
12: Pivot Options Part 2 (7:59)
13: Creating A Pivot Chart Data (2:56)
14: Manipulate Pivot Chart Data (8:06)
15: Formatting A Pivot Chart (7:36)
2h 5m
0
0
Excel: Creating Dashboards
- 01: Creating Range Names (10:17)
02: Using Defined Names in a Formula (4:17)
03: Using Specialized Functions, Part 1 (7:18)
04: Using Specialized Functions, Part 2 (11:58)
05: Applying Data Validation (12:28)
06: Using a Data Form (5:49)
07: Adding Form Controls (9:26)
08: Using Lookup Functions (11:39)
09: Combining Functions (11:10)
10: Creating a Chart (7:19)
11: Formatting and Modifying Charts (13:56)
12: Dual Axis Charts (5:38)
13: Forecasting with Trend Lines (8:03)
14: Creating Chart Templates (2:58)
15: Creating Sparklines (7:18)
16: Inserting Pivot Tables (9:47)
17: Analyzing Pivot Table Data, Part 1 (7:42)
18: Analyzing Pivot Table Data, Part 2 (8:36)
19: Presenting Data with Pivot Charts (6:47)
20: Filtering Data with Slicers (6:53)
2h 40m
0
0
Excel: Intro to PowerPivot
- 01: Enable and Navigate Power Pivot (5:57)
02: Managing Data Relationships (10:54)
03: Creating a Power Pivot Report (11:43)
04: Creating Calculations in Power Pivot (8:19)
05: Creating Key Performance Indicators (5:41)
06: Creating a Date Table (6:33)
07: Working with Dates and Time (11:20)
1h
0
0
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