Skip to main content

Home Working in government Technology and Software Microsoft Excel 2016 Data Analysis and Power Tools Part 1

Microsoft Excel 2016 Data Analysis and Power Tools Part 1

  • bullet point
    Learn how to control formatting efficiently, manage tables and graphics or manipulate large quantities of text

Overview

Off the shelf (OTS)

This is the first of a 2 part series of courses examining the data tools and features found in Microsoft Excel 2016 Professional and Pro Plus*. The course is designed to examine a combination of new and revised features which are available to help you work with data in Microsoft Excel 2016. Features covered range from data importing to analysis leading to subsequent output in Excel. Analysis and outputs include data and graphical tools available in Microsoft Excel 2016.

*Some of the tools and features are only available in Microsoft Excel 2016 and include add-ins. This course is not suitable for anyone using Microsoft Excel Standard, Home or Student Editions.

It is assumed that the attendees on the course have existing Excel skills which at the very minimum meet the prerequisites listed.

Delivery method
Face to face icon

Face to face

Virtual icon

Virtual

Course duration
Duration icon

14 hours

Competency level
Working icon

Working

Blue building representing strand 2 of the campus map
Delivery method
  • face to face icon

    Face to face

  • Virtual icon

    Virtual

Course duration
Duration icon

14 hours

Competency level
  • Working icon

    Working

chatbotSpark login – Alpha testing