×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

Top 15 Excel Functions Everyone Needs to Know

Share your inquiries now with community members Click Here
Previous Lesson Next Lesson
Sign Up and Get Free Certificate
Sign up Now
Lesson extensions

Lessons List | 48 Lesson
Microsoft Excel 2021 365 Tutorial 3 5 Hours of Advanced Excel Training Course
03:43:41

Microsoft Excel 2021 365 Tutorial 3 5 Hours of Advanced Excel Training Course
Microsoft Excel 365 Tutorial 3 Hours of Advanced Excel Training
03:07:38

Microsoft Excel 365 Tutorial 3 Hours of Advanced Excel Training
How to Count Unique Entries in Excel 365
00:03:59

How to Count Unique Entries in Excel 365
How to Use Spills and Arrays in Excel 365
00:06:20

How to Use Spills and Arrays in Excel 365
Unique vs Distinct in Excel 365
00:04:34

Unique vs Distinct in Excel 365
How to Extract Multiple Unique Columns in Excel 365
00:02:45

How to Extract Multiple Unique Columns in Excel 365
How to Extract Unique Values by Column in Excel 365
00:04:00

How to Extract Unique Values by Column in Excel 365
How to Use the SEQUENCE Function in Excel 365
00:05:15

How to Use the SEQUENCE Function in Excel 365
How to use RANDARRAY and RANDBETWEEN in Excel 365
00:09:46

How to use RANDARRAY and RANDBETWEEN in Excel 365
How to use XLOOKUP for Complex Lookups in Excel 365
00:07:52

How to use XLOOKUP for Complex Lookups in Excel 365
How to use XMATCH in Excel 365
00:04:34

How to use XMATCH in Excel 365
How to do Lookups with Multiple Criteria in Excel 365
00:06:42

How to do Lookups with Multiple Criteria in Excel 365
How to do Lookups with Duplicates in Excel 365
00:06:03

How to do Lookups with Duplicates in Excel 365
How to use the LET Function in Excel 365
00:09:58

How to use the LET Function in Excel 365
How to Create Excel Functions with LAMBDA
00:11:38

How to Create Excel Functions with LAMBDA
How to Create a Data Model in Power Pivot
00:06:56

How to Create a Data Model in Power Pivot
How to Create Relationships Between Tables in Excel 365
00:04:29

How to Create Relationships Between Tables in Excel 365
How to Add Calculated Columns in Excel 365
00:06:16

How to Add Calculated Columns in Excel 365
How to Build a PivotTable from Multiple Sources
00:04:08

How to Build a PivotTable from Multiple Sources
How to Clean Data with Power Query in Excel 365
00:09:37

How to Clean Data with Power Query in Excel 365
How to Combine Files from a Folder with Power Query in Excel 365
00:06:52

How to Combine Files from a Folder with Power Query in Excel 365
Ultimate Guide to the FILTER Function in Excel 365
00:22:17

Ultimate Guide to the FILTER Function in Excel 365
How to Use Calculated Fields and Items in PivotTables
00:09:06

How to Use Calculated Fields and Items in PivotTables
How to Use the SORT Function in Excel 365
00:12:12

How to Use the SORT Function in Excel 365
How to Use the SORTBY Function in Excel 365
00:08:32

How to Use the SORTBY Function in Excel 365
Ultimate Guide to Create Your Own Functions in Excel 365
00:23:27

Ultimate Guide to Create Your Own Functions in Excel 365
How Create Custom Pivot Table Styles
00:08:57

How Create Custom Pivot Table Styles
How to Apply Custom Number Formatting in Excel 365 PivotTables
00:07:04

How to Apply Custom Number Formatting in Excel 365 PivotTables
How to Use Form Checkboxes in Excel 365
00:07:51

How to Use Form Checkboxes in Excel 365
How to Use Macros for Automation in Excel 365
00:07:03

How to Use Macros for Automation in Excel 365
How to Lock Workbooks but not Slicers in PivotTables Filterable and Adjustable Locked Spreadsheets
00:03:35

How to Lock Workbooks but not Slicers in PivotTables Filterable and Adjustable Locked Spreadsheets
How to Record Macros with Relative References in Excel 365
00:07:22

How to Record Macros with Relative References in Excel 365
How to Use the VBA Editor in Excel 365
00:08:19

How to Use the VBA Editor in Excel 365
How to use Copilot to Generate VBA Code
00:05:11

How to use Copilot to Generate VBA Code
How to use AI to Generate Sample Datasets
00:06:27

How to use AI to Generate Sample Datasets
How to Build and Design Charts and Dashboards in Excel
02:20:19

How to Build and Design Charts and Dashboards in Excel
Quickstart Guide to Cleaning Data and Building Reporting Dashboards
02:32:21

Quickstart Guide to Cleaning Data and Building Reporting Dashboards
How to Boost Efficiency in Microsoft Office Top Tips and Expert Hacks
02:19:17

How to Boost Efficiency in Microsoft Office Top Tips and Expert Hacks
Data Models PivotTables and Power Query in Excel
00:47:38

Data Models PivotTables and Power Query in Excel
Conditional Formatting in Excel
00:46:20

Conditional Formatting in Excel
Show More Lessons

Comments

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

We Appreciate Your Feedback

Be the First One Review This Course

Excellent
0 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
0
0 Reviews


Related Courses in Computer Softwares
Excel Power Query
41 Lessons

Excel Power Query

Excel VBA
36 Lessons

Excel VBA

Excel Dashboard
21 Lessons

Excel Dashboard

Excel Course Basic to Advanced
26 Lessons

Excel Course Basic to Advanced

Excel Functions
66 Lessons

Excel Functions

Excel Charting
18 Lessons

Excel Charting

Microsoft Access
23 Lessons

Microsoft Access

Microsoft PowerPoint
52 Lessons

Microsoft PowerPoint

Microsoft Word
46 Lessons

Microsoft Word

Microsoft Excel
49 Lessons

Microsoft Excel

Digital Media Literacy
15 Lessons

Digital Media Literacy

Google Classroom
5 Lessons

Google Classroom

Google Slides
18 Lessons

Google Slides

Google Sheets Full data
15 Lessons

Google Sheets Full data

Google Docs
34 Lessons

Google Docs

Google Drive
11 Lessons

Google Drive

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
Trends
Recent
Previous Lesson Next Lesson