Training Course Outlines:

The following modules will be covered in this course:

• Filling Data


• Moving Data


• Logical Functions


• Formula Techniques


• Number Formatting Techniques


• Conditional Formatting


• Applying Borders


• Page Setup


• Working With a Worksheet


• Worksheet Techniques


• Finding and Replacing


• Sorting Data


• Filtering Data


• Charting Techniques


• Chart Text Formatting

Training Course Outcomes:

At the completion of this course you should be able to:

• use the fill operations available to fill a data series, and move the contents of cells and


• ranges within and between workbooks


• work with logical functions in Excel


• use a range of formula techniques


• apply a range of number formatting techniques to data


• apply conditional formatting to ranges in a worksheet


• apply borders to cells and ranges


• apply a variety of page setup techniques and work with various elements of a worksheet


• use a range of find and replace techniques


• sort and filter data in a list in a worksheet


• use a range of techniques to enhance charts

Course Accreditations:

Course Prerequisites:

This course assumes the participant has the skills and knowledge required to create, edit, print and chart simple
worksheets. Understanding ranges and the copying process is important. It would be beneficial to have a general
understanding of personal computers and the Windows operating system environment.

Related Courses:

People Visited:

85 people visited