Microsoft Excel Level 2 – Frequent User Intermediate

  • 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
Price (exc vat): £135
PrintDURATION: 1 day
TIME: 09:30 to 16:30 GMT

This popular Microsoft Excel course has recently been upgraded to include the latest 2016 features designed to improve your performance when working with data. Attending this course will provide you with many new skills that will be directly relevant to your work.

About Microsoft Excel Level 2 – Frequent User Intermediate

Introduction to Microsoft Excel Frequent user course

Microsoft Excel Frequent User training courses Southampton, Hampshire

Microsoft Excel Frequent User

Our Microsoft Excel frequent user course has a focus on managing, manipulating and analysing data using a range of simple and complex techniques. It also explores the use of more complex formulas in a business environment and includes techniques to simplify what could be complicated. We also investigate visual techniques that can be used to monitor information by users and managers. The course builds on shortcuts and techniques learnt during our Level 1 course. 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?

This course is suitable if you have had formal Excel training at level 1 or you are confident with the content covered in level 1. It is suitable for Office Staff, Finance teams, Managers, Project Managers, Supervisors, Business owners and Executives.

A typical Excel course

This is a typical Excel course at our training centre at Whiteley in the Solent Business Park. In this case there are eight delegates from local companies attending a scheduled intermediate level course. Its a very relaxed atmosphere with every opportunity to learn new skills and efficient techniques.

 

 

Training options

Scheduled course: £135+VAT per delegate, discount for groups.

Onsite: £650+VAT for up to eight delegates on the same course. Minimum charge: £540+VAT for four delegates.

Course Includes

  • Computer and the latest software for each delegate
  • Lunch and refreshments – Lunch at Cafe Dallucci (Whiteley only)
  • Training manual
  • Post course training downloads
  • Certificate on completion
  • Post course support relating to course content

More information

Link to Office 365 Microsoft Excel Download
Follow this link to Microsoft to read the capabilities of Excel 2016. You can also buy it or try it for free.

Aim & Objectives

Course Aim

On completion of this course you will have gained improved confidence when tasked to manage, manipulate and analyse business data; create a range of complex business formulas and provide solutions to resolve day to day problems.

Course Objectives

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

  • Use Conditional Formatting and Range Names to improve your performance
  • Interrogate, Manipulate and Report against business data using (Sort, Filter, Subtotal, Pivot Table)
  • Interrogate tables of data using various IF statements (IF, IF(OR), IF(AND), SUMIFS etc.
  • Link key business data using VLOOKUP statements
  • Create and Edit Templates to speed up routine tasks
  • Create and Edit a range of effective business charts including Sparklines and Forecast sheets
  • Use a range of shortcuts to improve speed and efficiency

Course Content

Conditional formatting (Use visual tools to understand data)

Format Painter rules – Quick Formatting – Clear Formatting – Formatting techniques in Business

Range names (Simplify formulas and navigation)

Syntax rules for names – Using Formula AutoComplete – Types of Names – Scope of a Name – Getting the best out of Names

Data lists (Interrogate, manipulate and report data)

Single Column Sort – Freeze Panes – Split Box control – Multi-Column Sort – Simple and complex Filters – Subtotals Techniques – Pivot Table Reports

IF functions (Question data)

Common mistakes when creating formulas – Validate simple formulas – Create simple and complex IF statements – Nested IF Functions – IF with AND/OR

VLOOKUP functions (Link data)

Function in detail – Function options – How to use in Business

Using templates (Improve your efficiency)

Create simple Templates – Convert an existing workbook to a Template – Chart Templates – Template options

Professional business charts (Create visual reports)

Selection techniques – Data structures – Best Practice

Shortcuts (Time savers)

Use a range of shortcuts and time saving techniques

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