MS Excel Intermediate

The MS Excel Intermediate one-day short course provides the skills and knowledge to be able to use and operate the software effectively.

You will learn a range of techniques to work with worksheets and at the completion of this course you should be able to:

• apply a variety of page setup techniques
• apply borders to cells and ranges in a worksheet
• understand and use formula cell referencing
• use common worksheet functions and create more complex formulas and functions
• create and use defined names in a workbook
• apply a range of number formatting techniques to worksheet cells
• apply conditional formatting to ranges in a worksheet
• use goal seeking to determine the values required to reach a desired result
• use a range of elements and features to enhance charts
• select and change the format of objects in a chart
• sort data in a list in a worksheet
• use the fill operations available to fill a data series
• filter data in a table
• understand points to consider to avoid problems in your worksheets

Improve your job prospects by completing the MS Excel Intermediate course today!