-
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!
27 Comments
The content was quite educative and understand. However, my system has a Microsoft Excel 16 installed. I understood you said it will work with the course since they have the same interface. Can I have two versions install and work simultaneously on my system?
Thanks for the update
Interesting
How do I go about to log in on my laptop..was using the phone
Mr. Jameel, how come I installed the software but instead of office 2021 am seeing office 365. When I open excel it’s asking me buy office 365 cause it’s not activated. I just uninstalled the 2013 version where could I have gone wrong?
I already have excel on my pc, please is it still necessary to subscribe or install the new software?
Good morning
Am on unable to watch the remaining vide of microsoft excel I bought. It only repeat the video of how to install the Microsoft excel. Can’t navigate to other videos to continue the lesson
please I cant find the link to download the excel plus is there any need of downloading again if I already have office 2016 in my PC?
I can’t move on to the next video of the xcel class after watching the video on how to install the xcel
How do i get to the course description?
I cannt move to the next video
I have downloaded the MS Office 2021 but it’s requesting password to open the RAR file. Can you help with that please?
please 🙏 I want ask, hope I can still access the course after the 24 hours duration?
Good day Sir, please the cracks folder in the extract of the download is empty so it is asking for product key please. Help me please
please the crack folder in the extract of the download is empty so it is asking for product key please. Help me please. I sent this message some weeks ago
So where is the course I paid for?
I did not pay to learn how to install excel on my PC and please don’t tell me to click any what’s app link.
If you know your platform is not scam and you are not scamming people of their hard earned money; drop the course we paid for here. Or provide reasonable explanation as to why the course paid for is/are not available.
How do I download the entire course so I can watch on pc
Good evening Mr Samuel, please kindly drop your whatsapp line so I can chat directly with you. I can’t find the file to download the excel 2021
https://wa.me/message/WMMO7TI7LCBHH1
Please I’m new here how do I go about the courses
I have downloaded the 2021 software but i cant open or install it i need help please
please, I cannot find the link to the installation file.
Hello sir, how are you….
The office refused to be installed on my PC, a message saying something like: “This product can’t be installed on the selected update channel………..” kept coming up whenever I try. any advice, Sir?
where is the link to the excel setup please
please my progress has greatly been hindered because i cant have access to the whatsapp number
please help start and finish this course to start another one please.
Greetings Sir
the link is not working