Microsoft® Excel – Intermediate

This course is designed for delegates who are already familiar with using Excel and can create simple worksheets and formulas. Delegates will learn how to create more complex worksheets using a variety of Excel functions including, representing data graphically and maintaining and managing lists.

Upon completion of this course you will be able to:

¨ Create charts that graphically represent worksheet data

¨ Modify charts

¨ Customise charts by applying formatting

¨ Enhance worksheets and charts by using the drawing tools to add graphic objects

¨ Sort information in a list by using the data, sort command

¨ Locate information quickly in a list that meets specified conditions by using the advanced filter feature

¨ Creating a chart sheet

¨ Creating and embedded chart

¨ Comparing chart sheets with embedded charts

¨ Chart types

¨ Modifying embedded charts

¨ Adding and deleting chart items

¨ Moving and sizing chart items

¨ Formatting chart text

¨ Formatting labels

¨ Formatting the chart

¨ Printing a chart sheet

¨ Adding graphic objects

¨ Formatting graphic objects

¨ Using graphic objects to enhance worksheets and charts

¨ Exploring the worksheet sort data

¨ Performing multiple-level sorts

¨ Sorting options

¨ Importing data

¨ Considering design issues

¨ Filtering a list

¨ Custom criteria

¨ Multiple-condition criteria

¨ Managing a filtered list