Windows Basics - Spreadsheets

This video is a basic one-hour introductory class on spreadsheets, presented by Jim Cerny, the vice president of the Sarasota Technology Users Group (STUG). The session introduces spreadsheets as a tool for organizing numbers, discussing both Microsoft Excel and Google Sheets. It covers the basic layout of a spreadsheet, including the menu bar, name box, formula bar, columns, rows, and cells. The video demonstrates how to enter and edit data, adjust column width, create headings, merge and center cells, and apply basic formatting options. The tutorial further explains how to add totals using formulas, copy and paste formulas, insert rows, add borders, and create charts. It also touches on formatting numbers as currency, using undo and redo functions, inserting comments, using built-in templates, freezing panes, naming cells, print preview, conditional formulas, workbooks and worksheets, and the Auto Sum feature. The presenter concludes by thanking the attendees and mentioning future classes. 00:02 Introduction to STUG and Spreadsheets 00:38 Spreadsheet Layout and Basic Features 17:16 Entering Data, Formulas, and Functions 30:03 Totals, Copying Formulas, Printing, and Updating 40:21 Creating and Formatting Charts 49:31 Undo/Redo, Templates, Scrolling, and Final Tips 56:58 Importance of Averages and Sums; Encouragement 57:24 Session Wrap-Up and Sheet Terminology 58:06 Extra Q&A: Renaming Sheets and Built-in Functions 01:00:13 Troubleshooting and New Tools 01:01:07 Introduction to Conditional Formulas (IF Statements) 01:02:21 Final Thoughts, Class Info, and Contact