Microsoft excel 365 Course

Created by:

Simon Sez IT

48 Lessons
830 Students
Certificate of completion

Track:

Computer Softwares

Microsoft excel 365, in this course provides a complete guide to mastering Excel’s modern tools and cloud-based features. You’ll learn how to create, edit, and manage spreadsheets, use essential and advanced formulas, and organize data efficiently. The course covers charts, PivotTables, data validation, and conditional formatting to help you analyze information clearly. You’ll also explore Excel 365’s unique features like real-time collaboration, dynamic arrays, and integration with OneDrive and Power BI. Through practical lessons, you’ll gain skills to automate tasks, visualize insights, and work smarter across devices. By the end, you’ll confidently use Excel 365 for both personal and professional success. Simon Sez IT

To Register in Course you have to watch at least 30 Second of any lesson

What You'll Learn

Create and edit spreadsheets using Excel 365’s modern tools and cloud-based features effectively
Apply essential and advanced formulas to analyze and manipulate data accurately in Excel 365
Design and customize charts, PivotTables, and conditional formatting to visualize data insights clearly
Utilize real-time collaboration, dynamic arrays, and integration with OneDrive and Power BI for efficient data management

Course Content

48 Lessons • 41 h 30 m total

Microsoft Excel 2021 365 Tutorial 3 5 Hours of Advanced Excel Training Course

3:43:41

Microsoft Excel 365 Tutorial 3 Hours of Advanced Excel Training

3:07:38

How to Count Unique Entries in Excel 365

3:59

How to Use Spills and Arrays in Excel 365

6:20

Unique vs Distinct in Excel 365

4:34

How to Extract Multiple Unique Columns in Excel 365

2:45

How to Extract Unique Values by Column in Excel 365

4:00

How to Use the SEQUENCE Function in Excel 365

5:15

How to use RANDARRAY and RANDBETWEEN in Excel 365

9:46

How to use XLOOKUP for Complex Lookups in Excel 365

7:52

How to use XMATCH in Excel 365

4:34

How to do Lookups with Multiple Criteria in Excel 365

6:42

How to do Lookups with Duplicates in Excel 365

6:03

How to use the LET Function in Excel 365

9:58

How to Create Excel Functions with LAMBDA

11:38

How to Create a Data Model in Power Pivot

6:56

How to Create Relationships Between Tables in Excel 365

4:29

How to Add Calculated Columns in Excel 365

6:16

How to Build a PivotTable from Multiple Sources

4:08

How to Clean Data with Power Query in Excel 365

9:37

How to Combine Files from a Folder with Power Query in Excel 365

6:52

Ultimate Guide to the FILTER Function in Excel 365

22:17

How to Use Calculated Fields and Items in PivotTables

9:06

How to Use the SORT Function in Excel 365

12:12

How to Use the SORTBY Function in Excel 365

8:32

Ultimate Guide to Create Your Own Functions in Excel 365

23:27

How Create Custom Pivot Table Styles

8:57

How to Apply Custom Number Formatting in Excel 365 PivotTables

7:04

How to Use Form Checkboxes in Excel 365

7:51

How to Use Macros for Automation in Excel 365

7:03

How to Lock Workbooks but not Slicers in PivotTables Filterable and Adjustable Locked Spreadsheets

3:35

How to Record Macros with Relative References in Excel 365

7:22

How to Use the VBA Editor in Excel 365

8:19

How to use Copilot to Generate VBA Code

5:11

How to use AI to Generate Sample Datasets

6:27

How to Build and Design Charts and Dashboards in Excel

2:20:19

Quickstart Guide to Cleaning Data and Building Reporting Dashboards

2:32:21

How to Boost Efficiency in Microsoft Office Top Tips and Expert Hacks

2:19:17

Data Models PivotTables and Power Query in Excel

47:38

Conditional Formatting in Excel

46:20

How to Get The Certificate

You must have an Account on the platform.
Complete all lessons.
Watch at least 50% of Lesson Duration.
Get your Certificate free 🎉 !

Microsoft excel 365

Computer Softwares

Microsoft excel 365

Professor Claudio Damasceno 4.0

1

4.3 (15 reviews)

Overall rating

5.0 40%
4.0 47%
3.0 13%
2.0 0%
1.0 0%

Reviews

Ankit Kumar

· 3w ago

BEST

youssef saadi

· 2mos ago

good

Sadhana Kadari

· 2mos ago

super

Hashm Arram

· 3mos ago

الشرح سهل ومبسط وجميل

KANGOYESSI LAGBAZOUNGA Venancio Cherubin De Morin

· 3mos ago

GOOD

Endraswara Arya Wijaya Kusuma

· 3mos ago

very good course

Gilang M. Fajar

· 3mos ago

thank you

Muhammad Fadli

· 4mos ago

Excellent

Deokar Pranav Sanjay

· 5mos ago

Nice

Anurag Pawase

· 5mos ago

Nice

Annas Ahmed Khan

· 6mos ago

EXCELLENT WEBSITE AND GREAT IDEAS

Shabab Ali

· 6mos ago

good

Microsoft excel 365 Course Description

Microsoft excel 365, in this course provides a complete guide to mastering Excel’s modern tools and cloud-based features. You’ll learn how to create, edit, and manage spreadsheets, use essential and advanced formulas, and organize data efficiently. The course covers charts, PivotTables, data validation, and conditional formatting to help you analyze information clearly. You’ll also explore Excel 365’s unique features like real-time collaboration, dynamic arrays, and integration with OneDrive and Power BI. Through practical lessons, you’ll gain skills to automate tasks, visualize insights, and work smarter across devices. By the end, you’ll confidently use Excel 365 for both personal and professional success. Simon Sez IT

Focus on Learning, Not Ads

Experience the full power of Mindluster with Premium.
No distractions, just pure education.

Get Mindluster Premium

Cancel your subscription anytime