Skip to main content

Lecture Slides

Lecture 1:  Course Introduction

Lecture 2:  Excel Basics

Lecture 3:  Excel Tables

Lecture 4:  Excel Formatting

Lecture 5:  Excel Formulas I

Lecture 6:  Excel Formulas II

Lecture 7:  Excel Charts

Lecture 8:  Excel PivotTables and PivotCharts

Lecture 10:  Excel What-If Analysis

Lecture 11:  Excel Formulas III

Lecture 12:  Excel Solver

Lecture 15:  Access Basics

Lecture 16:  Access Fields & Keys

Lecture 17:  Access Database Creation

Lecture 18:  Access Queries I

Lecture 19:  Access Queries II

Lecture 20:  Access Queries III

Lecture 21:  Access Forms

Lecture 22:  Access Reports

Lecture 23:  Access Queries IV

Lecture 24:  Access SQL