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!

*Please note; Short Courses are non-accredited and result in a Certificate of Participation. A non-accredited training course does not count-towards a recognised qualification, but is specially designed to provide hands-on training in a new skill you can use in your personal or professional life, and is a great way to refresh your knowledge or give you a taste of a different industry.