|
Toms River
Regional Schools
Microsoft Excel XP 1 Microsoft Excel XP 1 is designed to provide participants with practical hands on exercises using the spreadsheet to organize, calculate, and analyze data. Participants will develop spreadsheets for a variety of useful tasks. Topics discussed are listed in the outline below. Building a Worksheet Starting Excel Navigating a Worksheet Using the Keyboard Entering Information Entering Numeric Values Entering Text Entering Dates and Times Entering Comments Entering Formulas Cell References Adding Artwork
Adding Background
Graphics Creating a Hyperlink Activating a Hyperlink
Editing and Removing
Hyperlinks Save Command
Save As Command Exiting Excel Use Easy to remember File Names Check Spelling of Labels
Make Backup Copies Editing a Worksheet Selecting Cells and Ranges Clearing and Deleting Cells Undoing Commands Redoing Commands Repeating Commands Cutting and Pasting to Move Data Using the Clipboard Toolbar Dragging Cells Duplicating Data
Adding Columns and
Rows Entering Labels, Numbers and Dates Using AutoFill Using Fill Filling Up, Down, Right, and Left
Using Fill Series Formatting a Worksheet Changing Alignment Adjusting Horizontal Alignment Adjusting Vertical Alignment
Adjusting Text
Orientation Changing Number Formats Format Cells Dialog Box
Creating Custom
Number Format Changing text Font and Color
Format Cells Dialog Box Adding Borders to Cells
Format Cells Dialog Box Adding Shading to Cells
Format Cells Dialog Box Changing Column Widths and Row Heights Automatic resizing Format-Width Command Using the Mouse Column Width Command Changing Row Height with the Mouse Using the Row Height Command
AutoFit Command Using Styles Creating Your Own Style
Applying Existing
Styles Creating Templates Creating a New Template
Opening and Modifying and
Existing Template Changing Page Breaks
Using Page Break Preview Using Workbooks to Organize Information Managing Worksheets Switching Between Worksheets Naming Worksheets Deleting Worksheets Inserting Worksheets
Moving Worksheets Protecting Worksheets Tools-Protection
Passwords Customize Excel Adjusting Views
Saving Views Printing Options Page Orientation Adjusting Margins Adding Headers and Footers Adding Gridlines and Other Options
AutoCorrect Options
Tools-AutoCorrect Customizing Worksheet Appearance
Options-View Using Formulas and Functions Building a Formula Multiplying Numbers Replicating a Formula Using Arithmetic Operators Parentheses and Order of Operations Built-In Functions Sum Function
Using Range Names Creating Charts Planning a Chart Creating a Chart Embedding a Chart Formatting a Chart Character Formatting Numeric Formatting Chart Legend Gridlines Labels
Arrows
Printing Charts
Sorting Rows and Columns Course Notes and Training Videos Course Data Files Copyright 2004 - Toms River School District. All Rights Reserved. Not Responsible for External Content |
