Close Window Print Outline Download PDF

Preparing Outline For Print

Raising the Bar | Austrlia's Leading Training Provider

EXCEL INTERMEDIATE 2016

Course Overview

This is a one-day training course tailored to teach current Excel users the intermediate features of Microsoft Excel. Lead by dedicated instructors who know the ins and outs of the Microsoft Office package, you’ll build upon your existing skills and learn valuable techniques to help you create more professional and productive spreadsheets. We’ll teach you how to manage data in multiple workbooks, use 3D formulas, apply range names, create tables and charts, use data outlining, review formulas and work with advanced formatting, style and themes. You’ll learn streamlined methods to develop reports and analyse and manipulate data quicker than you ever thought possible.

Raising the Bar training courses are delivered face-to-face by certified experts using clear, easy to follow instructions. We keep our class sizes small so that all students achieve the best possible learning outcomes and supply all equipment so there’s no need to bring anything. You’ll learn through clear demonstrations and hands-on activities and leave with brand new skills to produce more professional and effective spreadsheets than ever before.

Upon completion of the Excel Intermediate course, you’ll receive a certificate of completion, a comprehensive course manual to work through at your leisure and the proficiency required to proceed to one of our more advanced Excel courses.

Who Should Attend

The Excel Intermediate training course is designed especially for students who want to enhance their existing Excel skills to go beyond creating basic spreadsheets. This course is perfect for those wanting to gain confidence before moving onto expert level tasks and for companies looking to improve efficiency through more advanced spreadsheet management.

Typically, students who attend this course are already familiar with the fundamentals of Excel and know how to create basic spreadsheets and are ready to take these skills to the next level.

This course is right for you if you want to learn how to manage large datasets, summarise data, create and edit complex formulas, apply more intricate formatting, create and present professional looking charts and work more effectively with existing worksheets and workbooks.

Raising the Bar’s public training courses are available throughout the year in our North Sydney training centre, or via closed group training sessions for companies and organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our Intermediate course is designed for current Microsoft Excel users, so prior knowledge of Excel is required. Students should have completed our Excel Beginners course or have equivalent skills entering data, creating basic formulas, formatting and printing spreadsheets. You will also need general computer skills using the Windows operating system.

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

WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

Managing Data in Multiple Worksheets

Using A 3-D Formula Across Worksheets

Combining Worksheets And Data From Different Workbooks

NAMED RANGES

Using Range Names

WORKING WITH TABLES

General Table Rules

Creating Tables

Sorting Data

Filtering Data

THE VLOOKUP FUNCTION

Using The VLOOKUP Function

OUTLINING DATA

Using Data Outlining

WORKING WITH ADVANCED FORMATTING, STYLES AND THEMES

Customising The Appearance Of Data With Advanced Formatting

Using Conditional Formatting

Maintaining Format Consistency With Styles And Themes

WORKING WITH CHARTS

Creating A Chart

Modifying A Chart

New Features For Modifying A Chart In 2016/2013

Formatting A Chart