Microsoft Excel for beginners
Class Objectives: • What a spreadsheet is and why you might want one • Basic Excel operations • How to build a simple spreadsheet
Prerequisites: • Basic Windows • How to use a mouse • Your keyboard layout • How to use the numeric keypad
What is a Spreadsheet? • Accounting or bookkeeping program that displays information in columns and rows. • Spreadsheet is used to: • Store and organize data • Complete calculations • Manipulate data • Create charts
Excel Windows Columns Name Box Formula Bar Rows Worksheet Tabs
Navigating the Workbook • Worksheet Tabs • Scrollbars • Keyboard
Spreadsheet: Cells & Data • Selecting a Single Cell • Entering Data • Editing Data • Selecting a Range of Cells
Formatting Worksheets • Naming Worksheets • Resizing Cell Blocks • Centering Titles Across Columns • Changing Font Style & Font Size • Formatting Cells with Styles & Alignment
Copy, Cut & Paste • Menu Bar: • Choose Edit, Cut or Copy • Followed by Edit, Paste • “Drag-and-Drop” method
Practice:Set Up an Electronic Checkbook • Enter Worksheet Title • Merge & Center • Enter Column Titles • Format Worksheet & Column Titles • Name Your Worksheet
Practice:Create an Electronic Checkbook Practice your new skills by creating an electronic checkbook like this one!
Saving your Work: Click Save from the File Menu or the Toolbar • Name your document • Select a location to save your document • Click Save 2 1 3 Remember to save often so you won’t lose your work!
Printing Worksheets: • Using Print Preview • See how your worksheet will look on paper • Page Setup commands • Print Commands • File Bar • Ctrl – P • Toolbar Button
Public Training Classes • Free demonstrations are given at Central Library and select branches! • Pick up the Houston Public Library’s Calendar of Events. • For more information Call (832) 393-1313, or visit http://www.houstonlibrary.org