Introduction to Spreadsheets

Bob FlisserSep 8, 2014Lessons: 19Length: 1.9 hours

Next lesson playing in 5 seconds

Cancel

Introduction to Spreadsheets

Introduction

04:06

Introduction to Spreadsheets will teach you the essentials of how to use spreadsheets, focusing mostly on Microsoft Excel. Learn how to manage workbooks, edit sheets, write formulas, use functions, format worksheets, make printouts, and create PDFs. Upon completing this course, you will have a solid foundation of how to use any spreadsheet program.

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 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.

BobFlisser

Introduction to Spreadsheets

Next lesson playing in 5 seconds

Introduction to Spreadsheets

Introduction

1.Introduction3 lessons, 13:32

2.Managing Your Files3 lessons, 19:59

3.Editing Worksheets2 lessons, 18:16

4.Introducing Formulas and Functions6 lessons, 33:48

5.Formatting and Sharing Your Spreadsheets4 lessons, 26:49

6.Conclusion1 lesson, 00:40

1.Introduction
3 lessons, 13:32

2.Managing Your Files
3 lessons, 19:59

3.Editing Worksheets
2 lessons, 18:16

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

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

6.Conclusion
1 lesson, 00:40