Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Microsoft Excel Course: Managing and Auditing Data

person icon Debbie McCusker

4.6

Microsoft Excel Course: Managing and Auditing Data

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

updated on icon Updated on May, 2024

language icon Language - English

person icon Debbie McCusker

English [CC]

category icon Office Productivity,Microsoft Office,Excel(Managing and Auditing)

Lectures -80

Resources -29

Duration -1.5 hours

4.6

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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.

Goals

What will you learn in this course:

  • 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

Prerequisites

What are the prerequisites for this course?

  • Basic Understanding of Excel, Computer Functions, and Mouse Navigation
Microsoft Excel Course: Managing and Auditing Data

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
1 Lectures
  • play icon Participant Guide
Auditing Excel Data
8 Lectures
Tutorialspoint
Creating Charts
8 Lectures
Tutorialspoint
Creating Pivot Tables and Pivot Charts
13 Lectures
Tutorialspoint
Macros Introduction
7 Lectures
Tutorialspoint
Grouping and Outlining Data
8 Lectures
Tutorialspoint
Smart Art and Objects
8 Lectures
Tutorialspoint
Managing Your Data
10 Lectures
Tutorialspoint
What-If Analysis
7 Lectures
Tutorialspoint
Solving Formula Errors
9 Lectures
Tutorialspoint

Instructor Details

Debbie McCusker

Debbie McCusker

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515