Curriculum
- 4 Sections
- 46 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- MODULE 1: Excel13
- 1.101 Introduction to MS Excel
- 1.202 Exploring Excel Interface
- 1.303 Understanding Excel Interface Practical
- 1.404 How Excel Interprets Inputs & Basic Formulas
- 1.505 Working With Shortcuts
- 1.606 Exploring Basic Excel Functions
- 1.707 Basic Excel Functions 2
- 1.808 Using Paste Special
- 1.909 Sorting And Filtering
- 1.1010 Advanced Filtering
- 1.1111 Cell Referencing Intro
- 1.1212 Cell Referencing Demo
- 1.13Data Science – Week 1 Assessment1 Question
- MODULE 2:Importing Data from Excel (Data Modelling & DAX on PowerBI)19
- 2.101 Creating Basic Charts
- 2.202 Creating Column Charts
- 2.303 Formatting Your Chart
- 2.404 Formatting Your Chart II
- 2.505 Moving Chart to Another Sheet
- 2.606 Working With Pie Chart
- 2.707 Name Ranges In Excel
- 2.808 Advantages & Disadvantages of Name Ranges
- 2.909 If Function & Named Range
- 2.1010 Using The AND Logical Function
- 2.1111 Combining If & AND Logical Functions
- 2.1212 Using COUNTIF
- 2.1313 Working with SUMIF
- 2.1414 Working With IFERROR
- 2.1515 Working With Vlook UP
- 2.1616 Working With Hlook Up
- 2.1717 Intro To Pivot Tables
- 2.1818 Creating A Pivot
- 2.1919 Grouping & Formatting Your PIVOT
- MODULE 3Installation and Setup6
- MODULE 410