Course curriculum

  • 1

    Power point Slide

    • Slide deck

  • 2

    Templates (Excel and Smartsheet)

    • Production Schedule

    • Week at a glance intro

    • Budget template Pivot table

  • 3

    Mini Project

    • Mini Project

  • 4

    CHAPTER 0 : INTRODUCTION

    • Contact info for instructor

    • Copy of How to use this course

  • 5

    CHAPTER E1: INTRO TO EXCEL

    • What is Excel

    • Parts of Excel

    • Data entry for Excel

    • New document creation and saving

    • Special input in Excel

    • Excel Intro PIT STOP

    • EXCEL INTRO QUIZ

  • 6

    CHAPTER E2: EXCEL FORMATTING

    • CHAPTER 2 DOWNLOADS

    • Formatting 101

    • Formatting Tables

    • Conditional Formatting

    • Name Ranges

    • Worksheet Adjustments

    • Adding Borders

    • Real World Formatting

    • Cell Styles

    • CHAPTER 2: EXCEL FORMATTING QUIZ

  • 7

    CHAPTER E3: EXCEL TABLES

    • CHAPTER 3 DOWNLOADS

    • TABLES

    • Chapter 3 QUIZ: Excel Tables

  • 8

    CHAPTER E4: EXCEL FORMULAS

    • Formula Basics

    • Cell Reference 101

    • How to show the formula used in a sheet

    • Fixing Errors

    • Putting it all together: Excel Formulas 1

    • Putting it all together: Excel Formulas 2

    • Chapter 4 Downloads

    • Chapter 4 Quiz FORMULAS

  • 9

    CHAPTER E5: EXCEL FUNCTIONS

    • Functions 101

    • Functions 101 (part 2)

    • Functions 201

    • V LOOKUP (LONG)

    • V LOOKUP (SHORT)

    • YEARFRAC & COUNT

    • COUNTIF

    • HOW TO FIND OTHER FUNCTIONS

    • NESTED IF

    • ASSIGNMENT 5 FUNCTIONS

    • QUIZ 5: FUNCTIONS

  • 10

    CHAPTER E6: PRINTING, EXPORTING AND SHARING

    • PRINTING

    • QUIZ 6: PRINTING

  • 11

    CHAPTER E7: GRAPHS, GRAPHICS, AND PRESENTATIONS

    • GENERATING GRAPHS

    • GRAPHS AND PRESENTATION

    • GRAPHS PIT STOP (PUTTING IT TOGETHER)

    • QUIZ 7: GRAPHS