BACK TO MICROSOFT EXCEL TRAINING COURSES

 

Microsoft Excel 2010 | Level 3 | Course Details...

Course Duration: 1 Day | Class Time: 9am - 4:30pm | Class Size: 6 Students Max

Training Room Location: Level 1, Opposite Reg. Hosp Nastech Sunyani B/A R.

Course Materials: As part of the course you will receive many useful resources and learning links to compliment your training and help you stay on track after your course.

Certificates: All students receive a certificate of achievement on completion of their course.

After Course Support: On completion of your course you will be eligible for free email and phone support*, to aid you in the development of your new skills.

FREE Course Resit: We offer you the chance to come back in the future and resit your course for FREE*, so if you want to polish your skills further or just recap on a few things this is a great option.

What you need to bring: Nothing. We supply a PC computer for you to use with all software already installed and have note pads, pens etc in the training room. If you think it would be beneficial to bring some samples of your work that would be great but not essential.

 

Cost: GH¢ ???+GST

 

 

 

 

 

 

About Our Microsoft Excel 2010 Level 3 Course

Aims of the course

This course aims to give students an in-depth knowledge of Excel features.

Course Objectives

On completion of the course students will have advanced skills in using Microsoft Excel. They will be able to:

• Link multiple workbooks

• Print workbooks

• Work with named ranges

• Audit a worksheet

• Create and use PivotTables and reports

• Use Solver, Scenario Manager and Goal Seek tools

• Use Excel workgroup features

• Create and use macros

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for students to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a reasonable knowledge of Excel. Prior attendance of the Intermediate Excel course would be an advantage.

 

 

 

COURSE DATES - SYD	MAY	JUN	JUL	AUG	SEP	OCT
Excel 2010 Level 1	3	4	18	6 20	5 19	1 15 29
Excel 2010 Level 2	4	5	19	7 21	6 20	2 16 30
Excel 2010 Level 3	11	13	27	8 22	7 21	3 17 31
Excel One-On-One	Numerous date available each week, please call
Excel Mastery	Choose your courses from any of the above dates
Excel On-Site	Please call to arrange suitable on-site training dates

 

 

Course Outline

Using multiple workbooks

• Using a workspace

• Linking workbooks

Printing workbooks

• Printing and previewing multiple worksheets

• Using the Report Manager

Named ranges

• Add a named range

• Delete a named range

• Use a named range in a formula

• Use Lookup Functions

Auditing a worksheet

• Using the Auditing Toolbar

• Tracing errors

• Tracing dependents

• Tracing precedents

PivotTables and Reports

• Creating a PivotTable report

• Creating a PivotChart report

• Resetting a summary function in a PivotTable report

• Creating a PivotTable report for the World Wide Web

Data Analysis Tools

• Goal Seek

• Solver

• Scenario manager

Excel workgroup features

• Changing workgroup properties

• Creating a shared workbook

• Merging workbooks

• Tracking changes

• Creating, editing and removing comments

• Applying and removing file passwords

• Applying and removing worksheet and workbook protection

Macros

• Recording macros

• Running macros

• Editing macros