Become an Excel Guru - Master Training - Get your Dream Job!

Learn Real World Examples to Go From Beginner to Excel Guru. Ace the Interview, Build Confidence and get your Dream Job!
4.6 (32 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.
1,274 students enrolled
$19
$175
89% off
Take This Course
  • Lectures 74
  • Length 10 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 8/2015 English

Course Description

Excel Master Course for the Real World

From Beginner to Excel Guru

This course was designed to take Excel users at any level, whether you are someone who is just starting out with Excel or someone who has used Excel for years but you just know that there is so must more you could be doing with Excel and by the end of the course turn you into an Excel Guru.

People who take my courses usually end up knowing more about analyzing and managing data in Excel than 90% of people you meet in your working career, and for a large population of my students this percentage would be closer to 95-99%. That is my goal, to give you the skills necessary to become the “Excel Superstar" in your office or at your university.

You will find this course to be designed a little different than all other courses and that is what makes it so effective.

What makes this course so effective and so unique?

You are by newest employee and I've created a fictitious boss that gives us real world projects to us to complete.

Each email project builds upon what you've learned in the previous projects.

So instead of just going through Excel's interface and learning one thing at a time we learn how to use all of the tools in Excel simultaneously to complete each project.

The difference?

You will learn start to think in terms of solving real-world problems where Excel is a just a powerful tool that we use to get to the end result rather than just learning how to do things in Excel.

At the end of this course, Excel will just become the “go-to" tool in your arsenal used to solve the problem and get the job done.

It won't matter if you need to prepare a quick report or a major analysis that you need to send out to a 3rd party or month-end reconciliations and analysis.

Whether you are preparing a budget for a fortune 500 company or reconciling your checkbook

at home.

We'll naturally learn to use Excel as the powerful tool it was designed to be to solve any problems we encounter.

This course is divided into three sections:

Excel, the Basics and Beyond

Ultimate Reconciliations and Analysis

and lastly, Pivot Table Domination.

In the first section, we take a fresh look at all of the basics in Excel.

Every thing from:

  • Formatting, Saving & Filtering Data
  • Using formulas (sums, subtotals & basic arithmetic)
  • Working with multiple types of commenting
  • Correctly working with multiple sheets of data simultaneously
  • Merging data from various locations
  • Produce Amazing looking charts
  • Flow Charts
  • Org Charts
  • Much more…

In the second section, we learn how to analyze and reconcile data in Excel. This is truly the meat and potatoes of Microsoft Excel.

We'll cover:

  • Vlookups
  • Anchoring Data
  • Pivot tables
  • If/Then logic formulas
  • Nesting multiple formulas together to get a desired result
  • Reconciling data in multiple tables from multiple sources
  • How we can completely eliminate errors in our formulas
  • How to customize our workspace in Excel
  • Excel Options
  • Security Settings
  • Named ranges
  • How we bring it all together..
  • and much more…

In the third section we cover everything you ever wanted to know about pivot tables.

  • First we cover what everyone must know before creating pivot tables.
    • This is difference between pivots being a absolutely simple to work with and you pulling your hair out because something isn't working as expected.
  • Adding new data to an existing pivot table
  • Create trends in the pivot table
  • Rolling 12 month analysis
  • Immediately changing the design and format of your pivot tables
  • How to create formulas in a pivot table
  • Slicers
  • Running totals
  • Weighted averages
  • Pivot charts
  • and a whole lot more…

As you can probably tell I love Excel, I use it for pretty much everything but there is one other thing I'd like to mention.

Listen, I'm can't make any guarantees but when the US economy took a turn for the worse back in 2009, I saw a lot of people lose their jobs due to company's downsizing.

Simple economics - Sales decreased so the first cut always seems to be cuts to the headcount. It's the quickest way to cut costs.

This is a sad but true realty.

But I truly believe that my ability to manage and analyze data so effectively in Excel helped me remain gainfully employed while other people were “downsized."

Most of these people weren't bad employees but by really understanding how manage data in Excel set some people apart from others.

And those of us who super-efficiently managed, reconciled and analyzed data (With Microsoft Excel) where typically the one's who remained.

Another area where becoming a master of managing data in Excel really helps is on job interviews.

Most people you work for in business will not know as must as you will about managing, analyzing and reconciling data in Excel.

So they tend to rely a lot on you to produce reports and analysis that they need.

So become almost like a “right-hand" man (or woman) to your boss. This not only helps in your job security but also you tend to work on a lot of the items that your boss is working, helping you grow you career as much as help your boss.

A true Win-Win!

So let me show you exactly how I manage projects using Microsoft Excel to the most productive (and valuable) employee you can possibly be.

What are you waiting for?

Let's get started Right Now!

What are the requirements?

  • Excel users of all levels will benefit from this course
  • This Course is broken down into three sections
  • The first section covers the basics and beyond
  • The second covers Analysis and Reconciliations made simple using Excel
  • The third section covers pivot tables and charts

What am I going to get from this course?

  • Analyze and Reconcile Data using Microsoft Excel
  • Learn how to solve real world problems that come up everyday in the business world.
  • Learn how to think like a problem solver rather than just learn how to do things in Excel

What is the target audience?

  • Anyone who wants to learn Excel. From beginner to seasoned user.
  • Students who want learn how to manager organize their workflow
  • People looking to change careers or get back into the workplace and need to pick up some new skills

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: Email Project # 1
Intro - What Does this Course Cover?
Preview
06:27
One thing before we get started.
Preview
00:54
11:00

Our first project, check the resources for some quick reference guides.

Formatting Cells and Columns
12:28
Our First Formula in Excel
14:01
Saving Files, CSV's and PDF's
04:08
Quiz - Email # 1
3 questions
Section 2: Email Project # 2
Summaries & Find and Replace.
09:02
Filtering in Excel
05:15
Subtotaling - Sums, Averages & Counts
14:07
Freeze the Data in your Spreadsheet
06:46
Setting and Print Range for Worry Free Printing
06:46
Quiz - Email # 2
2 questions
Section 3: Email Project # 3
Text Wrapping in the Headings
04:23
Basic Arithmetic in Excel
08:27
All About Comments
05:52
Quiz - Email # 3
2 questions
Section 4: Email Project # 4
Copying and Moving Multiple Tabs in a Spreadsheet
12:33
Linking to Multiple Tabs & Custom Lists
15:06
Merging Data from Multiple Cells into a Single Cell
11:23
Quiz - Email # 4
1 question
Section 5: Email Project # 5
Building Professional Charts in Excel
08:58
Section 6: Email Project # 6
Inserting Pictures, Word Art and Smart Art
13:01
Section 7: Email Project # 7
Working with Data from an Email
07:25
Vlookups - The Ultimate Tool
11:20
Anchoring our Formulas
08:27
Polishing Up the Data for Management
10:59
Quiz - Email # 7
2 questions
Section 8: Email Project # 8
Using Vlookups in Separate Spreadsheets
11:40
Summarizing Data with a Pivot Table
13:10
Quiz - Email # 8
1 question
Section 9: Email Project # 9
Using the If/Then Formula to Test Logic
05:21
Pivot Table (Part 2) - Pivot Table Options, Filters and Subtotals
11:52
Excel Options
03:52
Section 10: Email Project # 10
The And & Or Formulas - Our First Nested Formula
08:36
Adding New Columns into a Pivot Table
06:56
Section 11: Email Project # 11
Reconcile Two Tables of Data
10:52
Parsing Data - Text-to-Columns
11:18
Finish Up The Reconciliation - Remove #N/A
06:24
Section 12: Email Project # 12
How to Get Rid of Errors in Your Formulas
04:29
Section 13: Email Project # 13
Customize Your Workspace in Excel
05:06
Section 14: Email Project # 14
Security Settings for Sensitive Data
04:47
Section 15: Email Project # 15
Bringing It All Together - Named Ranges
08:56
Bringing It All Together - Using Named Ranges in Formulas
09:41
Bringing It All Together - Create New Named Ranges to Finish the Project
06:45
Bringing It All Together - Add New Data to the Range
07:32
Section 16: Project # 16
The Most Important Thing to Know About Pivot Tables
04:00
Section 17: Project # 17
Our First Pivot Table
12:47
Section 18: Project # 18
Add New Data to an Existing Pivot Table - Trends
13:44
Create a Rolling 12 Month Trend Analysis
11:26
Section 19: Project # 19
Pivot Table Designs
12:38
Section 20: Project # 20
Formulas in the Pivot Table - Calculated Items
08:19
Formulas in the Pivot Table - Calculated Fields
08:00
Section 21: Project # 21
Instantly Get a Supporting Data Report from a Pivot Table
02:04
Section 22: Project # 22
Running Totals & Weighted Averages
04:05
Section 23: Project # 23
Let's Slice & Dice
02:34
Section 24: Project # 24
Advanced Filtering, Grouping & Conditional Formatting
03:19
Section 25: Project # 25
Pivot Charts
09:38
Section 26: Reference
01:57

I added a 4th reference section to the course that included videos on various individual formulas.

Also (where applicable) I added the actual Excel file that i work with in the video so you can download and practice along with me.

This video shows you how to download the files.


RANDBETWEEN
05:29
TRIM
04:36
CONCATENATE
09:19
TEXT TO COLUMNS
11:10
05:50
FILTER
12:20
10:09

SUBTOTAL vs SUM - Use Sum and Subtotals with Filters to Quickly Analyze Data

09:24
ROUND - ROUNDUP - ROUNDDOWN - Simple tricks to make your reporting much cleaner
SUMIF & COUNTIF
Preview
07:35
SUMIF vs SUMIFS
08:37
04:26

An Excellent trick to use when you need to fill in blank spaces with a table a data in Microsoft Excel

04:49

See examples or how to use the AND & OR Formulas in Microsoft Excel

06:27

Learn Multiple ways to use the amazingly useful IF THEN Statement in Microsoft Excel

07:28

Using the IF Formulas (Part II) - Nesting Multiple IF formulas for greater flexibility

11:46

Learn to Nest multiple different formulas in the IF formula for maximum flexibility.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Scott Falls, Excel Trainer/Teacher

Hi, My name is Scott Falls and I've been working as in accounting/finance going on twenty years.

For my entire professional career I've used Excel.

Since the 90's I've been the Excel "go-to" guy in every company I've worked. Senior management has always relied on me to complete complex tasks involving massive amounts of data. They also sent me to numerous live Excel training courses over the years, from the basics to advanced classes.

The problem I always had with this type of training was that I never felt like I learned what I needed to learn. I'd go with a list of questions about how to actually solve real problems from work and the majority of the class centered on very generic training. Not too many real world examples.

So after recently sending some staff to a class with an outside training company we realized that we weren't getting the benefit we had hoped for, the staff came back with some knowledge but not that real world experience that I needed them to have. Since I was always the "Go To" guy for Excel questions the senior management team approached me about putting together an in house training program. So I spend a lot of time creating the most useful training programs I could devise.

What makes this training the absolute BEST training that you can buy? Besides using real world examples, I've found the absolute best way for me to train someone is to have them sit right next to me while I show them how I perform the work that needs to get done.

So I devised a training program that uses real world examples solved as if you're sitting right next to me.

I have found that this is the absolute best way for you to see how real world work is done!

So when asked to become an instructor on Udemy I jumped at the chance.

I love teaching and sharing my knowledge, I think it's awesome seeing someone go from an absolute beginner to a very confident master.

Check out my courses to learn more and if you don't see something that you like drop me an email.

Ready to start learning?
Take This Course