Call us today: 0800 028 3045
Microsoft Excel – Mastering Formulas and Functions Course
Is it right for me?
Our Excel Mastering Formulas and Functions course shows you how to construct basic formulas and functions in Excel.
It is aimed at existing Excel users who can create and amend spreadsheets but find formulas frustrating.
What will I get out of it?
By the end of the course you 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
2003, 2007, 2010
Related courses in our range
What does it cover?
Creating formulas
- Basic formulas
- Formula syntax
- Operators and brackets
- Ordering calculations
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
Statistical functions
- MAX and MIN
- AVERAGE, MEDIAN and MODE
Range names
- Naming ranges
- Using range names in formulas
Using VLOOKUP
- Constructring a simple VLOOKUP formula
Count functions
- COUNT
- COUNTA
- COUNTBLANK
Date and time functions
- Using date functions
- Using time functions
Text functions
- Using text functions
“I attended this course to increase my knowledge and confidence using Excel, this has been achieved. The trainer presented very well. An easy to follow course.”
Jenny Breeden, Administrator, Welland Medical
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
