Course Features
- Lectures 91
- Quiz 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
- 16 Sections
- 91 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- INTRODUCTION AND SOFTWARE INSTALLATION1
- Understand Microsoft Excel/Google sheet interface5
- Basic Use of Excel/Google sheet4
- Data validation, Filtering, Importing & Exporting8
- 4.1Sorting data in Excel
- 4.2Filtering and using AutoFilter
- 4.3Using conditional formatting for data visualization 2
- 4.4Data validation and Error handling
- 4.5Data validation and Error handling 2
- 4.6Data Importing and exporting techniques
- 4.7Practice question
- 4.8Using conditional formatting for data visualization
- Functions(Mathematical, Logical, Reference & others)9
- 5.1Understand Formula syntax and structure
- 5.2Working with basic Mathematical Functions
- 5.3Working with basic Mathematical Functions 2
- 5.4Using Logical Functions
- 5.5Exploring Lookup and reference Functions
- 5.6Exploring Lookup and reference Functions 2
- 5.7Exploring Lookup and reference Functions 3
- 5.8Utilizing Date and time functions
- 5.9Practice questions
- Pivot table, Data analysis, Advanced filtering10
- 6.1PivotTables and PivotCharts for data analysis
- 6.2PivotTables and PivotCharts for data analysis 2
- 6.3Data analysis with what-if Scenarios
- 6.4Data analysis with what-if Scenarios 2
- 6.5Advanced Filtering techniques
- 6.6Advanced Filtering techniques 2
- 6.7Data consolidation with Analysis using power query
- 6.8Data consolidation with Analysis using power query 2
- 6.9Data consolidation with Analysis using power query 3
- 6.10Practice question
- Customizing Charts7
- Advance Excel7
- Excel Macros6
- Power Query & Data connections4
- Time saving shortcuts, Data entry8
- Protecting sheet4
- Advance Financial and statistical Functions9
- 13.1Array Formulas and Array Functions
- 13.2Array Formulas and Array Functions 2
- 13.3Using INDEX MATCH for advanced Lookup
- 13.4Using INDEX MATCH for advanced Lookup 2
- 13.5Working with text and string functions
- 13.6Working with text and string functions 2
- 13.7Advanced financial and statistical functions
- 13.8Advanced financial and statistical functions 2
- 13.9Test question
- Connecting Excel Data to PowerBI4
- Advance Data Analysis4
- Conclusion1
