Excel 2
Advanced Data Analysis
Master the key skills that will save you hours when analyzing data in Excel
More than ever, people are overwhelmed and inundated with the amount of data available. Our Excel courses are focused on data analysis. During this course, we cover advanced Excel skills that business professionals should know in order to analyze, manage and automate their data.
There are hundreds of Excel videos on the internet, but it’s hard to learn from watching. In this course, the learning happens from doing. We have included dozens of real-world problems to help you master the concepts.
Includes all content from our live sessions and incorporates Marquee’s teaching approach honed by 20 years in the classroom
52 expert videos. Pause, fast forward, and rewind to suit your individual pace
6+ Hours of Interactive Content
A Certificate will be provided upon course completion
Practice questions with solution videos and a full answer key
Presentation book of key concepts (60 pages of tips and resources)
Dedicated course support
Welcome and Course Objectives
FREE PREVIEWPC versus Mac
FREE PREVIEWFAQs: Maximizing Your Success in this Course
FREE PREVIEWCourse Materials and Technology Requirements
1a - Introduction
FREE PREVIEW1b - Advanced Computation Skills
1c - SUMPRODUCT
1d - Database Functions
1e - Index Functions
Part 1 - Questions
Part 1 - Solution to Question 1
Part 1 - Solution to Question 2
Part 1 - Solution to Question 3
Part 1 - Solution to Question 4
Part 1 - Solution to Question 5
Part 1 - Solution to Question 6
Part 1 - Solution to Question 7
Part 1 - Solution to Question 8
Part 1 - Solution to Question 9
Part 1 - Solution to Question 10
Part 1 - Solution to Question 11
Part 1 - Solution to Question 12
Part 1 - Solution to Question 13
Part 1 - Solution to Question 14
Part 1 - Solution to Question 15
Part 1 - Solution to Question 16
Part 1 - Solution to Question 17
Part 1 - Solution to Question 18
Part 1 - Solution to Question 19
Part 1 - Solution to Question 20
Part 1 - Solution to Question 21
Part 1 - Solution to Question 22
Part 1 - Solution to Question 23
2a - Naming
2b - Dynamic Naming
2c - Table Tool
Part 2 - Questions
Part 2 - Solution to Question 1
Part 2 - Solution to Question 2
Part 2 - Solution to Question 3
Part 2 - Solution to Question 4
Part 2 - Solution to Question 5
Part 2 - Solution to Question 6
Part 2 - Solution to Question 7
Part 2 - Solution to Question 8
Part 2 - Solution to Question 9
Part 2 - Solution to Question 10
Part 2 - Solution to Question 11
Part 2 - Solution to Question 12
Part 2 - Solution to Question 13
Part 2 - Solution to Question 14
Part 2 - Solution to Question 15
Part 2 - Solution to Question 16
Part 2 - Solution to Question 17
Part 2 - Solution to Question 18
Part 2 - Solution to Question 19
Part 2 - Solution to Question 20
Part 2 - Solution to Question 21