Tutorialspoint
Subscription Includes
$ 147   12.99

Microsoft Excel: Managing and Auditing Data

Created by Debbie McCusker, Last Updated 06-Nov-2020, Language:English

Microsoft Excel: Managing and Auditing Data

Learn to Manage and Audit Data using Pivot Tables, Charts, Analysis functions, Macros, and more!

Created by Debbie McCusker, Last Updated 06-Nov-2020, Language:English

What Will I Get ?

  • SmartArt
  • Pivot Tables & Pivot Charts, including Slicers
  • Design & Formatting Options
  • Grouping & Subtotalling Data
  • Importing Data from External Text Files
  • Tracing Errors
  • What-If Analysis
  • Macros

Requirements

  • Basic Understanding of Excel, Computer Functions, and Mouse Navigation

Description

*** Course access includes project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee! ***

This course gives you a comprehensive understanding of Excel Pivot Tables, Pivot Charts, Macros, and other functions to manage and visualize your data. The course will guide you through interactive, hands-on demos, and exercises every step of the way. As you participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder.

We'll cover everything you need to know about managing and visualizing your data including:

  • SmartArt
  • Pivot Tables & Pivot Charts, including Slicers
  • Design & Formatting Options
  • Grouping & Subtotalling Data
  • Importing Data from External Text Files
  • Tracing Errors
  • What-If Analysis
  • Macros - how to create and use them to avoid repetitive work

In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge.

Full course includes downloadable resources and project files, homework, and course quizzes, lifetime access and a 30-day money-back guarantee.

Who is the target audience?

  • Anyone who works with data and needs to ensure its validity by auditing the data.
  • Those who need to add visuals to spreadsheets, such as Charts, Pivot Tables, and other visual elements.
  • Anyone who manages large spreadsheets and needs to ensure data accuracy and validity.

Course Content

Debbie McCusker

Have Questions? Go Ask Debbie!