Excel with The Ultimate Microsoft Excel Course

Go from Excel Beginner to Excel Expert in 10 Hours - Using Microsoft Excel 2010, Excel 2013 or Excel 2016
4.4 (318 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.
3,669 students enrolled
$19
$190
90% off
Take This Course
  • Lectures 185
  • Length 10.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • 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 4/2016 English Closed captions available

Course Description

*** Lifetime access and a 30 day, 100% money back guarantee ***

Welcome to the Ultimate Microsoft Excel Course, which has over 190 short and precise tutorials. This course was created by a hand-pick of Udemy's best Excel instructors, so you are sure to benefit from their unique Excel skills.

The course covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features and keyboard shortcuts!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in Microsoft Excel. 

The course is designed for Excel 2007, 2010, 2013 or 2016. There are 23 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to work with various time saving Formulas, create automated reports with the press of a button, WOW your boss with stunning Excel Charts and get noticed by top management & prospective employers. 

The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!

In this course there are FREE downloadable Excel workbooks for each tutorial and a BONUS video section as well as each instructor's favorite Excel shortcuts.

We have collectively been helping over 45,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way

These tutorials will give you career-building skills that you can use to become better and more efficient at your job.


If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc....then this course is for YOU!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and we will answer them personally within the day!

We are so confident that you will get lots of value from this course that you can take it for the full 30 days, download all the workbooks, watch all the videos and apply it to your work to see the results. If you're not 100% satisfied, we will be more than happy to refund the full purchase amount!

So go ahead and learn from the following in depth Excel subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...

What are the requirements?

  • Compatible with Microsoft Excel 2007, 2010, 2013 or 2016
  • Compatible with Excel 2011 & 2016 for Mac
  • This course was recorded using Excel 2010, 2013 & 2016, so you will get every new feature covered

What am I going to get from this course?

  • Master the Basics of Excel: how to navigate Excel, create a spreadsheet and save your work
  • Gain confidence with the usage of top 50 Excel formulas
  • Discover multiple ways on how you can maximize VLOOKUP
  • Learn about the Text, Mathematical, Date and Time, Logic, Financial, Informational Excel Formulas
  • Use Excel Tables to give color & analytical power to your boring lists
  • Use Pivot Tables to analyze thousands of Excel rows & create interactive reports with key business metrics in a flash!
  • Create interactive Excel Dashboards that will get you noticed by top management & prospective employers
  • Create Bar, Column, Pie and Line Charts in Excel
  • Create 3D maps and use 1-Click forecasting in Excel 2016
  • Understand how Excel Macros and VBA work
  • Learn Excel Macros and VBA through Project Based Scenarios
  • Create Excel Macros from Scratch using the Excel Macro Recorder
  • Modify Excel Macros with custom VBA in order to create more dynamic automation

What is the target audience?

  • New users, beginners, intermediates and advanced Excel users
  • Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and more
  • People who want to change career and apply for a new job
  • Small business owners who want an easy way to manage their business finances, accounting reports, and other documents
  • People who work with large volumes of data and want to quickly sift through, analyze, and chart the data in a professional way
  • People who prepare reports that require constant updating with new data on a daily/weekly/monthly basis
  • Import data into Excel from an external source e.g. ERP System like Oracle, SAP, PeopleSoft, company database, Access, Web etc...and need to quickly & accurately analyze that data and extract valuable information

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: Course Overview
Course Overview
Preview
01:57
Section 2: Excel Basics
01:34

This lecture introduces you to what you're going to learn in the first few sections of the course.

09:47

This lecture is a complete tour of the various Excel dashboards and interfaces. It will show you how to use the tabs and ribbons at the top of an Excel workbook, how to navigate the file menu to save, print and customize documents in Excel. And it gives you a tour of the many features and tools available to you in Excel 2016.

Using Excel Templates to Save Time and Effort
08:56
02:42

The first step to successfully creating your first spreadsheet is opening and saving a document. This lecture will show you how to do that and how to save it to a place where you can find it later.

02:52
Quickly learn how to enter data into cells in your worksheet and move from cell to cell.
07:03

Learn how to create simple but powerful addition and multiplication formulas. These will prepare you to do the calculations neccessary for the Kitchen Remodeling Cost worksheet later in the course.

08:42
In this lecture I'll show you the difference between a workbook and a worksheet. I'll also teach you various ways of moving, copying, renaming and managing your worksheets within, and between different workbooks.
06:51

In this lecture I'll show you how to print your work. I'll also show you how to adjust your page layout, page orientation, margins, centering and more so you can make your printed work appear just how you would like it.

Article

Activity. Now it's time to put what you have learned into practice.

3 questions

Review what you've learned about the basics of Excel.

Section 3: Create Your First Excel Spreadsheet From Scratch
03:24

First, in this lecture I'll give you a quick tour of the finished product of the Kitchen Remodel Costs Worksheet. Then I'll show you how to create and format your heading.

Note: You can download the finished worksheet here so you can practice creating and changing the formatting and formulas used in this section.

03:28
In this lecture, first, you'll learn how to add subheadings to your columns and format them. Then you'll learn how to enter your list of materials into your first column and sort the list alphabetically.
02:55
Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.
06:08

In this lecture I'll show you how to use the multiplication and addition formulas that we learned earlier to calculate your total costs for each of your materials, as well as a grand total for the entire remodeling project.

03:24

In this lecture I'll show you how to do some final formatting to your worksheet. I'll show you how to add a few more colors and add grid lines to your worksheet to define your data a little bit more.

3 questions

Let's review what you've learned.

Section 4: Charts - How to Create Bar, Column and Pie Charts
07:14
Charts take boring data and turn it into a visual story. In this lecture I'll show you some of the possibilities of what you can do with charts and then we'll dive right into creating a chart from our Kitchen Remodel Costs worksheet.
07:13

Now that you've created a chart, let's do some formatting to make it look awesome!

In this lecture I'll show you how to resize your chart, change the color and width of your columns, add and delete different elements from your chart and how to change the title. At the end of this lecture you'll be able to create a beautiful, professional looking chart from your spreadsheet.

Article

Use this download to compare what is happening in the lectures with the real thing in Excel.

05:54

A bar chart in Excel is basically a column chart turned on it's side. The benefit of a bar chart is that it adds emphasis to differences in values because the bars stretch farther across the page.

In this lecture we'll create a bar chart and we'll do some additional formatting to it to make the data really stand out.

11:36

Pie charts are great for showing percentages and how each individual part relates to the whole. In this lecture I'll show you how to create a pie chart in Excel from scratch. I'll also show you how you can easily convert an existing chart, such as the bar chart we created in the previous lecture, into a pie chart to save on formatting.

05:14
Line charts are best used to represent the change in a value over time. A good example of this is monthly sales numbers for a whole year. In this lecture I'll first show you how to quickly change our existing bar chart into a line chart. Then I'll show you how to use a new spreadsheet containing dates and sales numbers so you can see the best use of a line chart in Excel.
3 questions

Let's review what you've learned about charts.

Section 5: Introduction to Excel Formulas and Functions
02:00
This lecture defines a formula and shows you how a formula can help you do calculations in Excel.
08:18
A function is a piece of predefined code that you can use as part of your formula to increase the power of your calculations. This lecture shows you the power that a function has over simple formulas. It also shows you where to find functions and how to use them.
06:35

In this lecture I break down a basic formula into 6 main parts and show you how each part behaves as part of a formula.

The anatomy of an Excel formula is all of the numbers, words and symbols that make up a formula. These are all very important to understand because it enables you to create, modify or correct formulas to do the big calculations for you, saving you lots of time and effort.

This lecture will answer these questions:

  • What is the equals sign for in an Excel formula?
  • What do the parentheses do in an Excel formula?
  • How do you write the cell reference as a range of cells?
  • What is an operator?
  • What order of operations does Excel follow?
03:46
This lecture will show you some strategies and shortcuts to quickly and easily select cells for use in your formulas.
06:52

Most formulas that you create in Excel reference relative cells by default. However, by creating absolute cell

references you can incorporate a fixed cell into your equation while

still being able to copy the formula to other cells. This lecture

will show you the difference between absolute and relative cell

references, and it will show you

useful ways to use them in formulas.

3 questions

Let's review what you've learned about formulas and functions.

Section 6: Top 50 Excel Formulas
00:58

A quick introduction on the Excel Formulas and Vlookup topics with your instructor Bryan Hong.

Download this Exercise File
Article
02:18

Quick Tips on how to master these formulas with no need to memorize them.

Section 7: Text Formulas
TEXT: Concatenate Formula
Preview
01:32
TEXT: Find Formula
Preview
01:14
TEXT: Left Formula
00:52
TEXT: Len Formula
00:55
TEXT: Lower Formula
00:31
TEXT: Mid Formula
01:21
TEXT: Proper Formula
00:55
TEXT: Rept Formula
00:30
TEXT: Substitute Formula
01:09
TEXT: Trim Formula
00:47
TEXT: Upper Formula
00:26
TEXT: Value Formula
00:45
Section 8: Mathematical Formulas
MATHEMATICAL: Average Formula
Preview
01:35
MATHEMATICAL: Int Formula
Preview
00:37
MATHEMATICAL: Mod Formula
00:42
MATHEMATICAL: Rand Formula
00:40
MATHEMATICAL: Round Formula
00:54
MATHEMATICAL: Sum Formula
00:40
Section 9: Date and Time Formulas
DATE AND TIME: Day Formula
Preview
00:43
DATE AND TIME: Hour Formula
Preview
00:29
DATE AND TIME: Minute Formula
00:28
DATE AND TIME: Month Formula
00:27
DATE AND TIME: Networkdays Formula
00:52
DATE AND TIME: Now Formula
00:26
DATE AND TIME: Second Formula
00:31
DATE AND TIME: Today Formula
00:27
DATE AND TIME: Weekday Formula
00:44
DATE AND TIME: Year Formula
00:28
Section 10: Logic Formulas
LOGIC: And Formula
Preview
03:04
LOGIC: Countblank Formula
Preview
01:46
LOGIC: Countif Formula
01:08
LOGIC: If Formula
01:34
LOGIC: Large Formula
01:16
LOGIC: Max Formula
00:26
LOGIC: Min Formula
00:27
LOGIC: Not Formula
01:10
LOGIC: Or Formula
02:05
LOGIC: Small Formula
00:59
LOGIC: Sumif Formula
01:04
LOGIC: Vlookup Formula
02:29
Section 11: Financial Formulas
FINANCIAL: Fv Formula
Preview
02:17
FINANCIAL: Npv Formula
01:37
FINANCIAL: Pmt Formula
02:08
FINANCIAL: Ppmt Formula
02:36
Section 12: Informational Formulas
INFORMATIONAL: Column Formula
Preview
01:08
INFORMATIONAL: Isblank Formula
Preview
01:57
INFORMATIONAL: Iserror Formula
01:00
INFORMATIONAL: Isnumber Formula
00:28
INFORMATIONAL: Istext Formula
00:27
INFORMATIONAL: Row Formula
00:40
Excel Formula Review
3 questions
Section 13: VLOOKUP Deep Dive
Download this Exercise File
Article
07:34

We will learn how to search across a Starbucks menu using vlookup

03:20

Two lists can be easily compared using vlookup to find out the differences between them.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Steve McDonald, Dedicated Instructor Will Show You How | 26,000 Students

Learning is easier if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.

Whether I am teaching How to Publishing Kindle eBooks, How to Learn Excel, or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.

For over 10 years I have studied strategies to create passive income and how to use passive income to vastly improve the quality of your life.

I have tested many different strategies from investing in rental real estate to building niche websites about my hobbies to publishing Kindle eBooks. I have studied what works and what doesn't work, and I have narrowed my research down to the strategies that work the best for creating financial freedom and an improved quality of life.

Each of my courses is designed to share my hard-earned secrets with you. 

I hold nothing back. I won't bore you with all of the strategies that didn't work. I'll get right into the exact steps that I have taken to be successful so that you have the opportunity to replicate them.

Of course, it's no secret that one of my favorite ways to generate truly passive income is through publishing Kindle eBooks. I have published over 100 eBooks and published five of those in print. Many of my books have been bestsellers including my own pottery book The Despicable Five.

Once I developed my Kindle publishing system, learned some formatting secrets, and learned how to use some simple SEO skills, publishing eBooks became remarkably simple.

Even hiring writers, which would seem scary at first, is really easy and even fun when you follow my system. 

Using my system, you can publish one or two books and then roll the profits from them into hiring people to write more books for you, so you aren't taking any money out of your pocket.

It starts out as a little passive income snowball and as you add the profits back into the snowball it grows and grows until you are seeing a surprising and exciting amount of passive income.

I retired in 2014 thanks to my eBook publishing success. Now, I'm using my spare time to find the best ways to create passive income. As I find great ways to make money from home I'm more than happy to share what I learn with you.

You'll notice that my new favorite way to create passive income is teaching courses on Udemy. Check out my Udemy Course Creation course to see why I love it so much!

I am here to guide you on your way to success. You can contact me at any step of the way for assistance, even if you're unsure whether my course is the perfect fit for you. Let me know your concerns and I'll point you in the right direction, even if it's to someone else's course.

I'm always happy to help.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy for you.

Sign up for a course today! I'll see you in there.

Instructor Biography

Kyle Pew, Microsoft Certified Trainer - 25,000+ Udemy Students

Qualifications:

Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

  1. Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
    1. Excel, Word, PowerPoint, Outlook, Access and Visio
  2. SharePoint End-User 2007, 2010, 2013
  3. VBA (Excel and Access)
  4. Adobe Suite
    1. Photoshop, Illustrator, InDesign
  5. Maya (Modeling and Animation)
  6. Unity3d (Game Design)
  7. HTML, CSS and JavaScript
  8. Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

  • Brocade
  • Chevron
  • Genentech
  • Facebook
  • Levi Strauss
  • PMI Mortgage Insurance
  • State Fund
  • Bank of the West
  • VISA
  • Walmart
  • and many more...


What Students have said about Kyle:

      • "Kyle was off the chart "GOOD""

      • "ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

      • "Awesome trainer because I'm computer "stupid" and he helped me understand it."

      • "Kyle Pew is very knowledgeable and presented information with exceptional skill."


In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

Instructor Biography

John Michaloudis, Founder of MyExcelOnline | 25,000+ Excel Students

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!

I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline.  I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!

I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

Join one of my courses and get ready to change your life!

Ready to start learning?
Take This Course