microsoft excel n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Excel PowerPoint Presentation
Download Presentation
Microsoft Excel

Loading in 2 Seconds...

play fullscreen
1 / 14

Microsoft Excel

21 Views Download Presentation
Download Presentation

Microsoft Excel

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Microsoft Excel for beginners

  2. Class Objectives: • What a spreadsheet is and why you might want one • Basic Excel operations • How to build a simple spreadsheet

  3. Prerequisites: • Basic Windows • How to use a mouse • Your keyboard layout • How to use the numeric keypad

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

  5. Excel Windows Columns Name Box Formula Bar Rows Worksheet Tabs

  6. Navigating the Workbook • Worksheet Tabs • Scrollbars • Keyboard

  7. Spreadsheet: Cells & Data • Selecting a Single Cell • Entering Data • Editing Data • Selecting a Range of Cells

  8. Formatting Worksheets • Naming Worksheets • Resizing Cell Blocks • Centering Titles Across Columns • Changing Font Style & Font Size • Formatting Cells with Styles & Alignment

  9. Copy, Cut & Paste • Menu Bar: • Choose Edit, Cut or Copy • Followed by Edit, Paste • “Drag-and-Drop” method

  10. Practice:Set Up an Electronic Checkbook • Enter Worksheet Title • Merge & Center • Enter Column Titles • Format Worksheet & Column Titles • Name Your Worksheet

  11. Practice:Create an Electronic Checkbook Practice your new skills by creating an electronic checkbook like this one!

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

  13. Printing Worksheets: • Using Print Preview • See how your worksheet will look on paper • Page Setup commands • Print Commands • File Bar • Ctrl – P • Toolbar Button

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