Microsoft Excel 365: Advanced Training Tutorials
4.0
(1)
24 learners
What you'll learn
This course includes
- 47 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 53 lessons • 47 hours of video
Microsoft Excel 365: Advanced Training Tutorials
53 lessons
• 47 hours
Microsoft Excel 365: Advanced Training Tutorials
53 lessons
• 47 hours
- Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course 03:43:41
- Microsoft Excel 365 Tutorial: 3+ Hours of Advanced Excel Training 03:07:38
- How to Count Unique Entries in Excel 365 03:59
- How to Use Spills and Arrays in Excel 365 06:20
- Unique vs Distinct in Excel 365 04:34
- How to Extract Multiple Unique Columns in Excel 365 02:45
- How to Extract Unique Values by Column in Excel 365 04:00
- How to Use the SEQUENCE Function in Excel 365 05:15
- How to use RANDARRAY and RANDBETWEEN in Excel 365 09:46
- How to use XLOOKUP for Complex Lookups in Excel 365 07:52
- How to use XMATCH in Excel 365 04:34
- How to do Lookups with Multiple Criteria in Excel 365 06:42
- How to do Lookups with Duplicates in Excel 365 06:03
- How to use the LET Function in Excel 365 09:58
- How to Create Excel Functions with LAMBDA 11:38
- How to Create a Data Model in Power Pivot 06:56
- How to Create Relationships Between Tables in Excel 365 04:29
- How to Add Calculated Columns in Excel 365 06:16
- How to Build a PivotTable from Multiple Sources 04:08
- How to Clean Data with Power Query in Excel 365 09:37
- How to Combine Files from a Folder with Power Query in Excel 365 06:52
- Ultimate Guide to the FILTER Function in Excel 365 22:17
- How to Use Calculated Fields and Items in PivotTables 09:06
- How to Use the SORT Function in Excel 365 12:12
- How to Use the SORTBY Function in Excel 365 08:32
- Ultimate Guide to Create Your Own Functions in Excel 365 23:27
- How Create Custom Pivot Table Styles 08:57
- How to Apply Custom Number Formatting in Excel 365 PivotTables 07:04
- How to Lock Workbooks but not Slicers in PivotTables: Filterable and Adjustable Locked Spreadsheets 03:35
- How to Use Form Checkboxes in Excel 365 07:51
- How to Use Macros for Automation in Excel 365 07:03
- How to Record Macros with Relative References in Excel 365 07:22
- How to Use the VBA Editor in Excel 365 08:19
- How to use Copilot to Generate VBA Code 05:11
- How to use AI to Generate Sample Datasets 06:27
- How to Build and Design Charts and Dashboards in Excel 02:20:19
- Quickstart Guide to Cleaning Data and Building Reporting Dashboards 02:32:21
- How to Boost Efficiency in Microsoft Office: Top Tips and Expert Hacks 02:19:17
- Data Models, PivotTables, and Power Query in Excel 47:38
- Conditional Formatting in Excel 46:20
- How to Create Professional Charts for Business in Excel 59:21
- Interactive Excel Charts and Dashboards - Data Visualization Course 02:39:02
- Top Excel Functions for Data Analysts 01:35:33
- Create Formulas and Fix Common Errors in Excel 01:16:51
- Excel 365 Beginner to Advanced - 12 Hours 11:43:05
- Top 15 Excel Tips and Tricks to Save Time and Speed Up Your Work 01:18:54
- Top 15 Excel Functions Everyone Needs to Know 01:03:34
- Accountant Excel Toolkit: Trial Balance and General Ledger in Excel 57:26
- Master Data Cleaning Essentials with Power Query And Excel 01:26:11
- Top Excel Essential Tips 01:04:27
- Microsoft Excel 365 Essentials Training Course 01:44:39
- How to Create Dashboards with Copilot in Excel 365 - Agent Mode in Excel Beginner Course 31:38
- 7 Excel Form Controls and Checkboxes You Need To Know 52:22
