Excel Advanced - Formulas and Functions
- At the end of this course, you will have a greater understanding of building complex formulas and functions. You will be able to create advanced nested functions to produce solutions and outcomes in your data sets.
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.
You will be introduced to the latest functions available in Excel 365, as well as less well-known but powerful existing functions.
In addition to learning a wide range of new formulas, you will also discover best-practice for setting up Excel files so they are flexible, appropriate, well-structured, and transparent.
Also available is the Excel Advanced - For Power Users course.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
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
Nested functions best practiceWriting functions more efficiently using Formatted Tables
Get an understanding of how nested functions get executed
Statistical and forecasting functions
LARGE, SMALL, ROUNDCORREL and SLOPE
FORECAST.LINEAR
FORECAST.ETS
Date, Time and Text Functions
Smarter ways to calculate date and timeWORKDAY, DATEDIF, EDATE, WEEKNUM
Text functions:
UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN
TRIM excess space in cells
TEXTJOIN and CONCAT
Introduction to Array formulas
Using embedded Excel Array formulasTREND, GROWTH, FREQUENCY
UNIQUE, SPILL, SORT (365)
SORTBY, FILTER (365)
Creating bespoke Array formulas
Advanced Lookup and Reference
XLOOKUP and XMATCHADDRESS
INDIRECT
OFFSET
CHOOSE
Auditing formulas
Tracing formula precedents, dependents, and errorsCorrecting 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, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
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.
Reviews by course attendees
Average rating 4.8
Make the course slightly shorter. It was a bit long towards the end and the text function explanation was not necessary.
Marius was great. Explained everything really clearly and had lots of useful examples. I will definitely be using all these functions.
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
There was a lot to cover and I believe it should be a 2 day course as there was not enough time to cover everything plus a lot of info squeezed in one day -it's better for memor...