Microsoft Excel 2007 Level 3

Level
Total time

Microsoft Excel 2007 Level 3

Indicia Training
Logo Indicia Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Microsoft Excel 2007 Level 3

Course Duration

1 day

Target Audience

This course is aimed at users who have attended Level 1 and 2 Microsoft Excel 2007 courses, or for experienced users wishing to clarify existing knowledge using various methods and techniques.

Course Objectives

This course will provide delegates with the necessary skills and knowledge required to:

·                Understand and use Microsoft Excel and 2007 New Features, Office Button, Ribbon, Quick Access Toolbar, Live Preview, Mini Toolbar, File Extensions and File Sizes

·                Review Basic Excel Formula, Functions and Techniques

·                Understand and use Microsoft Functions and th…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Microsoft Excel 2007 Level 3

Course Duration

1 day

Target Audience

This course is aimed at users who have attended Level 1 and 2 Microsoft Excel 2007 courses, or for experienced users wishing to clarify existing knowledge using various methods and techniques.

Course Objectives

This course will provide delegates with the necessary skills and knowledge required to:

·                Understand and use Microsoft Excel and 2007 New Features, Office Button, Ribbon, Quick Access Toolbar, Live Preview, Mini Toolbar, File Extensions and File Sizes

·                Review Basic Excel Formula, Functions and Techniques

·                Understand and use Microsoft Functions and the Insert Function Tool

·                Understand and use Date and Time Functions

·                Understand and use Multiple Sheets

·                Understand and use Chart Options

·                Understand and use Pivot Tables and Pivot Charts

·                Understand and use Round Function

·                Understand and use the Formula Ribbon

Course Contents

Revision – List of Topics

Using the IF Function

Using Logical Functions

ISERROR Function

Conditional Formatting

Date and Time Functions

Format Cells - Date and Time

System Date and Time Codes

Serial Numbers - Date and Time

Custom Formats - Date and Time

Moving between Sheets

Selecting a Sheet or Group of Sheets

Renaming Sheets

Moving and Copying Sheets

Inserting and Deleting Sheets

Construct Formula Referencing in other Sheets

3-D Referencing

Analysing Results of Pivot Tables

Pivot Table Toolbar

Toolbar - Pivot Tables Tool

Toolbar - Pivot Tables - Menu Options

Toolbar - Format Report

Toolbar - Chart Wizard

Toolbar - Hide and Show Detail

Toolbar - Refresh Data

Toolbar - Include Hidden Data

Toolbar - Always Display Hidden Items

Toolbar - Field Settings

Toolbar - Show Field List

Changing the Layout of a Pivot Tables

Pivot Tables - Shortcut Menu - Options

Toolbar Option - Pivot Table Wizard

Understanding the Round Function

Round to Two Decimal Places

Round to a Whole Number

Round to Whole Hundreds

Round Up to Next Whole Number

Round Down to Next Whole Number

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.