Class Four Text: Conditional formatting, Sort and Filter

Class Four Video

Class Four Quiz

Class Five Text: Data Cleaning in Power Query

Class Five Video

Class Five Quiz

Class Six Text: Pivot Table

Class Six Video

Class Six Quiz

WEEK 2 ASSIGNMENT

Class Seven Text: DATA MANIPULATION IN EXCEL

Class Seven Video

Class Seven Quiz

Class Eight Text (DATA VISUALIZATION)

Class Eight Video

Class Eight Quiz

Class Night Text (BUILDING OF DASHBOARD AND SLICERS

Class Nine Video

Class Nine Quiz

WEEK 3 Assignment

Class Ten Text (Pivot Tables for Business Insights)

Class Ten Video

Class 10 Quiz

Class Eleven Text (Continuation on Dashboard)

Class Eleven Video

Class Eleven Quiz

Class Twelve Text (Q & A)

Class Twelve Video

WEEK 4 ASSIGNMENT

Class Thirteen Text (Introduction to SQL)

Class Thirteen Video

Class Thirteen Quiz

Class Fourteen Text (MODIFYING DATA WITHIN DATABASE)

Class Fourteen Video

Class Fourteen Quiz

Class Fifteen Text (Table designer method and Operators in SQL)

Class Fifteen Video

Class Fifteen Quiz

WEEK 5 ASSIGNMENT

Class Sixteen Text (Logical operators or operational operators)

Class Sixteen Video

Class Sixteen Quiz

Class Seventeen Text (Left, Right and full Join, Group by and Having Statement)

Class Seventeen Video

Class Seventeen Quiz

Class Eighteen Text: (Subqueries, Case Statement and Partition By)

Class Eighteen Video

Class Eighteen Quiz

WEEK 6 ASSIGNMENT

Class Nineteen Text (INTRODUCTION TO POWERBI)

Class Nineteen Video

Class Nineteen Quiz

Class Twenty Text (Pivot, Unpivot, Merge and Append Queries)

Class Twenty Video

Class Twenty Quiz

Class Twenty-one Text (Data Modelling)

Class Twenty-One Video

Class Twenty One Quiz

Class Twenty-Two Text (Optimizes queries in Power BI)

Class Twenty- Two Video

Class Twenty-Two Quiz

Class Twenty-Three Text (Data Analysis Expression )