Skip to main content

Lecture Slides

Lecture 1 - Introduction

Lecture 2 - Introduction to Excel

Lecture 3 - Excel Tables

Lecture 4 - Excel Formatting

Lecture 5 - Excel Formulas and Functions I

Lecture 6 - Excel Formulas and Functions II

Lecture 7 - Excel Charts

Lecture 8 - Excel PivotTables

Lecture 9 - Excel What-If Analysis

Lecture 10 - Excel Formulas and Functions III

Lecture 11 - Access: The Basics

Lecture 12 - Access:  Fields & Keys

Lecture 13 - Access: Database Creation

Lecture 14 - Access: Queries I

Lecture 15 - Access: Queries II

Lecture 16 - Access: Queries III

Lecture 17 & 18 - Access: Forms and Reports

Lecture 19:  Access: Queries IV

Lecture 20:  Word:  Styles & Illustrations

Lecture 21:  Word:  Layout & Pagination

Lecture 22:  Word: References & Workflow

Lecture 23:  Powerpoint: Layout & Formatting

Lecture Slides courtesy of LIngwei Chen and Denny Hood.