-
Introduction and Software installation 2
-
Installation of Office 2021 software 06 minLecture1.1
-
Installation of Office 365 software(Optional) 11 minLecture1.2
-
-
Module 1 - Understand Microsoft Excel interface 4
-
01 Introduction to Excel 09 minLecture2.1
-
02 Excel interface and Navigation 12 minLecture2.2
-
03 Basic data entry and cell formatting 09 minLecture2.3
-
03 Basic data entry and cell formatting 2 11 minLecture2.4
-
-
Module 2 - Basic Use of Excel 4
-
01 Managing workbooks and worksheets 09 minLecture3.1
-
02 Inserting, deleting, and renaming sheets 05 minLecture3.2
-
03 Navigating and selecting cells, rows and columns 03 minLecture3.3
-
04 Using templates and pre-built functions 03 minLecture3.4
-
-
Module 3 - Data validation, Filtering, Importing & Exporting 8
-
01 Sorting data in Excel 10 minLecture4.1
-
02 Filtering and using AutoFilter 06 minLecture4.2
-
03 Using conditional formatting for data visualization 03 minLecture4.3
-
03 Using conditional formatting for data visualization 2 11 minLecture4.4
-
04 Data validation and Error handling 11 minLecture4.5
-
04 Data validation and Error handling 2 07 minLecture4.6
-
05 Data Importing and exporting techniques 06 minLecture4.7
-
06 Practice question 01 minLecture4.8
-
-
Module 4 - Functions(Mathematical, Logical, Reference & others) 9
-
01 Understand Formula syntax and structure 10 minLecture5.1
-
02 Working with basic Mathematical Functions 06 minLecture5.2
-
02 Working with basic Mathematical Functions 2 11 minLecture5.3
-
03 Using Logical Functions 10 minLecture5.4
-
04 Exploring Lookup and reference Functions 10 minLecture5.5
-
04 Exploring Lookup and reference Functions 2 11 minLecture5.6
-
04 Exploring Lookup and reference Functions 3 09 minLecture5.7
-
05 Utilizing Date and time functions 06 minLecture5.8
-
06 Practice questions 01 minLecture5.9
-
-
Module 5 - Pivot table, Data analysis, Advanced filtering 10
-
01 PivotTables and PivotCharts for data analysis 12 minLecture6.1
-
01 PivotTables and PivotCharts for data analysis 2 10 minLecture6.2
-
02 Data analysis with what-if Scenarios 10 minLecture6.3
-
02 Data analysis with what-if Scenarios 2 08 minLecture6.4
-
03 Advanced Filtering techniques 08 minLecture6.5
-
03 Advanced Filtering techniques 2 11 minLecture6.6
-
04 Data consolidation with Analysis using power query 07 minLecture6.7
-
04 Data consolidation with Analysis using power query 2 11 minLecture6.8
-
04 Data consolidation with Analysis using power query 3 12 minLecture6.9
-
05 Practice question 01 minLecture6.10
-
-
Module 6 - Customizing Charts 7
-
01 Creating and Customizing Charts 08 minLecture7.1
-
01 Creating and Customizing Charts 2 11 minLecture7.2
-
02 Sparklines and Conditional Charts 11 minLecture7.3
-
03 Advanced Charting Techniques and Tips 07 minLecture7.4
-
04 Data Visualization Best practices 08 minLecture7.5
-
05 Practice question 01 minLecture7.6
-
Test project 0060 01 minLecture7.7
-
-
Module 7 - Advance Excel 7
-
01 Using data tables for sensitivity Analysis 13 minLecture8.1
-
01 Using data tables for sensitivity Analysis 02 12 minLecture8.2
-
02 Goal seek for finding Desired results 13 minLecture8.3
-
03 – Solver for optimization problems 10 minLecture8.4
-
04 – Scenario Manager for Multiple scenarios Analysis 11 minLecture8.5
-
04 – Scenario Manager for Multiple scenarios Analysis 2 06 minLecture8.6
-
05 Practice question 01 minLecture8.7
-
-
Module 8 - Excel Macros 6
-
01 Introduction to Excel Macros 09 minLecture9.1
-
02 Recording and running Simple Macros 06 minLecture9.2
-
03 Editing and Debugging Macros 06 minLecture9.3
-
04 Best practices for macros and security consideration 03 minLecture9.4
-
04 Best practices for macros and security consideration 2 02 minLecture9.5
-
05 Practice questions 01 minLecture9.6
-
-
Module 9 - Power Query & Data connections 4
-
01 Importing Data from External sources 07 minLecture10.1
-
02 Using power query to connect to various data sources 08 minLecture10.2
-
03 Refreshing Data Connections 05 minLecture10.3
-
04 Practice Question 01 minLecture10.4
-
-
Module 10 - Time saving shortcuts, Data entry 8
-
01 Time saving keyboard shortcuts 12 minLecture11.1
-
01 Time saving keyboard shortcuts 2 05 minLecture11.2
-
02 – Customizing Excel settings and options 08 minLecture11.3
-
03 Advanced printing and page setup Techniques 10 minLecture11.4
-
03 Advanced printing and page setup Techniques 2 12 minLecture11.5
-
04 Efficient data entry methods 07 minLecture11.6
-
04 Efficient data entry methods 2 08 minLecture11.7
-
05 Practice question 01 minLecture11.8
-
-
Module 11 - Protecting sheet 5
-
01 Protecting sheets and workbooks 05 minLecture12.1
-
01 Protecting sheets and workbooks 2 09 minLecture12.2
-
02 Sharing workbooks with others 11 minLecture12.3
-
03 Practice question 01 minLecture12.4
-
Test project 0011 01 minLecture12.5
-
-
Module 12 - Advance Financial and statistical Functions 9
-
01 Array Formulas and Array Functions 11 minLecture13.1
-
01 Array Formulas and Array Functions 2 09 minLecture13.2
-
02 Using INDEX MATCH for advanced Lookup 08 minLecture13.3
-
02 Using INDEX MATCH for advanced Lookup 2 07 minLecture13.4
-
03 Working with text and string functions 08 minLecture13.5
-
03 Working with text and string functions 2 06 minLecture13.6
-
04 Advanced financial and statistical functions 09 minLecture13.7
-
04 Advanced financial and statistical functions 2 09 minLecture13.8
-
05 Test question 01 minLecture13.9
-
-
Module 13 - Connecting Excel Data to PowerBI 4
-
01 Overview of PowerBi and Excel integration 09 minLecture14.1
-
02 Connecting Excel Data to PowerBi 07 minLecture14.2
-
03 Creating PowerBi Reports from Excel Data 09 minLecture14.3
-
04 Practice Question 01 minLecture14.4
-
-
Module 14 - Advance Data Analysis 5
-
01 Advanced Formula Auditing and Error handling 12 minLecture15.1
-
02 Using Advanced Data Analysis Tools 09 minLecture15.2
-
03 Leveraging the Excel Developer Tab for Customization 07 minLecture15.3
-
04 Practice question 01 minLecture15.4
-
Test QuestionLecture15.5
-
-
Conclusion 1
-
Conclusion 01 minLecture16.1
-
This content is protected, please login and enroll course to view this content!
11 Comments
Please sir, where am I going to submit my answers to the questions? Thanks
I have done the exercise and it is very practical and interesting, i have enjoyed doing it.
Done and awesome
Thank you, got it now.
I got the answers to the questions. It took me a while to figure it out, but I finally figured it out. I’m so happy!
Am so happy i was able to solve it. thank you
how do i crack the ms office after installation i cant find out my way.. kindly elp pls
Done and dusted with this very practice questions, no issues, thanks to the tutor, Mr. Jameel Bin Abdullahi thus so far
really enjoying the lessons i have watched so far.it been very insightful