Become an Excel Power User in 2.5 Hours
4.5 (152 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
506 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Become an Excel Power User in 2.5 Hours to your Wishlist.

Add to Wishlist

Become an Excel Power User in 2.5 Hours

Exponentially improve modeling speed and efficiency by mastering Excel's most powerful features.
4.5 (152 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
506 students enrolled
Created by Eric Andrews
Last updated 9/2016
English
Current price: $27 Original price: $100 Discount: 73% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Become proficient in business-focused Excel
  • Increase speed 3X using keyboard shortcuts
  • Clean and manipulate business data sets
  • Filter and sort to investigate business questions
  • Develop graphical visualizations to simplify big data
  • Write powerful Vlookup & Hlookup formulas to extract specific information from data tables
  • Create advanced conditional statements
  • Quantify the sensitivity of business models to changes in multiple variables simultaneously using what-if-analysis
  • Slice, dice, and extract insights from large data sets using pivot tables
View Curriculum
Requirements
  • You should be running a Windows operating system to get the most out of the course (we’ll cover why in lecture 1!). The formats, functionality, and keyboard shortcuts are different for Excel on a Mac operating system.
  • Please make sure you’ve downloaded and installed Microsoft Excel (while the course is taught on Excel 2016, an earlier version of the software will work perfectly fine to complete the course).
Description

This is a 100% example-based comprehensive Microsoft Excel training course with a special focus on speed, automation and efficiency (the keys to becoming a power-user). You’ll learn how to build models, write formulas, and perform analysis.

Master Microsoft Excel Rapidly in this Comprehensive Course!

As a finance professional, I built the curriculum based on the skills needed to succeed in today’s business environment, and I’ve excluded what you really don’t need to know. This course is a hack to develop advanced power-user skills in Microsoft Excel 2016 in a very short period of time.

In this course you will learn how to:

  •       Increase Excel speed 3X by abandoning the mouse
  •       Clean, format, filter, and sort data sets
  •       Create dual axis charts to compare related data sets
  •       Investigate business questions using conditional statements
  •       Analyze the sensitivity of results to changes in variables using what-if analysis
  •       Slice, dice, and extract rapid insights using pivot tables

Why Excel Skills Matter

Advanced Microsoft Excel skills can open up a whole myriad of career opportunities (especially analyst roles) in industries such as finance, consulting, analytics or other business roles. Excel is the primary tool used in financial modeling and ad-hoc data analysis.

In this 100% example based course, you’ll develop highly marketable business-focused Excel skills to help you outperform competing candidates for promotions, job opportunities, and internships. You’ll learn what it means to be an Excel power-user, and why it can be such an unfair advantage to develop this skill set.

How is the Course Structured?

The course curriculum builds on itself, meaning that as we continue forward in the course we’ll re-use the concepts from previous sections to further reinforce them. All of the material is 100% example based and in many sections we’ll use one continuous example through multiple lectures.

The course is composed of 27 short lectures (most between 2-10 minutes) each of which cover one concept at a time, and the full length of the course is 2.5 hours. There are screencasts, business discussions, quizzes and a downloadable file of the full course curriculum to practice along with.

I designed the course to be hands-on and engaging. Complete with working files, you’ll be able to follow along practicing each concept and receive a verifiable certificate of completion when you finish the course!

Who is the target audience?
  • This course is meant for new users or people with some Excel experience looking for a refresher on most powerful features and efficiency techniques in Excel
  • You don’t need prior experience in Excel to take this course
  • While the course does address advanced topics, this course is probably not for you if you already have heavy Excel modeling experience.
Curriculum For This Course
27 Lectures
02:18:55
+
Section 1 - Intro to the course!
1 Lecture 05:54

Lecture includes:

  • Discussion of 100% example-based course curriculum (you will learn by doing!)
  • Overview of concepts students will learn
  • Discussion of how course is specifically tailored for analysts and has been stripped to the core essential functions for this profession
  • Review the supporting data files and how to download them
  • Explanation of the similarities and differences between Excel on a Windows vs. Mac operating system (OS)
  • Why mastering Excel on Windows OS is more useful than Mac
Preview 05:54
+
Section 2 - Excel 101, formatting & basic formulas
6 Lectures 21:58

Lecture includes discussion on:

  • Writing formulas
  • Review of the most basic/common formulas 
    • =, SUM, PRODUCT, COUNT, MIN, MAX
Preview 04:37

Lecture includes:

  • Lesson on how to lock column & row references 
Preview 06:24

Lecture includes:

  • Lesson on how to freeze panes and why it will make your life easy
Preview 01:33

Lecture includes:

  • How to adjust column & row formats and sizes
  • How to adjust multiple columns or rows simultaneously 
  • How to change tab color and name
  • How to change multiple tab colors and names simultaneously
Formatting columns, rows, and tabs.
03:17

Lecture includes a review of industry standard formatting including:

  • How to format inputs (hard-coded assumptions)
  • How to format formulas
  • Why using separate formatting will save you tons of time
Formatting inputs vs. formulas
02:03

Lecture includes:

  • Stock number formats vs. custom number formats
  • How to create custom number formats
Custom number formats
04:04

Test your understanding of Section 2 in this quiz!

Section 2
6 questions
+
Section 3 - Increase Excel speed 3X by abandoning the mouse
4 Lectures 15:56

Lecture includes:

  • An example demonstrating a 3X+ speed increase when completing same set of functions with a mouse vs. without a mouse
Preview 05:03

Lecture includes:

  • How to navigate around sheets and between tabs without a mouse
Navigating around sheets and between tabs
03:13

Lecture includes:

  • How to navigate the menu bar with a mouse 
  • A step-by-step example of applying formats to a data set without a mouse
Navigating the menu bar
04:28

Lecture includes

  • Top 11 high volume shortcuts that will get students kick started and comfortable to going mouse-free
High-volume keyboard shortcuts
03:12

Test your understanding of Section 3 in this quiz!

Section 3
3 questions
+
Section 4 - Clean, manipulate and analyze data sets
6 Lectures 26:12

Lecture includes:

  • Example based lesson covering text functions, common functions used to clean and format messy data sets and transform them into tables that are easy to analyze and manipulate
Text formulas
10:33

Lecture includes:

  •  How to consolidate multiple columns into one and make data sets easier to work using tags and the concatenate function
Combining data with tags
02:44

Lecture includes:

  • How to split one column of combined data into multiple columns using the Text to Columns function
Splitting data with "text to columns"
02:00

Lecture includes:

  • How to set up data table filters to answer business questions
Filters
03:43

Lecture includes:

  • Basic data sorting as well as hierarchical sorts (multiple sorts at the same time, with a hierarchy of importance) for complex questions
Sort data
03:43

Lecture includes:

  • How to use tags and filters or sorts to answer a variety of questions about a data set
Tag, filter and sort data
03:29

Test your understanding of Section 4 in this quiz!

Section 4
7 questions
+
Section 5 - Visualize and present data
3 Lectures 11:35

Lecture includes

  • Conceptual framework for presenting data
  • Discussion around when vs. when not to visualize data
  • Example of a single data set presented in different ways 
Preview 03:50

Lecture includes:

  • How to create a simple chart (graph) in excel
  • How to choose chart style, label axis, and format a chart
Creating a chart
03:03

Lecture includes:

  • How to create a dual axis chart
  • Example of two data sets that are related and need to be visualized together
Dual axis charts
04:42

Test your understanding of Section 5 in this quiz!

Section 5
3 questions
+
Section 6 - Investigate questions using conditional statements
4 Lectures 29:48

Lecture includes:

  • How to write if-then statements
  • Common conditions 
  • High-volume examples
If-then statements
08:38

Lecture includes:

  • What type of questions require a nested if formula to answer
  • Description of how nested if statements work and how to write them
  • Example of labeling a sales column in a data set using a nested if function
Nested if statements
05:00

Lecture includes:

  • Description of how sumif & countif statements work
  • How to write statements with proper syntax
  • 6 examples of when to use sumif & countif statements
Sumif & countif
08:20

Lecture includes:

  • Description of how vlookups & hlookups work
  • How to write statements with proper syntax
  • 4 examples using vlookups & hlookups for data analysis
Vlookup & Hlookup
07:50

Test your understanding of Section 2 in this quiz!

Section 6
5 questions
+
Section 7 - Analyze the sensitivity of results using what-if analysis
2 Lectures 16:03

Lecture includes:

  • A simple explanation of what-if-analysis
  • The types of questions what-if-analysis helps us answer
  • Example of how to solve for the results using the goal seek function
  • Limitations of the goal seek function
Goal seek
07:13

Lecture includes:

  • How we can use sensitivity analysis tables to exaluate dynamic contexts
  • How to build a sensitivity analysis table
  • Investigation of how a business can attempt to raise profits using 3 example sensitivity tables
  • 3 examples building sensitivity analysis tables to evaluate results 
Sensitivity analysis tables
08:50

Test your understanding of Section 7 in this quiz!

Section 7
3 questions
+
Section 8 - Slide, dice and extract rapid insights from data using pivot tables
1 Lecture 11:29

Lecture includes:

  • The structure and concepts behind pivot tables
  • How to setup a pivot table
  • How to answer questions about data sets using examples
Pivot tables and pivot chart
11:29

Test your understanding of Section 8 in this quiz!

Section 8
4 questions
About the Instructor
Eric Andrews
4.5 Average rating
150 Reviews
506 Students
1 Course
Finance & Analytics Professional

My name is Eric Andrews and I’m excited that you’re reading my profile! I want you to be confident that I can provide the fastest and most industry-relevant training there is, so here is my background.

Finance Background

Professionally, I’m a senior financial analyst and business intelligence consultant with over 5 years of experience in the finance, technology and education industries. In my most recent role, I’ve been running financial planning & analysis at iD Tech, a Silicon Valley-based startup with 125+ employees, but prior to that worked at Bank of America Merrill Lynch & Hewlett Packard.

I’ve built my career on my ability to develop technical expertise in software very quickly (I developed power-user skills in Excel in 3 weeks) to analyze data and automate processes.

In my course you will notice straight away how I use my real-life experience to guide students through realistic example-based lessons. I’m also passionate about public speaking, and regularly present to the Board of Directors of iD Tech.

Summary

The main thing I want you to know is that I’m incredibly enthusiastic about attacking data sets and business questions with Microsoft Excel and I look forward to sharing my knowledge with you!