Study Learn Grow
Microsoft Excel: Data Reporting Tools

Microsoft Excel: Data Reporting Tools


There are no complicated formulas or difficult syntax, just a set of great tools to get Excel to do the hard work for you!

Overview

About this Course
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!

Basic knowledge
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

Course 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

What you will learn
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

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

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs