Prerequisites

Prerequisites
Participants should have completed the Excel Introduction course or have equivalent experience. If you are unsure, please complete a Training Needs Assessment form by clicking here, or feel free to contact our Bookings Administrator on (07) 857 0776.

Who Should Take This Course
Current users of Excel who want to learn how to create IF statements and Lookups along with learning how to create charts, sorting and filtering and formatting data.

Course Objectives

Course Objectives

Upon completing this course, you will have learned how to:

1. Enter and edit Excel formulas.
2. Use a logical IF statement to evaluate values and make decisions.
3. Use a Lookup function to return values in a database.
4. Sort and filter databases.
5. Insert and modify charts.
6. Embed and link a chart to another application.
7. Use different types of Excel formatting.

Course Outline

 Course Outline 

Review of Excel Formulas

• Using AutoCalculate, AutoSum, and AutoFill
• Entering Formulas
• Naming cells

Using IF, LOOKUP and Date and Time Functions

Managing Databases and Lists

• Understanding Excel Databases
• Sorting data, including custom sorts
• Filtering data and using the Advanced Filter option
• Generating Subtotals Automatically

Inserting Charts

• Inserting and formatting charts
• Understanding chart axes, plot area, and gridlines
• Moving and resizing charts
• Embedding and linking charts to another application

Using Sparklines (Excel 2010 & 2013 only)

Formatting Techniques

• Standard Formatting
• Format Painter
• Cell Styles and Table Styles
• Conditional Formatting

Managing Worksheets

• Freezing row and column titles
• Splitting a worksheet
• Hiding and un-hiding rows and columns
• Hiding / un-hiding worksheets
• Grouping and ungrouping worksheets