tree tops

Microsoft Office Excel

2010 | 2007 | 2003

Basic | Intermediate | Advance

Microsoft Office Excel Intermediate

The course focuses on:

Improving your Excel skills. At the end of the day you will be able to create templates in excel, work with more advance formulae and create charts. You will also be able to sort and structure your data and insert graphic objects, comments and certain web features.

 

Who should attend this course?woman working on laptop

This course is aimed at anyone who wishes to limprove their Microsoft Office Excel skills.

The following people will find this course helpful:

  • Anyone who have worked on Excel before and are familiar with the program
  • Accountants
  • Business Analysts
  • Debtor and creditor clerks
  • Data capturers
  • Project Managers

 

Duration: 1 Day

 

Outline:

Templates
Opening a Template
Creating a Template
Modifying a Template


Creating Charts
Insert a Chart
Modifying Charts
Printing Charts


Functions
The IF Function
How the IF Function works
Lookup Functions
How the VLOOKUP Function Works
The HLOOKUP Function
PMT
FV
Date and Time functions
DSUM function
Linking cells


Named Ranges
Creating a named range
Removing a name from a cell
Using named ranges in a calculation


Working with Data
Sorting Data
Multiple Level Sorts
Filtering Data with the Filter
Subtotals


Import and Export Data
Exporting data from Excel
Importing data into Excel


Working with Graphic Objects
Adding a Shape
Resizing an AutoShape
Modifying an AutoShape
Changing the order of object
Grouping objects


Comments and Web Features
Comments
Using Hyperlinks
Publish a worksheet to the web

 

Return to

soft skills course list | computer course list

 

To book for this course click here