Curriculum

  • 1

    Introduction

    • Range

    • Formulas & Functions

    • Ribbon

    • Workbook

    • Worksheets

    • Format Cells

    • Find & Select

    • Templates

    • Data Validation

    • Keyboard Shortcuts

    • Print

    • Share

    • Protect

    • Protect
  • 2

    Functions

    • Count and Sum Functions

    • Logical Functions

    • Cell references

    • Date & Time

    • Text functions

    • Lookup & references

    • Financial functions

    • Statistical Functions

    • Round numbers

    • Formula errors

    • Array formulas
  • 3

    Data Analysis

    • Sort

    • Filter

    • Conditional formatting

    • Pivot tables

    • What-if analysis

    • Solver

    • Analysis ToolPak

    • Histogram

    • Descriptive Statistics

    • Anova

    • F-test

    • t-Test

    • Moving average

    • Exponential smoothing

    • Correlation

    • Regression
  • 4

    VBA Overview

    • Create a macro

    • MsgBox

    • Workbook & Worksheet objects

    • Range objects

    • Variables

    • If-Then statements

    • Loop

    • Macro errors

    • String manipulation

    • Date & Time

    • Events

    • Array

    • Function and Sub

    • Application object

    • Active X Controls

    • Userform