Microsoft Excel – Excel with The Ultimate Excel Course

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

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.

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.

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.

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.

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

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

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.

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.

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.

Let's review what you've learned.

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.

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

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.

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.

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

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?

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.

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

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

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

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

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