Microsoft Excel Business Performance Advanced

  • 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

  • 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): £200 - 50%
PrintDURATION: 1 day
TIME: 09:30 to 16:30 GMT

This course is for users of Excel who wish to master more complex functionality and it includes useful time saving techniques in managing, controlling, protecting and manipulating spreadsheet data.

About Microsoft Excel Business Performance Advanced

Microsoft Excel Business Performance

Microsoft Excel Business Performance training courses Southampton, Portsmouth, Hampshire

Microsoft Excel Business Performance

The course is designed to cover a wide range of useful business tools, techniques and formulas that will enable you to protect, control, analyse and manipulate company data. You don’t have to be an expert to attend this course, but you will find some of the topics easier to understand if you use Excel on a regular basis. The course is structured but informal, and you will be encouraged to ask and answer questions throughout. At the end of the course you’ll be sent useful Excel downloads to support your learning and develop new skills. We currently use Microsoft Excel 2016 for this course linked to Office 365, SharePoint and OneDrive.

Is this course for you?

If you use Excel on a regular basis but want to explore some of the more advanced features useful in a business environment then this course is right for you. Perfect for Managers, IT Support, Supervisors, Executives Business owners and those who want to explore advanced techniques.

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 improve your business efficiency using a range of advanced Excel tools and techniques.

Course Objectives

By the end of this course you will be able to:
  • Employ Formula Auditing techniques to understand complex spreadsheets and search for errors
  • Use Formulas to quickly update, extract and join large sets of data
  • Use Validation and Protection techniques to control spreadsheets
  • Explore What IF Analysis tools to answer business questions
  • Analyse and explore data using powerful Pivot Tables and Slicers
  • Create and employ a range of complex related IF functions

Course Content

Formula Auditing (Test and understand your spreadsheets)

Precedents and Dependents – Tracking all formula relationships on a worksheet – Evaluate Nested Formulas

“A very useful technique to help understand the structure and accuracy of a complex spreadsheet”.

Update, Extract and Join data (Manipulate your data)

Functions LEFT, RIGHT, MID, FIND, LEN. LEN and FIND. RIGHT, LEN and FIND
“You will be able to extract and join together various elements of data from a large list”.

Validation techniques (Control data input)

Control – Options – Business uses – Working with Validation
“We explore various validation techniques to control a users experience with a spreadsheet”.

Protection (Protect company data)

Overview of Protection – Securing a workbook – Worksheet element protection – Remove protection – Allow users to edit ranges of cells – Protection of worksheet and workbook elements – Workbook Structure and Windows protection – Mark as Final options
“The ability to protect elements of a spreadsheet using different techniques will allow you to control how users interact with it”.

What IF Analysis (Analyse company data)

Using Goal Seek – Solver – Scenario – Business uses
“A fantastic set of business tools that will allow you to quickly ask a wide range of business questions”.

Pivot Table Reports (Report company data)

Create – Edit – Update – Delete reports – Calculated Fields
“We explore the ability to create detailed Pivot tables using calculated fields and Slicers”.

Slicers with Pivot Tables (Create interactive reports)

Creating – Using – Formatting – Disconnect and Delete Slicers
“Slicers are a useful visual filters with lists of data”.

Explore complex IF Functions (More business IF’s)

Advanced IFs – Nested IFs – IFs with AND/OR – COUNTIFS and SUMIFS – AVERAGEIFS and IFERROR
“We explore some advanced formulas and how we can use them in business”.

Video Testimonials

Client Testimonials

  • Name: 200 + delegatesCompany: Via Reviews.co.uk

    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: 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: 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