Price$100$50

Section 1Week 1: Prepare your data for analysis
Lecture 1CREATE TEMPLATE FORM WITH DATA VALIDATIONS
Lecture 2USE CONDITIONAL FORMATTING TO CHECK DUPLICATES
Lecture 3CREATE AND MANAGE TABLES TO REMOVE DUPLICATES
Lecture 4CLEAN YOUR DATA
Section 2Week 2- Data Analysis
Lecture 5INTRODUCTION TO PIVOT
Lecture 6CREATE AND MANAGE PIVOTTABLES
Lecture 7CREATE AND MANAGE PIVOT CHARTS
Section 3Week 3- Dashboards (Dynamic/Interactive or Standard)
Lecture 8DYNAMIC DASHBOARD
Lecture 9STANDARD DASHBOARD