Data Analyst (Batch-09) Certification Program

Categories: MS Excel, Power BI, Python, SQL, Tableau
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Class 01 – Introduction to Excel | Cells Ranges | Numeric Functions (SUM, AVERAGE, MIN, MAX) | Referencing (Relative, Absolute, Mixed) | 3D Referencing | Text Functions (TRIM, CONCAT, PROPER)

  • Data Analyst (Batch-09) – Session 01
    02:00:30

Class 02 – Text Functions (TRIM, CONCAT, PROPER, LEFT, RIGHT, MID) | Logical Functions (IF, AND, OR)

Class 03 –

Class 04 – Data Validation and Conditional Formatting

Class 05 – Logical Functions (IF, AND, OR, IFS, NOT, Nested IFS) | Conditional Functions (SUMIFS, COUNTIFS, AVERAGEIFS) | Lookup Functions (LOOKUP, VLOOKUP) | Ranking and Rounding Functions (RANK, ROUND, SUMPRODUCT) | TEXTJOIN Function

Class 06 – Introduction of Pivot Tables | Basic to Advanced Analysis using Pivot Tables

Class 07 –

Class 08 – Modern Design Interactive Excel Dashboard (Part 01)

Class 09 – Modern Design Interactive Excel Dashboard (Part 02)

Class 10 –

Class 11 –

Class 12 –

Class 13 –

Class 14 –

Class 15 –

Class 16 –

Class 17 –

Class 18 –

Class 19 –

Class 20 –

Class 21 –

Class 22 –

Class 23 –

Class 24 –

Class 25 –

Class 26 –

Class 27 –