HOME
 

Excel Advanced - Formulas and Functions

STL
Course summary
1 day
194 - 226 GBP excl. VAT
English
Open / Scheduled
Next available date: 11/04/2019 09:30 - London
Rating: 4.7 (373 Reviews)
Course Dates
London
11/04/2019 09:30  (English)
226 GBP
03/06/2019 09:30  (English)
219 GBP
19/07/2019 09:30  (English)
213 GBP
12/08/2019 09:30  (English)
210 GBP
03/09/2019 09:30  (English)
204 GBP
01/10/2019 09:30  (English)
195 GBP

Excel Advanced - Formulas and Functions



Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... At the end of this course you will have a greater understanding of building complex formulas using nested functions (such as IF statements). ; ; You will find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel. Save time by learning more sophisticated search and auditing techniques when working with data-heavy spreadsheets. ; ; Also available is the Excel Advanced - For Power Users course.

Suitability - Who should attend?



Our Microsoft Excel Formulas course is suitable for those with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas and functions within Excel.

You may also wish to consider one of our finance for non financial managers courses.

Training Course Content



Building complex formulas

Using nested IF statements
Creating compound logical tests using AND, OR, NOT functions with IF statements
Nesting LOOKUP functions
Source table structure information using CHOOSE function
Using MATCH function to locate data
The INDEX function for retrieving information by location
Using a nested formula containing INDEX, MATCH and MATCH (two-way lookup)

Advanced functions in formulas

Using COUNTIFS,SUMIFS, and AVERAGEIFS for tabulating data based on single/multiple criteria
Statistical functions; MEDIAN, MODE, RANK, LARGE, SMALL, ROUND, MOD
AGGREGATE function to sum data in ranges with errors
Use a variety of Financial functions such PMT, FV, IRR

Data and Text Functions

Smarter ways to calculate date and time; TODAY
NETWORKDAYS, WORKDAY, DATEDIF
Use TYPE to identify data type of existing cell contents
Text functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN
TRIM excess space in cells

Introduction to Array formulas

Using embedded Excel Array formulas
Create an Array formula

Auditing formulas

Tracing formula precedents, dependents, and errors
Correcting errors in formulas
Combining IF with VLOOKUP to suppress error messages
Using the IS information function
Error checking functions; ISERR, ISERROR, IFERROR

Expenses



List price £350 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video

   

Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.


Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel Advanced - Formulas and Functions.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net


Reviews by course attendees

Patrick Doherty
(5)
Most useful topic: Pivot tables
Course participant
(5)
This course has opened my eyes to the versatility of Excel. I used to be in admiration of people who can manipulate volumes of data
Jeni Morrison
(5)
Most useful topic: amount of new formulas
Request information

Find out more about this Excel Advanced - Formulas and Functions course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here