Users wanting to expand their knowledge and explore some of the other uses of a spreadsheet application.

Attendance on the Excel Fundamentals course or commensurate knowledge through experience.

• Customising & Creating Your Own Toolbars
• Working with Multiple Worksheets
• Sheet Names & Tab Colours
• Moving & Copying Worksheets
• Using Group Editing
• The IF Function
• Data Calculations
• Calculating Percentages
• Entering Formula Across Worksheets
• Conditional Formatting
• Custom Number Formats
• Workbook & Worksheet Protection
• Freezing Titles & Splitting Panes
• Working with Page Breaks
• Naming Cells & Ranges
• Working With Data Lists
• Sorting & Filtering Data
• Sub Totals
• Creating Charts
• Manipulating Chart Data
• Modifying Chart Layouts
• Previewing & Printing Charts

By the end of the course the user will have a fuller understanding of the capabilities of Excel and will be capable of producing a variety of Worksheets, Data Lists and Charts.