Curriculum
- 7 Sections
- 72 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Module 112
- 1.101 Introduction to Ms Excel
- 1.202 Exploring Excel Interface
- 1.303 Understanding Excel Interface Practical
- 1.404 How excel interprets inputs & basic formula’s
- 1.505 Working with Shortcuts
- 1.606 Basic Excel Functions
- 1.707 Basic Excel Functions 2
- 1.808 Using Paste Special
- 1.909 Sorting & Filtering
- 1.10010 Advanced Filtering
- 1.11011 Cell Referencing Intro
- 1.1212 Cell Referencing
- Module 219
- 2.101 Creating Basic Charts
- 2.202 Creating Column Charts
- 2.303 Formatting your Chart
- 2.404 Formatting Chart II
- 2.505 Moving Chart To Another Sheet
- 2.606 Working with Pie Chart
- 2.707 Name Ranges in Excel
- 2.808 Advantage and 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 35
- Module 48
- Module 58
- Module 69
- Module 711
- 7.101 DAX Introduction
- 7.202 Creating your first Measure
- 7.303 Using Iteraring Aggregators
- 7.404 Why Creating a Date Table is Important
- 7.505 Generating our DateTable with CalenderAuto & Year
- 7.606 Creating other Month Attribute & Commenting on Dax code
- 7.707 Testing Column Sort
- 7.808 Calculate function
- 7.909 Using the OR operator
- 7.1010 Time Intelligence functions
- 7.1111 Creating a folder for Measures
02 Exploring Excel Interface
Next