Excel 2007 Introduction
**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**
Description: After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.
Days: 1
Prerequisites: Windows XP: Basic or equivalent experience
Unit 1: Getting started
Topic A: Spreadsheet terminology
· Discussing spreadsheet terminology
Topic B: Exploring the Excel window
· Examining Excel window components
Topic C: Getting help
· Using Help
Topic D: Navigating workbooks
· Navigating a worksheet
Unit 2: Entering and editing data
Topic A: Entering and editing text and values
· Entering text and values
· Editing text
· Using AutoFill to fill a series
Topic B: Entering and editing formulas
· Entering a formula by typing
· Entering cell references with the mouse
· Editing a formula
Topic C: Working with pictures
· Inserting and modifying a picture
Topic D: Saving and updating workbooks
· Saving a workbook
· Changing and updating a workbook
· Using the Compatibility Checker
Unit 3: Modifying a worksheet
Topic A: Moving and copying data
· Moving data in a worksheet
· Copying data in a worksheet
· Moving and copying data by using drag-and-drop
· Copying data by using the Clipboard
Topic B: Moving and copying formulas
· Moving a formula
· Copying a formula
· Using AutoFill to copy a formula
Topic C: Absolute and relative references
· Observing the limitations of relative references
· Using absolute references
Topic D: Inserting and deleting ranges, rows, and columns
· Inserting a range
· Inserting rows
· Deleting a range
Unit 4: Using functions
Topic A: Entering functions
· Entering a SUM function
· Using the mouse to enter a function argument
· Inserting a SUM function
Topic B: AutoSum
· Using the AutoSum button
Topic C: Other useful functions
· Using AVERAGE
· Using MIN
· Using MAX
· Using COUNT and COUNTA
Unit 5: Formatting worksheets
Topic A: Formatting text
· Using the Font group to format text
· Formatting non-contiguous ranges
· Using the Format Cells dialog box to format text
Topic B: Formatting rows and columns
· Changing column width and row height
· Applying color to a row
· Setting alignment
· Applying borders to ranges
· Using the border-drawing pencil
· Using the Paste Special option
· Removing a border
Topic C: Formatting numbers
· Using the Number group to format numbers
· Exploring the Number tab
Topic D: Conditional formatting
· Creating a conditional format
· Editing and deleting a conditional format
Topic E: Copying formats and applying table formats
· Copying formats
· Using AutoFill to copy a format
· Applying cell and table styles
· Using Find and Replace to change cell formats
Unit 6: Printing
Topic A: Preparing to print
· Checking spelling in a worksheet
· Using the Research task pane
· Finding and replacing text
· Previewing a worksheet
Topic B: Page Setup options
· Setting page orientation
· Setting margins
· Creating and editing headers and footers
· Hiding gridlines and headings
Topic C: Printing worksheets
· Printing a worksheet
· Working with the print area
Unit 7: Creating charts
Topic A: Chart basics
· Creating a chart
· Moving a chart within a workbook
· Examining chart elements
· Using an embedded chart
Topic B: Modifying charts
· Changing a chart type
· Applying Quick Layouts and Quick Styles
· Formatting chart elements
· Modifying an embedded chart
Topic C: Printing charts
· Printing a chart
Unit 8: Managing large workbooks
Topic A: Viewing large worksheets
· Using the Freeze Panes command
· Splitting a worksheet into panes
· Hiding and unhiding columns and worksheets
· Minimizing the Ribbon
Topic B: Printing large worksheets
· Setting print titles
· Adjusting page breaks
Topic C: Using multiple worksheets
· Navigating between worksheets
· Naming worksheets and coloring tabs
· Working with multiple worksheets
· Previewing and printing multiple worksheets
Price: $295
Group Rate:$995
(Up to 12)
Or you can purchase our CW vBook training:
Group Rate:
(Up to 12)
Or you can purchase our CW vBook training:
