Excel with The Ultimate Microsoft Excel Course
4.4 (493 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.
4,550 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel with The Ultimate Microsoft Excel Course to your Wishlist.

Add to Wishlist

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 (493 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.
4,550 students enrolled
Last updated 11/2016
English
English
Current price: $10 Original price: $190 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10.5 hours on-demand video
  • 13 Articles
  • 20 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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
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 ...

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 185 Lectures Collapse All 185 Lectures 10:42:56
+
Course Overview
1 Lecture 01:57
+
Excel Basics
9 Lectures 48:46

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

Preview 01:34

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.

Preview 09:47

Using Excel Templates to Save Time and Effort
08:56

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.

Saving Your Document Where You Can Find It
02:42

Quickly learn how to enter data into cells in your worksheet and move from cell to cell.
Entering Data and Navagating Around the Cells
02:52

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.

Creating Simple Formulas to do Powerful Calculations
07:03

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.
Working with Workbooks and Worksheets
08:42

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.

Printing Your Work
06:51

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

Put Your Knowledge to Work - Create Your First Excel Document
00:19

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

Review of Excel Basics
3 questions
+
Create Your First Excel Spreadsheet From Scratch
5 Lectures 19:19

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.

Preview 03:24

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.
Formatting Subheadings and Columns, and Alphabetizings Lists
03:28

Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.
Entering and Formatting Numbers
02:55

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.

Create Formulas to Quickly Calculate Your Costs
06:08

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.

Formatting - Grids and Spacing
03:24

Let's review what you've learned.

Review of Creating Your First Spreadsheet
3 questions
+
Charts - How to Create Bar, Column and Pie Charts
6 Lectures 37:19
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.
Preview 07:14

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.

Format Your Chart
07:13

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

Download for the Next 3 Chart Lectures
00:08

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.

Create a Bar Chart
05:54

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.

Create a Pie Chart
11:36

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.
Create a Line Chart
05:14

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

Review of How to Create Charts
3 questions
+
Introduction to Excel Formulas and Functions
5 Lectures 27:31
This lecture defines a formula and shows you how a formula can help you do calculations in Excel.
Preview 02:00

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.
What is a Function?
08:18

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?
The Anatomy of a Formula
06:35

This lecture will show you some strategies and shortcuts to quickly and easily select cells for use in your formulas.
Preview 03:46

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.

Absolute vs. Relative Cell References
06:52

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

Review of Introduction to Formulas and Functions
3 questions
+
Top 50 Excel Formulas
3 Lectures 03:30

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

Preview 00:58

Download this Exercise File
00:14

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

Preview 02:18
+
Text Formulas
12 Lectures 10:57


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
+
Mathematical Formulas
6 Lectures 05:08


MATHEMATICAL: Mod Formula
00:42

MATHEMATICAL: Rand Formula
00:40

MATHEMATICAL: Round Formula
00:54

MATHEMATICAL: Sum Formula
00:40
+
Date and Time Formulas
10 Lectures 05:35


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
+
Logic Formulas
12 Lectures 17:28


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
15 More Sections
About the Instructor
Steve McDonald
4.4 Average rating
2,376 Reviews
37,905 Students
15 Courses
Dedicated Instructor Will Show You How | 37,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.

Kyle Pew
4.6 Average rating
6,533 Reviews
42,400 Students
15 Courses
Microsoft Certified Trainer - 40,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!

John Michaloudis
4.4 Average rating
802 Reviews
19,690 Students
3 Courses
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!