Microsoft Excel - from Beginner to Advanced

This content is protected, please login and enroll course to view this content!

Prev Installation of Office 2021 software

Next 01 Introduction to Excel

24 Comments

Catherine Mumba

10/09/2023

Awesome

Oluchi Umosen

18/09/2023

Should I delete the old version that I have on my cp

Olasupo Lekan

18/09/2023

How can I get software if I do not have money for subscription on Microsoft word for excel

Sunday Peace Urebuchi

29/09/2023

Does it mean that when u subscription ends it wouldn’t open again?

Veronica

31/10/2023

Wow 😮 I have enjoyed learning this and how to create my own account it was awesome 👍 thanks 🙏

Toluwalope Oloruntomi

28/11/2023

Good day. Please I need the data set for the course. Thanks

Moses Reath Chuol

01/12/2023

completed

Akindunbi Seyifunmi

30/12/2023

There no link below the video

Nwafor Ernest

15/02/2024

good day, please it’s not openning on my laptop

Muritala Rasheed Babatunde

18/02/2024

Where is the link to install the office software?

Justice Atsu

29/03/2024

where is the link for the office 365? the one you posted is only for the excel 2021.
my own wont open without activation

Agwu Jeremiah ifeanyi

29/03/2024

pls i want a link to download office 365, i would be needing the cloud service, you uploaded the video for office 21 twice

Onyinyechi Cynthia Nome

02/05/2024

Please i am not able to locate the Microsoft 365 from the video

Leave A Reply Cancel reply

Introduction and Software installation 2
- Lecture1.1
  
  Installation of Office 2021 software 06 min
- Lecture1.2
  
  Installation of Office 365 software(Optional) 11 min
Module 1 - Understand Microsoft Excel interface 4
- Lecture2.1
  
  01 Introduction to Excel 09 min
- Lecture2.2
  
  02 Excel interface and Navigation 12 min
- Lecture2.3
  
  03 Basic data entry and cell formatting 09 min
- Lecture2.4
  
  03 Basic data entry and cell formatting 2 11 min
Module 2 - Basic Use of Excel 4
- Lecture3.1
  
  01 Managing workbooks and worksheets 09 min
- Lecture3.2
  
  02 Inserting, deleting, and renaming sheets 05 min
- Lecture3.3
  
  03 Navigating and selecting cells, rows and columns 03 min
- Lecture3.4
  
  04 Using templates and pre-built functions 03 min
Module 3 - Data validation, Filtering, Importing & Exporting 8
- Lecture4.1
  
  01 Sorting data in Excel 10 min
- Lecture4.2
  
  02 Filtering and using AutoFilter 06 min
- Lecture4.3
  
  03 Using conditional formatting for data visualization 03 min
- Lecture4.4
  
  03 Using conditional formatting for data visualization 2 11 min
- Lecture4.5
  
  04 Data validation and Error handling 11 min
- Lecture4.6
  
  04 Data validation and Error handling 2 07 min
- Lecture4.7
  
  05 Data Importing and exporting techniques 06 min
- Lecture4.8
  
  06 Practice question 01 min
Module 4 - Functions(Mathematical, Logical, Reference & others) 9
- Lecture5.1
  
  01 Understand Formula syntax and structure 10 min
- Lecture5.2
  
  02 Working with basic Mathematical Functions 06 min
- Lecture5.3
  
  02 Working with basic Mathematical Functions 2 11 min
- Lecture5.4
  
  03 Using Logical Functions 10 min
- Lecture5.5
  
  04 Exploring Lookup and reference Functions 10 min
- Lecture5.6
  
  04 Exploring Lookup and reference Functions 2 11 min
- Lecture5.7
  
  04 Exploring Lookup and reference Functions 3 09 min
- Lecture5.8
  
  05 Utilizing Date and time functions 06 min
- Lecture5.9
  
  06 Practice questions 01 min
Module 5 - Pivot table, Data analysis, Advanced filtering 10
- Lecture6.1
  
  01 PivotTables and PivotCharts for data analysis 12 min
- Lecture6.2
  
  01 PivotTables and PivotCharts for data analysis 2 10 min
- Lecture6.3
  
  02 Data analysis with what-if Scenarios 10 min
- Lecture6.4
  
  02 Data analysis with what-if Scenarios 2 08 min
- Lecture6.5
  
  03 Advanced Filtering techniques 08 min
- Lecture6.6
  
  03 Advanced Filtering techniques 2 11 min
- Lecture6.7
  
  04 Data consolidation with Analysis using power query 07 min
- Lecture6.8
  
  04 Data consolidation with Analysis using power query 2 11 min
- Lecture6.9
  
  04 Data consolidation with Analysis using power query 3 12 min
- Lecture6.10
  
  05 Practice question 01 min
Module 6 - Customizing Charts 7
- Lecture7.1
  
  01 Creating and Customizing Charts 08 min
- Lecture7.2
  
  01 Creating and Customizing Charts 2 11 min
- Lecture7.3
  
  02 Sparklines and Conditional Charts 11 min
- Lecture7.4
  
  03 Advanced Charting Techniques and Tips 07 min
- Lecture7.5
  
  04 Data Visualization Best practices 08 min
- Lecture7.6
  
  05 Practice question 01 min
- Lecture7.7
  
  Test project 0060 01 min
Module 7 - Advance Excel 7
- Lecture8.1
  
  01 Using data tables for sensitivity Analysis 13 min
- Lecture8.2
  
  01 Using data tables for sensitivity Analysis 02 12 min
- Lecture8.3
  
  02 Goal seek for finding Desired results 13 min
- Lecture8.4
  
  03 – Solver for optimization problems 10 min
- Lecture8.5
  
  04 – Scenario Manager for Multiple scenarios Analysis 11 min
- Lecture8.6
  
  04 – Scenario Manager for Multiple scenarios Analysis 2 06 min
- Lecture8.7
  
  05 Practice question 01 min
Module 8 - Excel Macros 6
- Lecture9.1
  
  01 Introduction to Excel Macros 09 min
- Lecture9.2
  
  02 Recording and running Simple Macros 06 min
- Lecture9.3
  
  03 Editing and Debugging Macros 06 min
- Lecture9.4
  
  04 Best practices for macros and security consideration 03 min
- Lecture9.5
  
  04 Best practices for macros and security consideration 2 02 min
- Lecture9.6
  
  05 Practice questions 01 min
Module 9 - Power Query & Data connections 4
- Lecture10.1
  
  01 Importing Data from External sources 07 min
- Lecture10.2
  
  02 Using power query to connect to various data sources 08 min
- Lecture10.3
  
  03 Refreshing Data Connections 05 min
- Lecture10.4
  
  04 Practice Question 01 min
Module 10 - Time saving shortcuts, Data entry 8
- Lecture11.1
  
  01 Time saving keyboard shortcuts 12 min
- Lecture11.2
  
  01 Time saving keyboard shortcuts 2 05 min
- Lecture11.3
  
  02 – Customizing Excel settings and options 08 min
- Lecture11.4
  
  03 Advanced printing and page setup Techniques 10 min
- Lecture11.5
  
  03 Advanced printing and page setup Techniques 2 12 min
- Lecture11.6
  
  04 Efficient data entry methods 07 min
- Lecture11.7
  
  04 Efficient data entry methods 2 08 min
- Lecture11.8
  
  05 Practice question 01 min
Module 11 - Protecting sheet 5
- Lecture12.1
  
  01 Protecting sheets and workbooks 05 min
- Lecture12.2
  
  01 Protecting sheets and workbooks 2 09 min
- Lecture12.3
  
  02 Sharing workbooks with others 11 min
- Lecture12.4
  
  03 Practice question 01 min
- Lecture12.5
  
  Test project 0011 01 min
Module 12 - Advance Financial and statistical Functions 9
- Lecture13.1
  
  01 Array Formulas and Array Functions 11 min
- Lecture13.2
  
  01 Array Formulas and Array Functions 2 09 min
- Lecture13.3
  
  02 Using INDEX MATCH for advanced Lookup 08 min
- Lecture13.4
  
  02 Using INDEX MATCH for advanced Lookup 2 07 min
- Lecture13.5
  
  03 Working with text and string functions 08 min
- Lecture13.6
  
  03 Working with text and string functions 2 06 min
- Lecture13.7
  
  04 Advanced financial and statistical functions 09 min
- Lecture13.8
  
  04 Advanced financial and statistical functions 2 09 min
- Lecture13.9
  
  05 Test question 01 min
Module 13 - Connecting Excel Data to PowerBI 4
- Lecture14.1
  
  01 Overview of PowerBi and Excel integration 09 min
- Lecture14.2
  
  02 Connecting Excel Data to PowerBi 07 min
- Lecture14.3
  
  03 Creating PowerBi Reports from Excel Data 09 min
- Lecture14.4
  
  04 Practice Question 01 min
Module 14 - Advance Data Analysis 5
- Lecture15.1
  
  01 Advanced Formula Auditing and Error handling 12 min
- Lecture15.2
  
  02 Using Advanced Data Analysis Tools 09 min
- Lecture15.3
  
  03 Leveraging the Excel Developer Tab for Customization 07 min
- Lecture15.4
  
  04 Practice question 01 min
- Lecture15.5
  
  Test Question
Conclusion 1
- Lecture16.1
  
  Conclusion 01 min

24 Comments

Leave A Reply Cancel reply

Introduction and Software installation 2

Module 1 - Understand Microsoft Excel interface 4

Module 2 - Basic Use of Excel 4

Module 3 - Data validation, Filtering, Importing & Exporting 8

Module 4 - Functions(Mathematical, Logical, Reference & others) 9

Module 5 - Pivot table, Data analysis, Advanced filtering 10

Module 6 - Customizing Charts 7

Module 7 - Advance Excel 7

Module 8 - Excel Macros 6

Module 9 - Power Query & Data connections 4

Module 10 - Time saving shortcuts, Data entry 8

Module 11 - Protecting sheet 5

Module 12 - Advance Financial and statistical Functions 9

Module 13 - Connecting Excel Data to PowerBI 4

Module 14 - Advance Data Analysis 5

Conclusion 1