1. Business
  2. Spreadsheets

Introduction to Spreadsheets

Bob FlisserLessons: 19Length: 1.9 hours
SpreadsheetsMicrosoft ExcelNumbersMicrosoft Office
Next Lesson

Next lesson playing in 5 seconds

Cancel
  • Overview
  • Transcript

1.1 Introduction

Welcome to Introduction to Spreadsheets. Let's get started! In this lesson you'll learn what spreadsheets are all about, why you would use one, and what everyone did before programs like Microsoft Excel were invented.

1.Introduction
3 lessons, 13:32

1.1
Introduction
04:06

1.2
What Can You Do With a Spreadsheet?
04:50

1.3
Examining a Spreadsheet
04:36

2.Managing Your Files
3 lessons, 19:59

2.1
Creating Blank Workbooks and Using Templates
05:36

2.2
Managing Worksheets
08:54

2.3
Understanding File Formats
05:29

3.Editing Worksheets
2 lessons, 18:16

3.1
Editing Techniques
11:48

3.2
Setting Up a Simple Worksheet
06:28

4.Introducing Formulas and Functions
6 lessons, 33:48

4.1
How to Write Formulas
05:41

4.2
Basic Formula: Adding Numbers in a Simple Worksheet
05:26

4.3
Using the Sum Function and the AutoSum Tool
05:45

4.4
Using AutoSum to Add a Worksheet in Two Clicks
02:19

4.5
Subtraction, Multiplication and Division in Spreadsheets
05:09

4.6
Understanding Absolute References
09:28

5.Formatting and Sharing Your Spreadsheets
4 lessons, 26:49

5.1
Formatting Numbers
07:17

5.2
Formatting a Worksheet
07:40

5.3
Printing and Creating PDFs
07:49

5.4
Embedding a Workshseet on a Web Page
04:03

6.Conclusion
1 lesson, 00:40

6.1
Conclusion
00:40

Bob Flisser
Bob Flisser
Bob Flisser has authored many videos and books about Microsoft and Adobe products, and has been a computer trainer since the 1980s. He is also a web and multimedia developer. Bob is a graduate of The George Washington University with a degree in financial economics.
Course source files