Microsoft Excel Intermediate

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led, hands-on course teaches students the skills needed to work with multiple worksheets within the same file, link multiple Excel files together, and share a workbook. Students will gain more experience with formulas by learning the difference between relative and absolute cell referencing. And lastly, students will plot information from a worksheet onto a chart.

Prerequisites

This course is designed for users that know the basics of Excel, but need to learn the functions and capabilities of Excel that are used with larger worksheets and workbooks. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Excel course or have equivalent knowledge.

Is this the right level for you? Take our free assessment! Please contact our office at 202.682.4500 if you have any questions.

Creating and Working with Multiple-Sheet Excel Files

Creating a Multi-sheet Workbook

Copying Sheets

Inserting and Deleting Worksheets

Writing a 3-D Reference

Formatting Multiple Sheets Simultaneously

Writing Formulas that Link Multiple Excel Files

Opening Multiple Workbooks

Copying a Worksheet to a New Workbook

Creating Links Between Workbooks

Viewing Link Information

Watching a Formula

Editing Linked Source Files

Inserting Rows and Columns in the Source File

Saving Multiple Files as a Workspace

Opening a Workspace

Writing More Advanced Excel Formulas

Absolute vs. Relative Cell References

Using IF Functions

Using Text Functions and Features

Using the Text to Columns Feature

Using the Concatenate Function

Using the TRIM Function

Using the Upper, Lower, and Proper Text Functions

Using the Left, Mid, and Right Text Functions

Using the Paste Values Feature

Formula Auditing

Using the Formula Auditing Toolbar

Tracing Precedents and Dependents

Removing Arrows

Tracing Errors

Working with Shared Excel Workbooks

Creating Shared Workbooks

Tracking Changes in a Shared Workbook

Highlighting Changes

Reviewing and Accepting / Rejecting Changes

Charting Data in Excel

Creating Pie Charts

Moving and Resizing Charts

Formatting Objects

Previewing and Printing Charts

Changing Chart Print Options

Creating Column or Bar Charts

Changing the Numbering Scale

Changing the Chart Series to Rows or Columns

Working with Trendlines

Adding More Data to a Chart