โโ (3h each)
- Introduction to Data & Data analysis life cycle
- Functions
- Arithmetic Operators
- Filter
- More Functions
- Functions with condition
- Relative & Absolute Reference
- Sort & Filter
- Data - Data Validation - Drop down list
- auto fill options - Format Painter
- Functions with more than 1 condition or criteria
- Table and Table Tools
- Charts (Introduction)
- Charts
- Insert Picture
- Static Dashboard
- Pivot Tables
- Pivot Charts
- Slicer
- Dynamic Dashboard
- More in Pivot Tables & Charts
- Date and Time Functions
- Charts Format - save as template
- More in Slicer Settings
- IF Function
- Nested IF - IFS
- More in Pivot Table
- Top 10 - Bottom 10 - Filters
- Slicer
- Sparklines
- Conditional Formatting
- Hyper Link
- VLOOKUP
- HLOOKUP
- Pivot Table (Grouping)
- Revision (Task 7)
- Data Cleaning
- Errors: Duplicated Values - Diff. Data Type - Blank Cells - Spaces - Date & Time - Formatting - Wrong Data
- To insert table, make sure that there is no Header Row / Merge Cells / Blank Rows or Columns / Subtotal
- Logical Formulas
- More in Pivot Tables
- 40 Min (QUIZ)
- Text Functions
- VLOOKUP + MATCH
- INDEX & MATCH
- S1 Power Query
- S2 Power Query
- Add Column >> Custom - Conditional - index - duplicate - multiply
- Merge Queries
- Load to (only create connection)
- Append Queries
- S3 Power Query
- More Transformations
- Combine
- Group by
- +Relationships
- Power Pivot
![](https://private-user-images.githubusercontent.com/92026137/287683650-bbe74c49-c992-4aed-936e-4fdec18a88bf.jpg?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQyNjk1ODAsIm5iZiI6MTcyNDI2OTI4MCwicGF0aCI6Ii85MjAyNjEzNy8yODc2ODM2NTAtYmJlNzRjNDktYzk5Mi00YWVkLTkzNmUtNGZkZWMxOGE4OGJmLmpwZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODIxVDE5NDEyMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWUxMjE0OWQ5NmUyMTc1MDVlNDdlYTE5MjI3NTA3ZDNkZWQxOTRiOWU4OTcxN2Y1N2ViYTgyNWEyYzNjODk0NGEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.HJhZeLjYRxTw0tNfIop_ijwucv1Pm6WQTF0rVP-F5tU)
- S1 Power BI
- Check image:๐
- Drill through analysis
- Tables and Matrix > Cell Elements
- Slicer
- Shapes