Microsoft Excel: Pivot Tables, Analyzing Data, Macro, & more
4.5 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12 students enrolled

Microsoft Excel: Pivot Tables, Analyzing Data, Macro, & more

Commanding Excel Data with Charts, Pivot Tables, What-if Analysis, Macros, and more.
4.5 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12 students enrolled
Created by Debbie McCusker
Last updated 11/2017
English
English [Auto]
Current price: $30.99 Original price: $44.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 23 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create Pivot Tables and Pivot Charts
  • Trace Precedent cells and Dependent cells, as well as use other Auditing Tools
  • Use What If Analysis tools
  • Solve formula errors
  • Record and Run Macros
  • Use SmartArt and other objects in worksheets
  • Use tools to manage rows, columns, duplicates, and validation
  • Group, Outline, and Sub-Total data
Requirements
  • You should have a working knowledge of Excel. You should know how to work with Sheets and Basic Functions within Excel.
Description

*** Course access includes project files, quizzes & practice 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 auditing your data including:

  • 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 fileshomework, and course quizzeslifetime 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.


Who this course is for:
  • 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
Expand all 51 lectures 01:33:34
+ Auditing Excel
5 lectures 07:31
Trace Dependents
01:31
To learn how to view formulas in a worksheet instead of the results.
EXERCISE: Display Formulas in a Worksheet
1 question
Learn how to add, display, edit, and remove comments in Excel 2013.
EXERCISE: Add, Edit, and Remove Comments
1 question
QUIZ - Auditing
8 questions
+ Creating Charts
5 lectures 10:08
Elements of Charts
02:07
Working with Charts - Chart Elements, Styles, Colors, and Filters
02:38
Chart Data Labels
01:46
Learn how to Insert Charts in Excel.
EXERCISE: Insert a Chart
1 question
QUIZ - Charts
9 questions
+ Creating Pivot Tables and Pivot Charts
7 lectures 11:10
Choose Fields and Group Data
02:00
Data Display and Refresh
01:26
Insert Pivot Chart
02:05
Learn how to insert a Pivot Table, Group, and Filter Data.
EXERCISE: Insert a Pivot Table, Group and Filter Data
1 question
Pivot Tables Real Life Example 2
01:32
In this exercise, you will answer questions by creating Pivot Tables.
EXERCISE: Real Life Examples (1 & 2)
4 questions
QUIZ - Pivot Tables & Pivot Charts
8 questions
+ Grouping and Outlining Data
5 lectures 07:21
Grouping Data
02:03
Adding Subtotals
02:16
Outlining Data
01:14
Viewing Grouped and Outlined Data
01:20
To learn how to Group and Subtotal data.
EXERCISE: Group and Sub Total
1 question
QUIZ - Grouping & Outlining Data
8 questions
+ Smart Art and Objects
7 lectures 14:58
Insert SmartArt
02:48
SmartArt Move and Resize
02:19
Insert Images and Screenshots
02:35
Insert Text Box
01:39
Insert Shapes
01:24
SmartArt and Objects Contextual Tabs
03:17
Practice inserting SmartArt diagrams in Excel.
EXERCISE: Insert SmartArt
1 question
QUIZ - SmartArt
5 questions
+ Managing Your Data
5 lectures 08:50
Text to Columns
03:43
To learn how to Transpose Data from rows to columns or columns to rows. To learn how to Open Text files with Excel.
EXERCISE: Transpose Data and Open Text File
1 question
Checking for Duplicates
01:09
Data Validation Rules
01:59
To learn how to Create Data Validation Rules.
EXERCISE: Validation Rules
1 question
Consolidate Data
01:22
QUIZ - Managing Your Data
7 questions
+ What If Analysis
4 lectures 09:46
What-if Goal Seek
01:49
What-if Scenario Manager
02:36
What-if Data Table
04:26
QUIZ - What-If Analysis
5 questions
+ Solving Formula Errors
7 lectures 12:59
Understanding Formula Errors
01:38
Common Errors
02:34
Error Checking
04:04
Trace Errors
01:19
Evaluating Formulas
01:31
QUIZ - Solving Formula Errors
5 questions