Data Analyst with AI + AWS + Snowflake (Batch-12)

Categories: Data Analyst
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

1. Pre-Requisite Videos

  • Introduction to Excel | Shortcuts | Fill Handle | Flash Fill – Session 01
    01:01:20
  • Sorting | Filtering | Grouping | Custom Sort | Hide and Deleting – Session 02
    01:12:28
  • Mathematical Calculation | Referencing (Relative, Absolute, Mixed) – Session 03
    47:13
  • Numerical Functions in Excel | 3D Referencing – Session 04
    01:37:19

2. Class 01 – Importance of Excel | Keyboard Shortcuts | Functions (PROPER, UPPER, LOWER, SUM, MIN, MAX, AVG, VLOOKUP)

3. Class 02 – Data Types & Formats | Freeze Panel | Data Cleaning (Duplicates, TRIM, SUBSTITUTE, Flash Fill, Text to Columns, CONCATENATE) | Text Functions (LEFT, RIGHT, LEN)

4. Class 03 – Filtering | Sorting | Custom Sorting | Functions (VLOOKUP, XLOOKUP, INDEX, MATCH) | Data Validation | Conditional Formatting

5. Class 04 – Conditional Formatting | Logical Functions (IF, AND, OR, Nested IF) | Conditional Summing & Counting (SUMIF, COUNTIF, SUMIFS, COUNTIFS) | RANK

6. Class 05 – Pivot Tables

7. Class 06 – Customizing Charts (Bar & Column Charts, Line Chart, Pie & Donut Charts, Treemap & Sunburst Charts, Waterfall & Funnel Charts)