2014
Tuts+
Bob Flisser
1:54
English

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
1.1 Introduction
1.2 What Can You Do With a Spreadsheet?
1.3 Examining a Spreadsheet
2.Managing Your Files
2.1 Creating Blank Workbooks and Using Templates
2.2 Managing Worksheets
2.3 Understanding File Formats
3.Editing Worksheets
3.1 Editing Techniques
3.2 Setting Up a Simple Worksheet
4.Introducing Formulas and Functions
4.1 How to Write Formulas
4.2 Basic Formula: Adding Numbers in a Simple Worksheet
4.3 Using the Sum Function and the AutoSum Tool
4.4 Using AutoSum to Add a Worksheet in Two Clicks
4.5 Subtraction, Multiplication and Division in Spreadsheets
4.6 Understanding Absolute References
5.Formatting and Sharing Your Spreadsheets
5.1 Formatting Numbers
5.2 Formatting a Worksheet
5.3 Printing and Creating PDFs
5.4 Embedding a Workshseet on a Web Page
6.Conclusion
6.1 Conclusion

Download File Size:1.02 GB

---