Microsoft Excel for Mac - From Beginner to Expert in 7 Hours

Learn how to easily use incredibly complex functions in Microsoft Excel. This video will teach you how to appear like an amazing genius. Even if you already are an amazing genius, this video will take your amazing genius qualities to the nth level. This video will show you the differences between formulas and functions. It will also show you how to easily use functions.

Learn how to create charts in Microsoft Excel.

Let's apply what we've been learning in an actual project. Using many of the skills learned so far, I will show you how to calculate your grade in a course. I will also show you resources for learning more about the differences between the "points" method and the "percentage" method when calculating a student's grade. And not only that, also included in this amazing video, you will see how to copy/paste data from the web and what the difference is between paste and "paste special." As if that wasn't enough, I will also marvel you with the history of spreadsheets and how a hippy named Dan Bricklin almost became one of the richest individuals in the world.

This video is amazing; it's awesome. You will love what you learn in this video. It will show you how to copy data from the web and get it into Excel. It will also show you some amazing awesome sources for data like data.gov. As if that wasn't enough, you will also learn about Gapminder.org which is absolutely, completely, totally mind blowingly cool.

One last video in this quickstart series - and it is one of the best! This video is going to show you how to use Google forms to gather data. You will learn how to create a form which you can then distribute to people to fill out. All of the data from people's submissions will be put into a spreadsheet!

These quiz questions will give you a quick review of what you've learned in section 2.

In addition to everything listed here in just a moment, in this video you will also learn about Google Location History, which is mind blowing! So now here is everything you'll learn about excel in this video: columns, rows, cells, name box, formula bar, worksheets, workbooks, ribbon, menus, the top left area, the bottom right area, adjusting the horizontal scrollbar, the status bar, views, gridlines, and printing.

While using Excel, your mouse pointer will change depending upon the context. Paying attention to the way your mouse pointer looks, and knowing what the different looking mouse pointers mean, will help you use Excel more effectively.

Learn how to use relative, absolute, and mixed references when writing formulas in Excel.

This quiz will help you review what you've learned in section 3.

Learn the differences between functions and formulas. Learn about some of the most commonly used functions. Learn about data and time functions, and about count functions. Learn how to discover new functions with the function reference. Learn how to use the function builder to easily build functions. You are learning, learning, learning so much awesome stuff!

Learn about some of the most commonly used financial functions, and see how to build them using the function builder.

Learn how to create a loan amortization schedule.

Learn how to measure the value of an investment like a pension.

Learn how to determine how much money you will receive each month from an investment like a pension.

Learn how to create a gradebook and use the awesome amazing vlookup function!

Learn how to use the "IF" function to add conditional logic to our spreadsheets.

Learn how to change the way things look based upon certain criteria. This is known as conditional formatting and this video is going to make you an expert at making your spreadsheets look beautiful!

Learn how to get rid of crappy errors in your spreadsheets. Learn how to make your spreadsheets appear amazingly dynamic, filling in content when it's there, and then just having the cells be empty when it's not.

This quiz will allow you to review the material you learned in this section.

Microsoft Excel charts - when we were in school and learning math, we called these graphs. Microsoft, however, calls them charts. Whether you call them charts or graphs, this video is going to introduce you to how use them. In addition, you'll learn about the nebulous art of manipulating people by how you present data.

This video will get you up and running with creating charts. Learn the basics of creating charts: (1) select the correct data, (2) use CMD to select non-contiguous data, (3) select the correct column headings and row headings, (4) choose the type of chart you want to create.

There are many different types of charts: pie charts, bar charts, column charts, line charts, scatter charts, combo charts, pivot charts. This video will introduce to the different types of charts and show you how they're used.

This video will show you how to create a pie chart! Creating pie charts is awesome and you're going to love creating pie charts!

Learn how to create line charts. Learn one of the most common uses for line charts.

Learn how to create column charts!

Learn how to create bar charts!

Sparklines are absolutely amazing. They're so super-cool. Making sparklines in your spreadsheets will make you look super-smart. You will "WOW" even experienced Excel users with this simple technique of creating sparklines.

Scatter charts are the unloved ugly ducklings of charts. Why would you use them? They're scattered; they're all over the place. Just like in the ugly duckling fairy-tale, however, once you get to know scatter charts, you will see their full-potential and beauty. Watch this video to learn how to create scatter charts and to learn about one of my favorite charts of all time, which is a scatter chart, at gapminder.org.

Area stacked charts are the chart equivalent of crazy drunk stumbling down the street with a bottle of Jack Daniel's in his hand - they rarely make sense to most people. Fortune is shining down upon you today, however, as I possess the unique ability to teach you how to understand these horrible charts.

Okay. If you watch no other videos in this training, you have to watch this one. Combo charts are, by far and away, one of the best things ever. Combo charts and sparklines, these are a few of my favorite things!

Of course, there's always something, isn't there, that just throws a snag in it all. If you drink, go get a drink. Then sit down and watch this. (and if you don't drink, go get a cookie, then sit down and watch this).

In Microsoft's eyes, you are a second-class citizen. Why? Because you're on a MAC, of course! And this is why you will not be able to easily create amazing awesome pivot-charts which is something, apparently, they have saved for only the Windows version.

This quiz will help you to review what you have learned in this section.

An introduction to leveraging the power of data.

Many people aren't aware of Google Adwords. This video will take you on a tour of both Google Adwords and the power of Excel to work with data.

There are many tips-and-tricks to extracting data from the web. This video will teach you how to be a master and harvesting data from the web.

There are a few pitfalls to avoid when it comes to sorting data. This video will quickly show you the best practices for sorting data.

There are two ways to filter data in excel: the right way and the wrong way. This video will show you both ways so that, from now on, you can always filter data in the best way.

It's easy to remove duplicates in Excel - this video will show you how!

Here's an old adage which I love: when you're learning something, if you want it to stick, you gotta be like a dog and just keep rolling around in it. This is true with anything: the more you do it, the more you learn it. We've already seen transposing data previously but here's a single video devoted to it. In addition, as an AMAZING BONUS, in this video I will show you an INCREDIBLE HACKING TECHNIQUE which you can use to WOW YOUR FRIENDS and GENERATE WARM "I LOVE YOU's" FROM YOUR DEAR ONE.

Data subtotaling is awesome and powerful. Often I keep using these words of praise, but they're true. There's a lot in Excel which is amazing, and subtotaling is one of these things. In addition, as a BONUS, I will introduce you to another amazing awesome tool for backing-up, and recovering, your work: git & github.

Data Tables are not my most favorite thing in Excel. They're not very intuitive, however, what they can do is pretty powerful. Data Tables are a mixed bag, but they're worth knowing about. In the right situation, Data Tables are just the tool for the job. It's good to be aware of Data Tables so that, if the need ever arises, you know they exist and can then go use them.

This quiz will help you to review what you have learned in this section.

Pivot tables are super-powerful. They are also super-simple to understand. So many people don't know how to use pivot tables. In just a few short minutes, this video will make you an expert in pivot tables.

This video shows you how to create pivot tables.

When the underlying data of a pivot table changes, the pivot table does not automatically change. To update a pivot table, you must manually refresh it. This video explains all of this and shows you what to do.

You are going to see some cool things about pivot tables in this video. You will learn how to create nested data which you can drill into to see underlying relationships.

Learn how to group your data in pivot tables.

You do not have pivot charts, nor do you have pivot slicers, on the Mac. These features are only on Excel for Windows. This video will explain these features and direct you to resources for learning about how to use them on a Windows machine.

This quiz will help you to review what you have learned in this section.

Formatting your worksheets is important. Join me on a quick tour of some of things we will learn about formatting worksheets.

Let’s take a moment to reflect about content and form. Thinking about content, and the form that it takes, is important in many areas of life. Being able to give the content of your spreadsheets good form will help you more effectively achieve your goals.

We’ve already briefly talked about templates. Here’s a little bit more of an in-depth look at how templates can save you time while helping you produce stunning worksheets

Learn how to use border and fill options to make your worksheets look amazing.

Learn how to very quickly use predefined styles to format your worksheets and make them beautiful.

This is a quick tour of some of the additional amazing things you can do with Excel to format your worksheets.

Inserting and formatting images in Excel is a super great thing to learn. Watch this video to learn the many powerful adjustments you can apply to photos and images in Excel.

Excel lets you inserts many types of media into your spreadsheets: audio files, movies, symbols, clip art, shapes. This video will show you the difference between these various items and how to use them in your spreadsheets.

This video will show you how to place and format pointing arrows, circle highlights, and even a yellow smiley face onto your spreadsheets.

This video is amazing; fantastic; wonderful; incredible. Superlatives can’t capture the fantastic-ness of this video. Watch it to learn how to add text-boxes with hyperlinks. Seriously, this video rocks, and the skills you are going to get from it will amaze your friends.

Word art lets you put in professional looking large typography. This video shows you how to use it.

Come explore the home ribbon with me! We’re going to go through it and make sure you understand all of the cool options available to help you make your spreadsheets look great.

You are amazing. You are.

This quiz will help you to review what you have learned in this section.

An introduction to printing an Excel worksheet.

Page layout will allow you to see how your spreadsheet will look when it’s printed. This video is an absolute “must watch video” as it’s going to show you the absolute best way to get your spreadsheet ready to print.

Page setup is the magical place where you can make adjustments to your spreadsheet so that it will print beautifully. This video will show you how to apply gridlines and headings, as well as how to include a column or row heading on every page of your data.

Headers and footers in Excel are not intuitive. It seems as if the header and footer area of Excel was created back in the early days of Microsoft, and hasn’t been changed since. Fortunately I’m here to guide you through this dark forest and show you how to understand them. I will also show you how to put page numbers on every page of your printed spreadsheets.

You can scale the content your spreadsheets. This allows you to adjust how much is shown on each page. Using this technique, you can find the perfect printed display of your spreadsheets.

This quiz will help you to review what you have learned in this section.

Macros don’t run on the Mac. However, you should still know what Macros are so that when you’re talking with people about Excel, you will understand what they’re talking about if they mention macros.

This is my illustration of how macros don’t work on the Mac. Watch me try to create one and not have it work!

This video will give you an example of what macros can be used for.

This video shows you how to password protect a workbook.

This video shows you how to protect other people from entering data into certain areas of your worksheets.

This video will show you how to integrate Microsoft Excel and Microsoft Word.

This quiz will help you to review what you have learned in this section.