View Course Overview for Available CPE and Access Options

Introduction to Excel Training: Mastering Fundamental Functions

Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  0:47PREVIEW: Introduction to Excel Training: Mastering Fundamental Functions
Lessons
  Trap Errors with IFERROR4:15
  The IF Function3:32
  List Comparisons3:30
  The ISERROR Function7:04
  Multicolumn List Comparisons with COUNTIFS6:46
  Indentation6:15
  Perform Lookups with SUMIFS8:02
  Determine the Last Day of the Month with EOMONTH7:50
  Date Parts - MONTH and YEAR2:40
CONTINUOUS PLAY
  Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and more49:56
SUPPORTING MATERIALS
  WorksheetsZIP FILE
  Mastering Fundamental Functions Glossary/IndexPDF
REVIEW & TEST
  Review Questionsquiz
 Final Examexam