Close Window Print Outline Download PDF

Preparing Outline For Print

Raising the Bar | Austrlia's Leading Training Provider

EXCEL INTERMEDIATE 2010

Course Overview

The Excel Intermediate course is suited to students who have either attended a basic course in Excel or spreadsheet training, or those who have been working experience with Excel and have a basic understanding of the features of Excel. Students attending this course are working with large amounts of data and are required to manipulate it to quickly locate information. They are looking for techniques to speed up their processes to manage and manipulate the lists of data they are required to work with. They are familiar with basic formulas and want to implement them more effectively.

As a result of this course students will be able to manage multiple workbooks including construction of formulas across worksheets. They will be learn how to utilise Excels advanced formatting features, manage large amounts of data and work with the sorting, filtering, outlining and subtotal tools. Competency will be gained in advanced charting, auditing techniques and templates.

Course Prerequisites

Microsoft Excel Beginner 2007 or equivalent

Raising the Bar
1300 937 782
www.rtb.com.au
Excel Intermediate 2010 Course

MULTIPLE WORKSHEETS AND WORKBOOKS

Working With Multiple Worksheets

Using A 3-D Formula Across Worksheets

Combining Worksheets And Data From Different Workbooks

NAMING RANGES

Creating And Using Named Ranges

TABLES

General Table Setup Rules

Creating A Table

VLOOKUP Function

Using Simple Database Functions

OUTLINING DATA IN A WORKSHEET

Data Outlining

USING ADVANCED FORMATTING, STYLES AND THEMES

Advanced Number And Date Formatting

Conditional Formatting Data

Maintaining Format Consistency With Themes And Styles

CHARTING

Create A Chart

Modify An Existing Chart

Chart Formatting

REVIEWING FORMULAS - Appendix

Using A Simple Formulas In Excel

Working With Simple Functions