Microsoft Excel Advanced Plus Level 4

  • Select Location
  • Southampton - Solent (Whiteley)
Select a location then date
  • Select Date

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999
Price (exc vat): £100
PrintDURATION: 1 day
TIME: 09:30 to 16:30 GMT

We've reduced the cost to £100 to celebrate 20 years delivering Microsoft courses across the UK. This advanced course covers a range of array formulas and techniques that can be used in a business environment that aren't available to standard Excel users.

About Microsoft Excel Advanced Plus Level 4

About Excel’s Array course

IPSO FACTO Microsoft excel training courses Southampton, Portsmouth, Hampshire

The greater part of this course will focus on formula arrays. This type of formula is different from what you may understand about Excel. Using relatively simple array formulas you can carry out calculations that would be either complex or impossible using your usual Excel formulas. This course will show you how to get the most out of array formulas, and employ techniques not available within front end Excel. The course is structured but informal and you will be encouraged to ask and answer questions throughout.

Is this course for you?

You must be using Excel on a regular basis and want to use formula Arrays to extend your data manipulation capabilities.

Training Options

Join this scheduled course at our training centre in Whiteley, near Fareham, Portsmouth and Southampton.
Or, consider onsite training using our computers at no extra cost. £100/delegate or £650 for up to eight delegates on the same course. Minimum charge: £400 plus vat.

Course Includes

  • Lunch and Refreshments – Lunch at Caffe Dallucci (Whiteley only)
  • Microsoft Training Manual
  • Post course training downloads
  • Certificate on completion
  • Post course support relating to course content

More information

More discounted courses

Aim & Objectives

Aim

To create formulas that will solve both simple and complex business problems.

Course Objectives

By the end of the course you will be able to:
  • Create and edit business formulas
  • Create simple array formulas to solve business problems
  • Create advanced array formulas to solve challenging business problems
  • Troubleshoot arrays

Course Content

PowerPivot (Analyse large sets of data)

Slicers – PowerPivot

Sparklines (Present your data)

Sparkline graphs

Array and array formulas (Understand the theory)

Multi-cell array formulas – Single-cell array formulas – Array formula Syntax – Rules for entering and changing array formulas

Using array formulas (Some disadvantages)

Array constants (Tools within tools)

One dimensional and two dimensional constants – Horizontal and Vertical constants – Using Constants in Formulas – Array Constant Syntax – Elements in Constants – Naming Array Constants – Troubleshooting Array Constants

Simple array formulas (Simple analytical tools)

Creating Array and Array Constants from existing values – Count characters in a range of cells – Find the N smallest values in a range – Find the N largest values in a range – Find the longest text string in a range of cells

Complex array formulas (Advanced analytical tools)

Sum a range that contains error values – Count the number of error values in a range – Sum values based on conditions – Compute and average that excludes zeros – Count the number of differences between two ranges of cells – Find the location of the Maximum value in a range.

Video Testimonials

Client Testimonials

  • Name: Chelsea B.Company: More on Reviews.co.uk

    APM PFQ (Introductory Certificate) course review

    The PFQ (APM IC) was for me a good introduction into understanding the ‘Project Management’ world better. It helped me to identify areas and processes that I am not yet familiar with but I now have more confidence in tackling. Passing this course has further confirmed that I do want to go on to study for the APMP qualification. Chelsea B.

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Simon M.Company: Career Change

    PRINCE2 Foundation and Practitioner course review

    I attended the project management qualification in December (having already attended the PRINCE2 course in November). Although a challenging subject, I found that the training was engaging because there was adequate time to not only listen but to also give examples and hear examples from other individuals from the class. This aids to help people’s understanding or misunderstanding in some cases and help breakdown the subject into easier chunks. It also helps that IPSO FACTO have in my opinion some of the most experienced instructors in the country, meaning that if you just don’t get something they bring their personal experience into the story to help your understanding. Simon M.

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Rebecca SCompany: More on Reviews.co.uk

    PRINCE2 Foundation and Practitioner course review

    I just wanted to write and say how much I enjoyed the PRINCE2 course last week. The whole Ipso-Facto experience was brilliant, from your prompt help in providing information to determine whether the course was going to be right for me and arranging for Tim to call me, through registration and the quality of the preparation materials sent out, to starting the course with Julia Gosse. Julia is a fantastic trainer who not only clearly has bags of experience in project and business management but is also a very highly skilled trainer. Whilst there was a huge amount to learn, she made it easy to absorb and tolerated enormous amounts of questions with patience and kindness.

    The venue was easy to get to and we definitely appreciated the surroundings including the lovely cafe for lunch and the lake. I will definitely recommend Ipso-Facto as a local training provider and will come to you first if you are running courses I am interested in for the future.

    Oh and I passed both foundation and practitioner exams! [Rebecca S]

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Amanda MCompany: Hampshire Fire

    Microsoft Project course review

    I attended the two-day Microsoft Project Level Introduction/Intermediate. The course was delivered very professionally with plenty of time to recap and understand each aspect. The environment and facilities were also of a high standard. [Andy]

    I attended the course for two days and Tim was a great trainer, clear explanation of concepts. I have learned some good techniques for better time management and using of resources. Highly recommended. [Daniel C]

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Scott SellarsCompany: More on Reviews.co.uk

    APM Project Management Qualification (PMQ) course review

    I completed the PMQ course through IPSO FACTO and they were a pleasure to work with from the moment I first made an enquiry. Every piece of course administration was made simple for me and the classroom facilities were just perfect. The course instructor was professional, knew the subject very well and focused our learning in a practical way to help put it into perspective. Overall, a very professional experience and I would recommend IPSO FACTO as a quality training company. Thank you. [Scott Sellars]

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Kirsty R.Company: More on Reviews.co.uk

    Microsoft Excel level 2 course review

    The Excel Level 2 course was brilliant. Having not had much experience of using Excel, I wasn’t sure how much I’d learn but Tim the course tutor was great and went at a good pace, making sure I understood as we went along. I learnt things I wouldn’t have had a clue about before including; Conditional Formatting, Range Names, Pivot Tables, IF Functions, Vlookups and a range of shortcuts to make daily tasks much quicker. I’m looking forward to putting It into practice. Would definitely recommend!  Kirsty R.

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: S.W.Company: NATS - Air Traffic Control

    Microsoft SharePoint course reviews

    We’ve completed a range of Microsoft Office SharePoint training courses for users, super-users and developers across our organisation. The training has been highly successful and beneficial to our staff at NATS. Duncan the trainer was very patient and knowledgeable and we would recommend IPSO FACTO for all your Microsoft SharePoint training. Stuart W.

    Link to more reviews: ipsofacto live reviews

    View all testimonials