Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Learning Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.  COURSE OUTLINE 1 - WORKING WITH FUNCTIONS AND COMPLEX CALCULATIONS Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.) Work with Logical Functions Work with Lookup Functions Work with Date and Time Functions Work with Text Functions 2 - WORKING WITH LISTS AND TABLES Sort and Filter Data Remove Duplicate Values Group and Outline Data Subtotal Data 3 - VISUALIZING DATA WITH CHARTS Create and Modify Charts Use Advanced Chart Features Save a Custom Chart Template 4 - USING TABLES, PIVOT TABLE REPORTS AND PIVOT CHARTS Create and Modify Tables Use Functions to Calculate in Tables Create a Pivot Table Report Manipulate Pivot Tables Present Data with Pivot Charts Filter Data by Using Slicers and Timelines

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill