Excel 2010 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. 

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