Microsoft Excel – from Beginner to Advanced → 04 Using templates and pre-built functions

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

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

Prev 03 Navigating and selecting cells, rows and columns

Next 01 Sorting data in Excel

8 Comments

Saheed Olamide Abogunrin

13/09/2023

Please i can’t find the customer information doc on the description. Can you provide the document please

Samuel luri

15/09/2023

please sir, I cant find the template attached to this course

Christian Agana

16/01/2024

Sir please I still can’t find the data set attached for practice in the modules. pls how else can I get it??

Emeka Moronu

24/01/2024

Please I need the data set for the course

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

8 Comments

Leave a Reply to Samuel luri Cancel reply