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.

Quickly learn how to enter data into cells in your worksheet and move from cell to cell.

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

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

Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.

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.

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.

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.

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.

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

This lecture defines a formula and shows you how a formula can help you do calculations in Excel.

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.

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?

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

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.