Become an Excel Power User in 2.5 Hours

Exponentially improve modeling speed and efficiency by mastering Excel's most powerful features.
5.0 (6 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.
15 students enrolled
$19
$45
58% off
Take This Course
  • Lectures 27
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2016 English

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 in 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!

What are the 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).

What am I going to get from this course?

  • Increase speed 3X by abandoning the mouse
  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Section 1 - Intro to the course!
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)
  • Which mastering Excel on Windows OS is more useful than Mac
Section 2: Section 2 - Excel 101, formatting & basic formulas
04:37

Lecture includes discussion on:

  • Writing formulas
  • Review of the most basic/common formulas 
    • =, SUM, PRODUCT, COUNT, MIN, MAX
06:24

Lecture includes:

  • Lesson on how to lock column & row references 
01:33

Lecture includes:

  • Lesson on how to freeze panes and why it will make your life easy
03:17

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
02:03

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
04:04

Lecture includes:

  • Stock number formats vs. custom number formats
  • How to create custom number formats
6 questions

Test your understanding of Section 2 in this quiz!

Section 3: Section 3 - Increase Excel speed 3X by abandoning the mouse
05:03

Lecture includes:

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

Lecture includes:

  • How to navigate around sheets and between tabs without a mouse
04:28

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
03:12

Lecture includes

  • Top 11 high volume shortcuts that will get students kick started and comfortable to going mouse-free
3 questions

Test your understanding of Section 3 in this quiz!

Section 4: Section 4 - Clean, manipulate and analyze data sets
10:33

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
02:44

Lecture includes:

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

Lecture includes:

  • How to split one column of combined data into multiple columns using the Text to Columns function
03:43

Lecture includes:

  • How to set up data table filters to answer business questions
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
03:29

Lecture includes:

  • How to use tags and filters or sorts to answer a variety of questions about a data set
7 questions

Test your understanding of Section 4 in this quiz!

Section 5: Section 5 - Visualize and present data
03:50

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 
03:03

Lecture includes:

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

Lecture includes:

  • How to create a dual axis chart
  • Example of two data sets that are related and need to be visualized together
3 questions

Test your understanding of Section 5 in this quiz!

Section 6: Section 6 - Investigate questions using conditional statements
08:38

Lecture includes:

  • How to write if-then statements
  • Common conditions 
  • High-volume examples
05:00

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
08:20

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
07:50

Lecture includes:

  • Description of how vlookups & hlookups work
  • How to write statements with proper syntax
  • 4 examples using vlookups & hlookups for data analysis
5 questions

Test your understanding of Section 2 in this quiz!

Section 7: Section 7 - Analyze the sensitivity of results using what-if analysis
07:13

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
08:50

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 
3 questions

Test your understanding of Section 7 in this quiz!

Section 8: Section 8 - Slide, dice and extract rapid insights from data using pivot tables
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
4 questions

Test your understanding of Section 8 in this quiz!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Eric Andrews, 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!

Ready to start learning?
Take This Course