Course curriculum

  • 1

    WELCOME

    • WELCOME TO DATA ANALYSIS IN EXCEL COURSE
  • 2

    INTRODUCTION

    • About this course
  • 3

    1: FORMULA FUNDAMENTALS

    • Formula Fundamentals

    • Assignment 1
  • 4

    2: CELL REFERENCING

    • Cell Referencing

    • Assignment 2
  • 5

    3: USEFUL DATA CLEANSING PROCESSES

    • Useful Data Cleansing Processes

    • Assignment 3
  • 6

    4: DATE MANIPULATION

    • Date Manipulation

    • Assignment 4
  • 7

    5: TEXT MANIPULATION

    • Text Manipulation

    • Assignment 5
  • 8

    6: LOGICAL STATEMENTS

    • Logical Statements

    • Assignment 6
  • 9

    7: RETRIEVING AND RECONCILLING DATA

    • Retrieving and Reconciling Data

    • Assignment 7
  • 10

    8: SUMMARIZING DATA

    • Summarizing Data

    • Assignment 8
  • 11

    9: VISUAL REPRESENTATION OF DATA

    • Visual Representation of Data

    • Assignment 9
  • 12

    Post-Training Survey

    • Trainee Feedback Questionnaire