Excel 1
Core Data Analysis
Master the key skills that will save you hours when analyzing data in Excel
Our Excel courses are focused on data analysis. During this course, we cover the most critical Excel skills that business professionals require 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
80 expert videos. Pause, fast forward, and rewind to suit your individual pace
9+ 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 (45 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 - Navigation
1c - Filter (formerly the Auto Filter)
1d - Advanced Filter
1e - VLOOKUP
1f - Absolute vs Relative Referencing
1g - Dates in Excel
Part 1 - Intermediate Questions (1 to 14)
Part 1 - Advanced Questions (15 to 25)
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
Part 1 - Solution to Question 24
Part 1 - Solution to Question 25
2a - Text Functions
2b - Subtotal Tool
2c - Offset and Match
Part 2 - Intermediate Questions (1 to 10)
Part 2 - Advanced Questions (11 to 22)
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
Part 2 - Solution to Question 22
3a - Pivot Tables Introduction
3b - Pivot Tables Features
3c - Pivot Table Grouping Example
3d - Pivot Table Slicer
Part 3 - Intermediate Questions (1 to 13)
Part 3 - Advanced Questions (14 to 19)