Become an Excel Power User in 2.5 Hours (Udemy.com)

Exponentially improve modeling speed and efficiency by mastering Excel's most powerful features.

( 300 Reviews )

Created by: Eric Andrews

Produced in 2018

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course Description

**ANNOUNCEMENT January 2018: 1.
5 Hours of Practice Problem Lectures Added!**

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). Youll 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 todays business environment, and Ive excluded what you really dont 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, youll develop highly marketable business-focused Excel skills to help you outperform competing candidates for promotions, job opportunities, and internships. Youll 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 well re-use the concepts from previous sections to further reinforce them. All of the material is 100% example based and in many sections well use one continuous example through multiple lectures.

The course is composed of 27short lectures (most between 2-10 minutes) each of which cover one concept at a time, and 8 lectures covering practice problems.
The full course length is around 4 hours with 2.
5 hours of conceptlectures and 1.
5 hours of practice problems. 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, youll be able to follow along practicing each concept and receive a verifiable certificate of completion when you finish the course!
Who this course is for:
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 ExcelYou dont need prior experience in Excel to take this courseWhile the course does address advanced topics, this course is probably not for you if you already have heavy Excel modeling experience.

Time: 3.5h

Instructor Details

Eric Andrews

4.5 Rating
300 Reviews

My name is Eric Andrews and Im excited that youre 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 have over eightyears of experience working in finance across venture-backed technology and education companies. I'm currently an outsourced CFO and Growth Marketing Consultant for e-commerce startups, and previously was Head of Finance at iD Tech, a Silicon Valley-based startup with 150+ employees.
In my course you will notice straight away how I use my real-life experience to guide students through realistic example-based lessons.

Teaching Background
In addition to my professional skills,I'm a bestselling Udemy instructor with thousands of students fromover 80 countries.My all-time average rating for my courses is 4.6/ 5.0. If you want to know more about what my students think - just take a look at my reviews.

Summary
The main thing I want you to know is that Im incredibly enthusiasticabout taking complex Microsoft Excelsubjects and breaking them down into simple and understandable pieces. I look forward to sharing my knowledge with you!

Reviews

4.5

300 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Waleska on 12/20/2020

I thought the first few modules were quite basic and I was not very enthusiastic about the course, but it has got more interesting with different tips as it went along.

By Monique Pierce on 12/6/2020

Very thorough in explaining ways to be more efficient in Excel while also teaching new skills. I appreciate the repeating of past lessons' skills throughout as well.

By Randy Rundio on 12/6/2020

Completed the course as part refresher/part expanding my knowledge in preparation for an upcoming job interview that will involve an excel assessment. I felt like it was thorough without being overwhelming. I will likely do more courses by Eric.

By Youssef Mohamed on 11/25/2020

Very good course, focuses on what you actually need to know in Excel. the only thing is that some sections needs a few more lectures and deeper explanations, like Vlookup and What if sections. other than that its a great course.

By Lucia Ch on 11/20/2020

so far so good! just what i was looking for

By Alexandra Prieur on 11/1/2020

Lock cell part is very confusing.

By Keolahiwahiwa Byrne Pham on 10/25/2020

I feel like excel instruction is typically rushed and hard to follow. This course was a welcome difference, thanks.

By Samuel Terrazas on 10/20/2020

I liked the excel course, I wish it had more practice problems so we could practice more. Other than that I enjoyed taking the course

By Shivani Bhandari on 10/5/2020

In this one learns the most relevant excel concepts which will sure-shot find its utility in business related environment and scenarios.
It is extremely useful for analysts of various fields and learning along with practises exercises, assures a holistic learn-ability.
It really grooms you well, as it cuts through the noise and brings in what is necessary!

By Niko Miranda-Lavertu on 9/27/2020

This Excel course has been a very valuable investment of time and money; I'm more confident after each lesson. I have referred this course to some friends and colleagues because I'm so impressed!

By Mary Kukowski on 9/24/2020

Great course to both refresh and pick up new tricks. Especially liked that the course focused on critical skills, not the whole waterfront, most of which is not used day-to-day in actual work. So no wasted time. Material very clearly presented. Well-done! ( PS. One question/note: in the pivot table charts section, the red and greening labeling was incorrect; the green bar showed red sales and the red bar showed green sales.)

By Vipin on 8/24/2020