Excel Module 4 - Advanced Formulas and Functions
|
Summary
|
|
|||||||||||||
Excel Module 4 - Advanced Formulas and Functions
Excel Module 4 - Advanced Formulas and Functions - 2 day course in Crawley
ThisExcel Module 4 - Advanced Formulas and Functions Course is designed for experienced users of Excel who want to develop their skills in writing formulas and using advanced Excel functions and techniques.
Versions available: 2003, 2007, 2010
By the end of the course delegates will be able to:
- Use an extensive range of logical, text and date functions
- Create simple array formulas
- Cross reference data from other worksheets using lookups, index and match
- Use IS functions to test cell values
- Create nested conditional formulas linking data between worksheets
- Set advanced conditional formatting and data validation
- Use the What If Analysis tools
If you want to find out more about Excel Module 4 - Advanced Formulas and Functions, you can make an information request below and the school will contact you with further information.
Suitability and application
This 2-day Excel Module 4 - Advanced Formulas and Functions Course is tailored especially for those looking to learn more about advanced Excel formulas and functions.
Pre-requisites: You should be confident using Excel and should be able to write basic formulas and functions.
Excel Module 4 - Advanced Formulas and Functions Course Content
This Excel Module 4 - Advanced Formulas and Functions Course is designed to cover the following areas:
Working with text
- Splitting and merging
- Extracting data using text functions
- Formatting text using functions
Working with dates and times
- Formatting dates and times
- Date and time functions
- Calculating date and time differences
Using functions to round numbers up and down
- ROUND
- ROUNDUP
- ROUNDDOWN
Working with logical functions
- Using logical statements to test a value (IF, AND, OR)
- Combining more than one function
Calculating values based on given criteria
- SUMIF
- COUNTIF
- Conditional Sum Wizard
Array formulas
- Using array formulas
- TRANSPOSE
- Calculate a conditional average
Lookup and reference functions
- Using VLOOKUP and HLOOKUP
- Using INDEX and MATCH
Using IS functions to text value types in cells
- ISBLANK
- ISNUMBER
- ISTEXT
- ISERROR
Interactivity between worksheets
- Creating data validation lists from ranges
- Nested lookups
- Conditional linking
- Creating graphs on variable data
Nested conditional functions
- The forms toolbar
- Adding check boxes
- Adding option buttons
- Setting properties
- Nesting logical and statistical functions
Advanced conditional formatting and data validation
- Conditional formulas
- Colour banding
- Finding cells with conditional formatting
- Finding and preventing duplicate values
Forecasting with what if analysis tools
- Using Goal Seek
- Using Solver
Using the solver
- Installing the solver add in
- Solver steps
- Adding constraints
- Running a Solver model
Scenarios
- Creating scenarios
- Producing scenario reports
Data tables
- Creating one and two input data tables
Functions
- PMT
- MOD
- ROW
Expenses
The cost of this Excel Module 4 - Advanced Formulas and Functions Course is £398.00 + VAT.
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
Reviews by course attendees
Show all reviews
To request information from Excel Module 4 - Advanced Formulas and Functions, please fill out the following details:
| Average rating | Quantity | Rec. | ||
| 5.0 | 1 | 100 % |
