Computer Training
Course Objectives: Intermediate Microsoft Excel 2007
Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.
- The Fundamentals
- Creating a Chart
- Resizing and Moving a chart
- Changing Chart Type
- Applying Built-in Chart Layouts and Styles
- Working with Chart Labels
- Working with Chart Axes
- Working with Chart Analysis Commands
- Formatting Chart Elements
- Changing a Chart’s Source Data
- Using Chart Templates
- Viewing a Workbook
- Working with the Workbook Window
- Selecting Worksheets in a Workbook
- Inserting and Deleting Worksheets
- Renaming, Moving and Copying Worksheets
- Working with Multiple Workbooks
- Hiding Rows, Columns, Worksheets and Windows
- Protecting a Workbook
- Protecting Worksheets and Worksheet Elements
- Sharing a Workbook
- Creating a Template
- Creating Headers and Footers
- Using Page Breaks
- Adjusting Margins and Orientation
- Adjusting Size and Scale
- Adding Print Titles, Gridlines and Headings
- Advanced Printing Options
- Formulas with Multiple Operators
- Inserting and Editing a Function
- AutoCalculate and Manual Calculation
- Defining Names
- Using and Managing Defined Names
- Displaying and Tracing Formulas
- Understanding Formula Errors
- Sorting by Column, Multiple Columns, Colors or Icons and a Custom List
- Filtering Data
- Creating a Custom AutoFilter
- Using an Advanced Filter