WELCOME TO THE SWMSC South West Multi Service Center

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
PracticeSet Up an Electronic Checkbook

• Enter Worksheet Title
• Merge Center
• Enter Column Titles
• Format Worksheet Column Titles
• Name Your Worksheet

11
PracticeCreate 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 wont 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 Librarys Calendar of
  Events.
  
• For more information Call [phone], or
  visit http//www.houstonlibrary.org