Microsoft Excel: Data Reporting Tools

Simpliv

Course

Online

£ 10 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

This course will showcase some of the most useful tools used for not only bringing data together, but to turn that data into a professional report. You'll learn how to use tools such as Consolidate, Advanced Filtering for extraction and creating Pivot Tables and Charts.There are no complicated formulas or difficult syntax, just a set of great tools to get Excel to do the hard work for you!Who is the target audience?Excel users who work with data but don't need to use formulas
Anyone who wants to improve their knowledge of Excel tools and features

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

You'll be able to use the most efficient tools for extracting and reporting on data
You'll learn about bringing data together using the Consolidate tool
Extract data with multiple criteria using Advanced Filtering
Create and build Pivot Table report to showcase your data

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Microsoft excel training
  • Microsoft Excel
  • Excel
  • Microsoft Office
  • Excel Formula
  • Excel Sheet
  • Excel for Accounting
  • Database
  • Information Systems

Course programme

Introduction 1 lecture 01:50 Introduction Introduction 1 lecture 01:50 Introduction Introduction Introduction Introduction Introduction Consolidate 2 lectures 15:44 Consolidate Data from the same file Consolidate Data from multiple files Consolidate 2 lectures 15:44 Consolidate Data from the same file Consolidate Data from multiple files Consolidate Data from the same file Consolidate Data from the same file Consolidate Data from the same file Consolidate Data from the same file Consolidate Data from multiple files Consolidate Data from multiple files Consolidate Data from multiple files Consolidate Data from multiple files Advanced Filtering 1 lecture 14:08 Advanced Filtering for Data Extraction Advanced Filtering 1 lecture 14:08 Advanced Filtering for Data Extraction Advanced Filtering for Data Extraction Advanced Filtering for Data Extraction Advanced Filtering for Data Extraction Advanced Filtering for Data Extraction Working with Tables 2 lectures 22:56 Creating a Table for Analysing and Subtotalling Creating Summaries from Tables Working with Tables 2 lectures 22:56 Creating a Table for Analysing and Subtotalling Creating Summaries from Tables Creating a Table for Analysing and Subtotalling Creating a Table for Analysing and Subtotalling Creating a Table for Analysing and Subtotalling Creating a Table for Analysing and Subtotalling Creating Summaries from Tables Creating Summaries from Tables Creating Summaries from Tables Creating Summaries from Tables Pivot Tables 5 lectures 55:11 Introduction to Pivot Tables Analysing Data Grouping Data Pivot Table Slicers Pivot Charts Pivot Tables 5 lectures 55:11 Introduction to Pivot Tables Analysing Data Grouping Data Pivot Table Slicers Pivot Charts Introduction to Pivot Tables Introduction to Pivot Tables Introduction to Pivot Tables Introduction to Pivot Tables Analysing Data Analysing Data Analysing Data Analysing Data Grouping Data Grouping Data Grouping Data Grouping Data Pivot Table Slicers Pivot Table Slicers Pivot Table Slicers Pivot Table Slicers Pivot Charts Pivot Charts Pivot Charts Pivot Charts

Additional information

You'll need Excel 2010, 2013 or 2016 installed and a desire to learn new skills You should have a grasp of the basics of Excel as this is not a beginners course

See related categories

Microsoft Excel: Data Reporting Tools

£ 10 + VAT

The best Excel courses

See all

See all