A basic understanding of Excel is assumed.  Take a look at our Introduction course topics to assess the level you require.Refresher

• Formulas VS Functions
• Creating Statistical Functions
• Tracing Precedents and Dependents
• Formulas across worksheets and workbooks

Logical functions

• Using the If function:
• Text results
• Number results
• Formula results
• Using Or and And functions
• Using Rounding functions

Working with Text and Date Functions

• Use Concatenate, Left, Right, Mid and Trim to manage text
• Use Month, Year, Day, Today and Now functions
• Using Text to Columns

Data Validation

• Create validation rules for numbers and characters
• Input and error messages
• Create drop down lists
• Using Conditional Formatting to format cells based on data entered

Referencing and Named Ranges

• Using Absolute referencing in formulas
• Using Mixed referencing in formulas
• Define, create and apply named ranges
• Write formulas using named ranges

Working with Charts

• Creating chart sheets to represent data
• Creating charts objects within a spread sheet
• Modifying Chart types and data source
• Applying different chart types across the data