Microsoft Excel – from Beginner to Advanced → 01 PivotTables and PivotCharts for data analysis

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 06 Practice questions

Next 01 PivotTables and PivotCharts for data analysis 2

4 Comments

Banjo Adebayo

18/02/2024

I still can’t download the course File. Kindly assist.
Thank you.

Chidubem Dominic ChiDollar$$

04/04/2024

Sir i have already downloaded the file but can’t access it sir

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

4 Comments

Leave a Reply to Banjo Adebayo Cancel reply