Course curriculum

  • 1

    Introduction - Welcome to the course

    • Introduction - Welcome to the course

    • Download Workshop Files

    • Course Presentation

    • Excel Pros and Cons
  • 2

    Unit 1 - Must Know Excel Functions

    • TRIM and LEN Functions

    • The Sergeon Functions - Part 1

    • The Sergeon Functions - Part 2

    • FIND and SUBSTITUTE Functions

    • Date Functions - Part 1

    • Date Functions - Part 2

    • Date Functions - Part 3

    • WROKDAY WORKDAY.INTL Functions

    • NETWORKDAYS NETWROKDAYS.INTL Functions

    • Find duration using DATEDID Function

    • Find Duration using DAYS Function

    • Conditional Calculation using COUNTIF Function

    • Conditional Calculation using SUMIF AVERAGEIF Functions

    • Conditional Calculation using COUNTIFS Function

    • Conditional Calculation using SUMIFS AVERAGEIFS functions

    • Unit 1 Conclusion

    • Unit 1 - Review workshop

    • Unit 1 - Quick Quiz
  • 3

    Unit 2 - Data analysis techniques - Report project KPI's

    • Introduction to Unit 2

    • Create Pivot Table

    • Pivot Table Design Tab and Number Format

    • Date Analysis in Pivot Table

    • 23.0 Using Columns Filters Dimensions

    • Summarize Values by

    • Show Values as

    • Insert Calculated Field

    • Unit 2 Conclusion

    • Unit 2 - Review Workshop

    • Unit 2 - Quick Quiz
  • 4

    Unit 3 - Graphs and Charts Techniques

    • Unit 3 Introduction

    • Line chart

    • Two sets of data

    • Area chart

    • Logarithmic scale

    • Column chart

    • Dynamic Column coloring chart

    • Bar chart

    • Dual chart secondary axis

    • Pie chart

    • Pie chart alternative

    • Progress Doughnut

    • In-cell charts

    • Top Bottom Ranking

    • Budget Actual Variance Column chart

    • Budget Actual Variance Line chart

    • Median chart

    • Bullet graph

    • Scatter plot

    • Bubble

    • Waterfall Built-up

    • Waterfall Built-down

    • Treemap

    • Sunburst

    • Histogram

    • Pareto

    • Unit 3 conclusion

    • Unit 3 - Review Workshop

    • Unit 3 - Quick Quiz
  • 5

    Unit 4 - Dashboard Design Principles and Techniques

    • Unit 4 Introduction

    • Dashboard Design Principles

    • Dashboard Types and Decision Flowchart

    • Dashboard Design Instructions

    • Create Dashboard Layout Page

    • Create Pivot Reports - Part 1

    • Create Pivot Reports - Part 2

    • Create Score Cards

    • Create Charts

    • Dashboard Dynamic Filter using Slicer

    • Final Tuning Dashboard

    • Unit 4 Conculsion

    • Unit 4 - Quick Quiz
  • 6

    Unit 5 - Create Project Management Excel Templates

    • Unit 5 - Introduction

    • Gantt Chart

    • Budget Sheet

    • Unit 5 Conculsion
  • 7

    Unit 6 - Case Study - Final Project

    • Case Study Instructions
  • 8

    Course Summary

    • Course Summary

    • Final Quiz