Microsoft Excel Intermediate

This short course is aimed at those that have the existing knowledge and skills to create, edit, print and chart simple worksheets including understanding ranges and the copying process. The topics covered in this short course include:

• use the fill operations available to fill a data series,
• use a range of formula techniques,
• use a range of logical functions,
• apply a range of number formatting techniques to data,
• apply conditional formatting in a worksheet,
• apply borders to cells and ranges,
• work with various elements of a worksheet,
• use a range of find and replace techniques,
• sort data in a list in a worksheet, and
• filter data in a table.