About the Course

Are you a working professional looking to elevate your career with data science and machine learning engineering? Our course is designed to equip you with the knowledge and skills needed to excel in the rapidly evolving field of data science. Dive into hands-on projects, learn from industry experts, and take your career to new heights. Join us today and unlock a world of opportunities! Enroll now to secure your spot.

Course Curriculum

8 Chapters · 37 Lessons

  1. 1

    Excel Fundamentals + Essential Formulas

    1. (Included in full purchase)

      Excel interface, ribbon, worksheets

    2. (Included in full purchase)

      Cell referencing: Relative, Absolute, Mixed

    3. (Included in full purchase)

      Basic formatting & shortcuts

    4. (Included in full purchase)

      Essential formulas

  2. 2

    Data Cleaning + Professional Data Handling

    1. (Included in full purchase)

      Remove Duplicates

    2. (Included in full purchase)

      Flash Fill

    3. (Included in full purchase)

      Text to Columns

    4. (Included in full purchase)

      Data Validation

    5. (Included in full purchase)

      Conditional Formatting

    6. (Included in full purchase)

      Find & Replace

    7. (Included in full purchase)

      Excel tables, sorting, filtering

  3. 3

    Lookups, Mapping & Data Relationships

    1. (Included in full purchase)

      VLOOKUP

    2. (Included in full purchase)

      HLOOKUP

    3. (Included in full purchase)

      XLOOKUP

    4. (Included in full purchase)

      INDEX + MATCH

    5. (Included in full purchase)

      MATCH, OFFSET

    6. (Included in full purchase)

      Multi-sheet lookups

    7. (Included in full purchase)

      Mapping datasets

  4. 4

    Pivot Tables + Data Analysis Models

    1. (Included in full purchase)

      Creating Pivot Tables

    2. (Included in full purchase)

      Grouping (dates, categories, numbers)

    3. (Included in full purchase)

      Calculated fields

    4. (Included in full purchase)

      Pivot charts

    5. (Included in full purchase)

      Drill-down analysis

    6. (Included in full purchase)

      Slicers & timelines

    7. (Included in full purchase)

      KPI analysis

  5. 5

    Data Visualization + Excel Dashboards

    1. (Included in full purchase)

      Charts: Bar, Column, Line, Area, Pie, Donut, Histogram

    2. (Included in full purchase)

      KPI Cards

    3. (Included in full purchase)

      Dynamic charts

    4. (Included in full purchase)

      Slicers + interactive elements

    5. (Included in full purchase)

      Dashboard layout design

  6. 6

    Project Work

    1. (Included in full purchase)

      Sales & Revenue Analytics Dashboard

  7. 7

    Introduction to Databases & SQL

    1. (Included in full purchase)

      What is a database?

    2. (Included in full purchase)

      SQL vs MySQL vs others

    3. (Included in full purchase)

      Relational database concepts

    4. (Included in full purchase)

      Tables, rows, columns, keys

  8. 8

    MySQL Installation & Setup

    1. (Included in full purchase)

      Installing MySQL Server

    2. (Included in full purchase)

      Using MySQL Workbench