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?
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