Suitable For

This course shows how to construct formulas and functions in Excel.  It is aimed at existing Excel users who can create and amend spreadsheets but find formulas frustrating.

Objectives

By the end of the course delegates will be able to:· 

• Create different types of formula· 
• Use absolute references in formulas· 
• Use a range of Excel functions· 
• Use the auditing tools to see how formulas are constructed

Versions Available

 2000, XP, 2003 and 2007

All courses marked with * are now available in Microsoft Office 2007 in addition to our usual choice of versions

Related Courses In Our Range· 

• Excel Module 1 – Essentials· 
• Excel Module 2 – Gathering & Presenting Data· 
• Excel Module 3 – Data Analysis· 
• Excel Module 4 – Advanced Formulas & Functions· 
• Excel Module 5 – Advanced Data Management· 
• Excel – Pivot Table Expert

Course Content

Creating formulas 

• Basic formulas 
• Formula syntax 
• Operators
• Ordering calculations
• Using brackets 

Using basic functions 

• The function wizard 
• Copying formulas 
• Autocalculate

Using Maths functions 

• Sum 
• Product

Absolute vs Relative References In Formulas 

• Editing formulas
• Using absolute references in formulas 
• Using partial absolute referencing

Working with percentages· 

• Creating formulas with percentages 
• Formatting as a percentage

Formula auditing· 

• Using the auditing facility 
• Tracing how formulas are made up
• Evaluating formulas (XP, 2003 and 2007 only)

Statistical functions 

• Max
• Min
• Average
• Median
• Mode

Range Names

• Naming Ranges
• Using range names in formulas

Count functions 

• Count
• CountA 
• Count Blank

Date and Time functions· 

• Using date functions
• Using time functions

Text functions· 

• Using text functions