Microsoft Excel Data Analysis & Reporting 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
Price (exc vat): £195
PrintDURATION: 1 day
TIME: 09:30 to 16:30 GMT

This Data Analysis Reporting course starts with CSV data from a simulated 3rd party system. We convert, clean and manipulate the data ready for analysis. Our Excel Data Analysis Reporting course is a perfect course to measure company performance and is designed for a wide range of business users.

About Microsoft Excel Data Analysis & Reporting Advanced

About Microsoft Excel Data Analysis Reporting

Microsoft excel data analysis and reporting training courses Southampton, Portsmouth, Hampshire

Microsoft Excel Data Analysis, Reporting

Learn time saving techniques to analyse and report business data sets, using a wide range of invaluable formulas and fairly simple techniques. We come across many people who waste so much time using old techniques and a limited portfolio of formulas. This course will bring you up to date using Excel 2016’s latest toolkit.

The course is very interactive and you are encouraged to ask questions about your data.

Is this course for you?

You are required to analyse company data and create accurate professional reports.

Training Options

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

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

Course Includes

  • Computer and the latest software for each delegate
  • 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

Related courses

Microsoft Excel Business Performance  |  Data Analysis Microsoft Excel  |  Microsoft Excel VBA Macro Introduction

Aim & Objectives

Aim

To use a range of creative Excel techniques to Analyse and Report business data.

Course Objectives

By the end of the course you will be able to:
  • Use a combination of formulas to manage, separate, combine data.
  • Use the IF and IFERROR functions to calculate a value based on specified criteria; use conditional functions to summarize data; use PMT function to calculate periodic payments for a loan; use text functions to extract data strings; use date functions to calculate duration in years, months, and days; create array formulas to perform multiple calculations on multiple sets of data at one time.
  • Use VLOOKUP and HLOOKUP functions to find values in worksheet data; MATCH function to find the relative position of a value in a range; INDEX function to find the value of a cell at a given position in a range; and use data tables to project values.
  • Use the Data Validation feature to validate data entered in cells; and advanced filter options to display specific data.
  • Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates.
  • Create a PivotTable for analysing and compare large amounts of data; modify the PivotTable view by using slicers to filter data; improve the appearance of a PivotTable by changing its field and style settings; create a PivotChart to graphically display data from a PivotTable.
  • Export and import data
  • Use the Goal Seek, Solver and Scenario utilities to meet a target output by adjusting the values in the input cells; create scenarios to save important input values that produce different results.

Course Content

Excel Data Analysis and Reporting

Data

Use data from a 3rd party system in a CSV format.

Import CSV data into Excel format.

Change data orientation into columns.

Clean and manipulate large sets of data

Remove unwanted elements of data ‘ ; etc

Learn how to use individual and combined formulas to edit, separate and join data.

Advanced functions and formulas

Logical & Conditional functions | Financial functions | Text functions | Date functions | Array formulas

Lookups and data tables

Using lookup functions | Using MATCH and INDEX | Creating data tables

Advanced data management

Validating cell entries | Advanced filtering

Advanced charting

Chart formatting options | Combination charts | Graphical objects

PivotTables and PivotCharts and Slicers

Working with PivotTables | Modifying PivotTable data | Formatting PivotTables | Using PivotCharts | Create Slicers

Analytical tools

Goal Seek | Solver | Scenarios

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