Microsoft Excel 2010
Part
2
Course Code: AD607

Take your spreadsheets to the next level with financial and logical functions, charts, databases and worksheet display features. Learn how to link worksheets within a workbook and to a Web Page. This course is approved for the Microsoft Office User Specialist Program.

Objectives
After completing the course, participants will be able to:

  • Use Excel Templates

  • Save Excel Worksheets as a Web Page

  • Use PMT, FV, IF, DATE & NOW functions

  • Plot, modify and enhance a basic chart

  • Create Sparklines

  • Use Absolute References

  • Split the Workbook window and freeze window panes

  • Work with Lists

  • Arranging Workbooks

What you will learn
Topics covered by this course include:

Intermediate Editing & Formatting Techniques

  • Finding & Replacing Worksheet entries

  • Creating & Applying a Style

  • Using Alignment Options

  • Using options in the Paste Special dialog box

Using Absolute Cell References

  • Entering Absolute References into a Formula

Using Financial Functions

  • Using the PMT & FV functions

Using Logical Functions

  • Using the IF function

  • Nesting IF functions

Using Date/Time Functions

  • Using the DATE & NOW functions

Creating a Chart

  • Plotting, Modifying and Enhancing a Chart

  • Previewing and Printing a Chart

  • Plot Non-Contiguous Data Ranges in a Chart

  • Create Sparklines

Linking Worksheets Within a Workbook

  • Entering a Formula to link related Worksheets

  • Formatting multiple Worksheets

  • Printing and Previewing multiple sheets of a workbook

  • Inserting and Deleting worksheets

Controlling the Worksheet Display

  • Splitting & Freezing the Worksheet Window

  • Hiding Rows and Columns

  • Opening a New Workbook window/Arranging Workbook windows

  • Changing the Zoom Level

Working with Lists

  • Filtering and Sorting records of a List

  • Specify a Criteria Range in a Filter Operation

Additional Intermediate Excel Features

  • Insert Hyperlinks and Comments

  • Applying a background to a worksheet

  • Using the Research feature

 

Prerequisites
Course participants should have completed Excel 2010 Part 1 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R®

 [Back to MS Office Training Courses]