Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel - Excel with The Ultimate Excel Course

Name: Microsoft Excel - Excel with The Ultimate Excel Course
Rating: 4.5 (1946 reviews)

Go from Excel Beginner to Excel Expert in 10 Hours - Using Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019

Created bySteve McDonald, Kyle Pew • 2,000,000+ Students, MyExcelOnline John Michaloudis, Bryan Hong

Last updated 10/2021

English

What you'll learn

Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
We teach you how to use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
Increase your Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
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

Course content

25 sections • 185 lectures • 10h 35m total length

Course Overview1:57

Introduction to Excel Basics1:34
This lecture introduces you to what you're going to learn in the first few sections of the course.
Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon9: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 Effort8:56
Discover how to save time using Excel templates, including budgets and calendars, and learn to modify them with your data and pivot charts for efficiency.
Saving Your Document Where You Can Find It2: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.
Entering Data and Navagating Around the Cells2:52
Quickly learn how to enter data into cells in your worksheet and move from cell to cell.
Creating Simple Formulas to do Powerful Calculations7: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.
Working with Workbooks and Worksheets8: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.
Print Your Work6: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.
Put Your Knowledge to Work - Create Your First Excel Document0:19
Activity. Now it's time to put what you have learned into practice.
Review of Excel Basics

Introduction - Creating and Formatting Your Heading3: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.
Formatting Subheadings and Columns, and Alphabetizings Lists3: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.
Entering and Formatting Numbers2:55
Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.
Create Formulas to Quickly Calculate Your Costs6: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.
Formatting - Grids and Spacing3: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.
Review of Creating Your First Spreadsheet

Introduction - How to Create a Chart7: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.
Format Your Chart7: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.
Download for the Next 3 Chart Lectures0:08
Use this download to compare what is happening in the lectures with the real thing in Excel.
Create a Bar Chart5: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.
Create a Pie Chart11: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.
Create a Line Chart5: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.
Review of How to Create Charts

What is a Formula?2:00
This lecture defines a formula and shows you how a formula can help you do calculations in Excel.
What is a Function?8: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.
The Anatomy of a Formula6: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?
How to Quickly Select Cells to Use in Your Formula3:46
This lecture will show you some strategies and shortcuts to quickly and easily select cells for use in your formulas.
Absolute vs. Relative Cell References6: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.
Review of Introduction to Formulas and Functions

TEXT: Concatenate Formula1:32
TEXT: Find Formula1:14
TEXT: Left Formula0:52
TEXT: Len Formula0:55
TEXT: Lower Formula0:31
Learn how to convert text to lowercase in Excel using the lower function, applying it to a cell with mixed case letters to produce all lowercase output.
TEXT: Mid Formula1:21
TEXT: Proper Formula0:55
Apply the proper function in Excel to convert text into proper case, capitalizing the first letter of each word while leaving the rest lowercase.
TEXT: Rept Formula0:30
TEXT: Substitute Formula1:09
TEXT: Trim Formula0:47
Apply the trim function in Excel to remove leading and trailing spaces from text. It retains spaces in the middle, removing only padding at the ends.
TEXT: Upper Formula0:26
Learn how the upper function converts text to all caps, contrasting with lower case, and apply it to your text to format it consistently.
TEXT: Value Formula0:45
Explore the text: value formula that converts text into numbers in Excel, see examples like 1 2 3.45 produce numeric results, and learn why non-numeric text triggers an error.

MATHEMATICAL: Average Formula1:35
Explore the average function in Excel by using individual numbers, a list, or ranges of cells to compute the mean, including how to select ranges.
MATHEMATICAL: Int Formula0:37
Learn how the int formula in Excel truncates the decimal portion to reveal the whole number, without rounding, turning 123.99 into 123.
MATHEMATICAL: Mod Formula0:42
MATHEMATICAL: Rand Formula0:40
Explore the rand formula in Excel, which returns a random number between 0 and 1 and influences other functions, producing all subsequent results as random numbers.
MATHEMATICAL: Round Formula0:54
MATHEMATICAL: Sum Formula0:40

DATE AND TIME: Day Formula0:43
Explore date and time formulas in Excel, using the today function and the day function to extract the day from a specified date, such as 15th March 2016.
DATE AND TIME: Hour Formula0:29
Discover how to use the hour formula in date and time calculations in Excel, by entering a specific time into a cell to extract the hour value.
DATE AND TIME: Minute Formula0:28
Extract the minute from a time value using the minute formula in Excel, demonstrated with 2:59 to return 59 in the selected cell.
DATE AND TIME: Month Formula0:27
Learn how to extract the month number from a date using the month formula in Excel, with an example where March 15 returns 3.
DATE AND TIME: Networkdays Formula0:52
DATE AND TIME: Now Formula0:26
DATE AND TIME: Second Formula0:31
DATE AND TIME: Today Formula0:27
Master the Excel today function, which returns the current date focusing on the day portion and is similar to now; see an example showing March 17, 2015.
DATE AND TIME: Weekday Formula0:44
master the weekday function to convert a date into its numeric day of the week, where Sunday equals 1 and Saturday equals 7.
DATE AND TIME: Year Formula0:28
Use Excel's year function to extract the year from a date, as shown with March 15, 2015 returning 2015.

LOGIC: And Formula3:04
LOGIC: Countblank Formula1:46
Learn how to use the countblank formula to count blank cells in a range, try different selections with shift, and grasp the essence of the function rather than memorizing parameters.
LOGIC: Countif Formula1:08
Learn how to use the countif formula to count values meeting a criteria within a range, such as values less than 10, and view the resulting count.
LOGIC: If Formula1:34
Explore the if formula in excel by setting a condition that outputs pass or fail based on a 75 threshold, with examples of 78 and 65.
LOGIC: Large Formula1:16
LOGIC: Max Formula0:26
Learn to use the max formula in Excel to find the largest value by passing a range, as shown with the 400 example.
LOGIC: Min Formula0:27
Learn how to use the min formula in Excel to find the lowest value in a range, illustrated by four values where the minimum is 100.
LOGIC: Not Formula1:10
explains the not function in Excel, returning the opposite boolean value of a condition. shows how not positive evaluates for negative, zero, and positive numbers.
LOGIC: Or Formula2:05
LOGIC: Small Formula0:59
LOGIC: Sumif Formula1:04
LOGIC: Vlookup Formula2:29
Learn how to use the vlookup function in Excel to search first column of a table and return the value from a chosen column, such as name, gender, or age.

Requirements

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

Description

You’re Just Seconds Away From Leveraging Excel That Will Make It Possible For YOU To:

Increase your Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
Use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

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 150,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.
----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and a 100% money-back guarantee!

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel

Who this course is for:

People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
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
If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Microsoft Excel - Excel with The Ultimate Excel Course

What you'll learn

Explore related topics

Course content

Course Overview1 lecture • 2min

Excel Basics9 lectures • 49min

Create Your First Excel Spreadsheet From Scratch5 lectures • 19min

Charts - How to Create Bar, Column and Pie Charts6 lectures • 37min

Introduction to Excel Formulas and Functions5 lectures • 28min

Top 50 Excel Formulas3 lectures • 4min

Text Formulas12 lectures • 11min

Mathematical Formulas6 lectures • 5min

Date and Time Formulas10 lectures • 6min

Logic Formulas12 lectures • 17min

Requirements

Description

Who this course is for: