About This Training Course

With a solid foundation of Excel knowledge you are now ready to become an efficient Excel user. This Canberra Efficiency in Excel Training Course will develop your existing skills and take you to a new level of Excel ability.

Efficiency in Excel Training Course will teach you how to use a range of formula techniques, sort and filter the data and then format it to be visually appealing.

Subjects Covered

This Efficiency in Excel Training Course will cover the following subjects:

• Filling Data
• Moving Data
• Formula Techniques
• Logical Functions
• Number Formatting Techniques
• Conditional Formatting
• Applying Borders
• Working with a Worksheet
• Worksheet Techniques
• Finding and Replacing
• Page Setup
• Sorting Data
• Filtering Data
• Charting Techniques
• Chart Text Formatting

Training Course Outcomes

At the end of this Efficiency in Excel Training Course participants will be able to:

• use the fill operations available to fill a data series
• move the contents of cells and ranges within and between workbooks
• use a range of formula techniques
• use a range of logical functions
• apply a range of number formatting techniques to data
• apply conditional formatting to ranges in a worksheet
• apply borders to cells and ranges
• work with various elements of a worksheet
• use a range of techniques to work with worksheets
• use a range of find and replace techniques
• apply a variety of page setup techniques
• sort data in a list in a worksheet
• filter data in a table
• use a range of techniques to enhance charts
• apply formatting techniques to text on charts

Prerequisites

This Efficiency in Excel Training Course assumes some knowledge of the Microsoft Excel product equivalent to that gained in the Excel Essentials course

Other Information

If you need further information contact Startnextweek.com.au on 1300 728 102