# Excel Module 3 – Advanced Formulas and Functions

Excel Module 3 – Advanced Formulas and Functions 2019-04-12T18:48:02+00:00

# Excel Module 3 – Advanced Formulas and Functions

Duration: 1 day

Our Excel Module 3 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data.

This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending.

By the end of the course you will be able to:

• Use a range of Text functions to manage text data
• Create and use different types of date and time functions
• Work with rounding functions
• Use logical statements
• Build nested formula
• Use SUMIF, COUNTIF and AVERAGEIF
• Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions
• Use IS functions and IFERROR to test cell values

#### Working with Text

• Splitting text into multiple cells
• Merging data into one cell
• Extracting data using text functions
• Tidying data

#### Working with Dates and Times

• Formatting dates and times
• Date and time functions
• Calculating date and time differences

• ROUND
• ROUNDUP
• ROUNDDOWN
• CEILING
• FLOOR

#### Using Lookup Functions

• Lookup functions
• Creating a lookup table
• Range naming
• Using VLOOKUP
• Using HLOOKUP
• Using INDEX and MATCH

#### Working with Logical Statements

• Creating an IF statement
• Using the AND plus OR functions
• Nesting functions

• SUMIF(S)
• COUNTIF(S)
• AVERAGEIF(S)

#### Using IS and IFERROR to Test Cell Values

• ISBLANK
• ISNUMBER
• ISTEXT
• ISERROR
• IFERROR

I would definitely recommend the course. I found VLOOKUP, MATCH, INDEX, COUNTIF and SUMIFS most useful and I think the course is perfect.

I most enjoyed MATCH, INDEX and Text functions. Thank you for the course which was very helpful. I was able to achieve my objective.

I enjoyed formulas, COUNTIFS and SUMIFS

Excellent course and trainer. I would recommend the course, good content and trainer.
I would recommend the course, the trainer has a lot of knowledge and takes time to explain tasks. Very good course, tougher than Module 2. I found it really useful being able to keep the books after along with the worksheets we had been using on the day. Very quick to register for the course and very good facilities.

The course showcased the ease and efficiency of using Visio. Venue was lovely

Yes, I would recommend the course, Lisa was very clear in her explanations and very easy to talk to. The examples were easy to follow in order to understand how each function worked. Everything was done in a step by step process, so it was easy to follow and understand

I would recommend the course, theory taught in an intuitive way with good examples to back it up. Really enjoyed the session. It was taught very well and followed on from where Excel 2 left off. The shortcuts and examples were very good.

I would recommend the course, I found it very informative and easy to follow. Really great, it was my second course that I attended. Friendly atmosphere and lots of help provided. I like how Susan shows us how to do a task and then when we do the practical its based on different figures and scenarios so you learn better as your not just copying what Susan did blindly.

Excellent course and trainer, I would recommend the course as Lisa always adds beyond the course, by teaching you many shortcuts which will save so much time at work!

I would recommend the course, really useful build on existing Excel knowledge. Susan adapts what she is showing to apply to your work. What I found most useful was All the ‘IFs’ and dates and times and building on dates and times knowledge e.g. networking days

Excellent course and trainer, most defiantly would recommend to my colleagues. Material was well presented, venue and course are great