Basic Windows Excel & Password Basics скачать в хорошем качестве

Basic Windows Excel & Password Basics

In this instructional video, Jim Cerny, a board member of the Sarasota Technical Users Group (STUG), delivers a comprehensive beginner-friendly class on basic spreadsheets using Microsoft Excel and Google Sheets. The session is designed for users of all levels, especially retirees and casual users, providing an accessible introduction to spreadsheet concepts, functions, and practical applications. Jim emphasizes the importance of spreadsheets as essential tools for managing numbers, investments, expenses, mailing lists, and more. He explains the interface of Excel, including the concept of workbooks and sheets, toolbars, menus (ribbons), and basic navigation. Jim demonstrates how to create, edit, and format spreadsheets, enter data, and use fundamental formulas and functions like addition and SUM. He also covers spreadsheet features such as merging cells, adjusting columns and rows, and creating charts. The video concludes with practical tips on handling formulas when inserting rows and includes a brief Q&A session addressing common concerns and advanced tips like comments and error indicators. Throughout, Jim encourages users to utilize Google for additional help and to experiment with shortcuts and features to improve efficiency. The session is interactive, supportive, and aims to empower users to confidently use spreadsheets for everyday and business needs. Time Stamps 00:00 Welcome, date, holiday greeting, what today’s class is 00:46 Who can attend, how to share the Zoom link, encouraging membership 01:25 What a spreadsheet is (Excel vs Google Sheets) and why it matters 02:10 Practical uses for retirees (expenses, investments, plans) 03:52 Class style, asking questions, shortcuts, and using Google for help 05:19 Quick Q&A and comment on using spreadsheets for mailing lists 06:31 Screen sharing and what software he’ll demonstrate (Excel, compatibility) 08:00 Starting Excel: the “Book” concept and multiple sheets/tabs 10:20 Title bar + Quick Access Toolbar: Save, Undo/Redo, and what “grayed out” means 13:24 Window controls + intro to ribbons/menus and tooltips/help 20:58 Spreadsheet structure: rows, columns, scrolling, and printing considerations 23:11 Cells and addresses, formula bar (cell contents), what can go in a cell 24:46 Entering a title, overflow into empty cells, adjusting column/row size, Undo 29:07 Building the sample: headings, autofill months, entering names and numbers 33:32 Formatting: Merge & Center title, fonts, bold, sizing, alignment tips 38:16 Formulas 101: equal sign, cell references, and a simple addition formula 42:37 SUM function 3 ways: listing cells, using ranges (colon), totaling a whole block 47:21 Enhanced demo sheet: colors, borders, inserting an image, creating a chart 49:46 “Live” chart update when data changes (why charts are powerful) 50:36 Inserting a row and how it can break or preserve formulas (best practices) 56:01 Adding notes/comments and Excel’s error/warning indicators 58:13 Wrap-up, final questions, and sign-off