BACK TO MICROSOFT EXCEL TRAINING COURSES

Microsoft Excel 2010 | Level 2 | 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 2 Course

Aims of the course

This course aims to give people a greater understanding of Excel.

Course Objectives

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

• Manipulate worksheets

• Use templates

• Apply conditional formatting

• Use various functions, including financial, logical and date/time functions

• Manage Excel databases and lists

• Customise charts

• Use Excel in conjunction with other applications

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 basic knowledge of Excel.

Course Outline

Manipulating Worksheets

• Renaming worksheets

• Inserting worksheets

• Deleting worksheets

• Splitting worksheet window into panes

• Freezing panes

• Hiding rows and columns

• Grouping and ungrouping worksheets

• Copying data between worksheets

• Formatting multiple worksheets in one operation

• Entering a formula to link related worksheets

Templates

• Applying templates

• Editing templates

• Creating templates

Formatting

• Applying number formats

• Creating conditional number formats

• Using conditional formatting

Functions

• The IF function

• Nested IF functions

• Financial functions, including PMT, FV

• The DATE function

• The NOW function

Excel databases and lists

• Creating an Excel database

• Editing an Excel database

• Sorting

• AutoFilter

• Filtering data

• Totalling and manipulating filtered data

• Creating subtotals

• Using data forms

• Data validation

Charts

• Plotting non-contiguous data ranges

• Pie charts

• Adding new data to an existing chart

• Chart formatting techniques

Use of Excel with other applications

• Paste special option

• Linking vs Embedding

• Linking data from other worksheets

• Linking data from other applications

• Exporting to other applications