Microsoft Excel: Data Reporting Tools

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

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

Course Completion Certificate

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

Curriculum:

• Introduction
• Consolidate
• Advanced Filtering
• Working with Tables
• Pivot Tables

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.