Microsoft Excel 2007 Intermediate
Our Intermediate Microsoft Excel course is suitable for those with a basic working knowledge of Microsoft Excel. This computer training course is designed for those users who wish to step up their current knowledge of Microsoft Excel to take advantage of the more complex features. Delegates will be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.
Pre – requisites
A working knowledge of Excel or our Excel Introduction course.
Duration
2 x 2 hour sessions
Course Delivery
The course is instructor led with hands on active learning.
Price
Dhs 400 Including refreshments and attendance certificate. Dhs 500 with Course Manual and CD ROM.
Functions
IF Function & Logical functions
VLookup function
Nested functions
And/Or functions
Working with Data
Sorting lists
Using Autofilter
Data validation
Grouping and outlining data
Collaboration
Workbook sharing
Using comments
Protecting workbooks & worksheets
Working with Ranges
Creating named ranges
Using named ranges in functions
Linking with other Applications
Importing data from other applications
Exporting data to other applications
Inserting hyperlinks
Top