Microsoft Excel Course: Managing and Auditing Data
Learn to Manage and Audit Data using Pivot Tables, Charts, Analysis functions, Macros, and more!
Office Productivity,Microsoft Office,Excel(Managing and Auditing)
Lectures -80
Resources -29
Duration -1.5 hours
30-days Money-Back Guarantee
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
- 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
- Basic Understanding of Excel, Computer Functions, and Mouse Navigation
![Microsoft Excel Course: Managing and Auditing Data Microsoft Excel Course: Managing and Auditing Data](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3843/course_3843_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Participant Guide
Auditing Excel Data
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Creating Charts
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Creating Pivot Tables and Pivot Charts
13 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Macros Introduction
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Grouping and Outlining Data
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Smart Art and Objects
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Managing Your Data
10 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What-If Analysis
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Solving Formula Errors
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Debbie McCusker](https://www.tutorialspoint.com/assets/profiles/268833/profile/200_210722-1604260021.png)
Debbie McCusker
When people need answers, they tell others, “Go Ask Debbie.”
Debbie McCusker is a ATD Certified Master Instructional Designer and a Certified Microsoft Office Specialist with over 20 years’ experience as a Trainer and Instructional Designer, creating thousands of courses, teaching tens of thousands of people to improve Soft Skills, learn and apply Leadership Skills, and how to effectively use Microsoft Office and various other software programs
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)