-
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!
6 Comments
Even though I had previous experience in data entry, this lesson broadened my knowledge of some automatic logic I never knew. Great tutoring.
THE TIME SPENT WORTH IT.
Fantastic discovery.
i gaining right knowledge
Great explanation… Made me understand I can have my Data analyzed monthly in 1 book with different sheets for each day.
Thank You Soo Much Sir Jameel