Master Excel on Apple Mac and Succeed at Your Workplace

Let us quickly review the Excel’s user interface. Just launch Excel, so you can follow me. There is no specific workbook for this lesson.

Excel 2016 is the new version of Excel for Mac. Office 2016 was announced by Microsoft in March 2015 and is expected to come out in the second half of 2015. This lecture is an overview and the first look at the user interface of Excel 2016.

This lesson focuses on the very common tool called the Fill Handle, or the Fill Series command. Again, just launch Excel and follow me, so you can practice and improve your skill.

Moving around an Excel spreadsheet and selecting a range of cells may seem pretty straightforward. However, just like always, there are some bits of knowledge that could make you very productive, if you know them. In this lesson we take a look at some Excel tips and tricks for moving around and selecting your data. Please, launch the “Moving and Selecting.xlsx” workbook in order to follow me and to practice your skills.

Excel’s split-screen and freeze-panes features are amazingly useful when you work with large spreadsheets. We take a look at these options here. Please open the “Split and Freeze.xlsx” workbook file and do what I do in this lesson.

In this lesson we begin to explore formulas in Excel. An Excel formula begins with an = (equal sign) and can include things like parenthesis, constants and cell references. As far as operators are concerned, Excel can accept:
^ (Caret) for power
* (Asterisk) for multiplication
/ (Slash) for division
+ (Plus) for addition
- (Minus) for subtraction

Just create a new workbook in order to follow me in this lesson.

This lecture explores Excel functions. Which are pre-built formulas that you can use as components of your calculations. Please, open the “Formulas and Functions.xlsx” workbook in order to be able to easily follow this lesson.

AutoSum is probably the most common and widely-used Excel tool. In this lesson we explore this tool and some of its hidden features. Please open the “AutoSum.xlsx” workbook for this lesson.

To begin with cell references, let’s take a look at Relative and Absolute first. In this lecture we talk about the difference between A1 and $A$1, and why it is important to be familiar with it. Please open the “Realtive vs Absolute.xlsx” workbook before you begin to enjoy this lesson.

This is a lesson on mixed cell references. Why would we need something like $A1 and A$1. Everything will be clear after you internalize this lesson. Please use the “Relative vs Absolute.xlsx” workbook file for this lesson.

Text functions are often used to manipulate data in Excel. If you become comfortable using them, you can increase your productivity exponentially. Please, use the “Text Functions.xlsx” workbook file for this tutorial lesson.

Concatenation is an operation of combining text strings in Excel. Let’s say you have values in separate cells, and you want them all combined in one cell. Perhaps, you also want to add something else to the result. That is when concatenation is very important to be comfortable with. In this lesson you learn how to do it in Excel. Please open the “Concatenate.xlsx” workbook before we begin to learn.

Text-to-Columns is one of the oldest Excel features. It is important for separating text strings: when something is in one cell and you want to be able to separate it into several different cells. You will learn all about it in this lecture. Please, open the “Text-to-Columns.xlsx” workbook for this lesson.

This is a useful practical exercise. In a spreadsheet with a large list of data, it is often necessary to fill blank cells with the value in a cell above. One example is when you receive data from a database reporting system and it does not repeat labels, but instead has blanks to make it easier for humans to read. Excel makes it a very easy problem to fix. You just need to follow certain steps. If none of this makes sense, it will as soon as you go through this lesson. Please open the “Filling Blanks.xlsx” workbook and let’s get started.

In this lesson we begin to explore various options that you want to be aware of when setting your spreadsheets for printing. The tools and commands are spread around the Excel’s user interface and, sometimes, they are not easy to find. Of course, they can not hide for ever. Let’s hunt them down. Please open the “Printing.xlsx” first and then enjoy the lesson.

In this lecture we take a look at how to make sure that titles at the top and at left of your data set are printed on every page. It is easy, but not so obvious how to do it. Let’s learn! The workbook “Printing.xlsx” is still open, isn’t it?

Header and Footer are the things that are printed on every page of your printout. The header is at the top, the footer is at the bottom. There are a few ways to work with them. Let us learn these way in this lesson. We keep using the “Printing.xlsx” workbook in this lesson.

It happens very often that we do not want to print the whole spreadsheet, but rather a specific range of cells, or several such ranges. In this lesson you will learn how to print only specific ranges from your worksheets. There are a few options that we explore: printing a selected range of cells, setting print area, clearing print area. We still keep using the “Printing.xlsx” workbook in this lesson.

This lesson touches upon some additional Excel printing options, such as printing gridlines and headings. They are not common to use, but still important to know about, in case you need them. Again, the “Printing.xlsx” workbook is used in this lesson.

In this lecture we learn about number formatting and about why sometimes Excel behaves the way it does, when you type a number and get something else, or type a date and get a number. Please open the “Formatting.xlsx” workbook and use it in this lesson.

In this lesson we explore date formats in Excel. A date is basically a specific number that has been formatted in a very special way. Use the “Formatting.xlsx” workbook in this lesson.

Let us play with various number formats so that this task becomes easy, effortless, and enjoyable when you work on your Excel worksheets. Please, kindly, open the “Custom Numbers.xlsx” workbook before you enjoy this lesson.

The format painter or the so-called paint brush is such an incredibly easy tool to use that one wonders, what is there to learn? There some exciting possibilities that we explore in this lesson. Open the “PaintBrush.xlsx” workbook and enjoy!

The most important and fundamental concept to understand about Excel charts is that of a data series. In this lesson we explore this concept and create our first chart in Excel. We also get to understand the anatomy of a chart object. Please, open the “Data Series.xlsx” workbook before we get started.

In this lesson we continue exploring Excel charts and create one that is plotting multiple data series. We also investigate what Quick Layouts and Chart Styles have to offer and take a look at various chart elements. Please open the “Chart Elements.xlsx” workbook file.

In this lesson we continue expanding our mind about Excel charts and look at various ways to control the plotted data series. After this lesson you will be able to completely control the data that goes into your charts. Please use the workbook named “Charting Specific Data Ranges.xlsx” for this lesson.

Combination charts are the ones that have different chart types on the same chart object. For example, you may need to present one data series as a column chart and another one as a line chart on the same screen. Get ready to learn how to do it in this lesson. It is actually very easy. Please, open the “Combination Charts.xlsx” workbook.

This lesson gives you a practical exercise creating a combination chart with two series of data that are off different scales. One data series has large numbers, the other one - small. How can we present something like that on the same chart? It is easy! Or, rather, it will be after this lesson. We continue using the “Combination Charts.xlsx” workbook in this lesson.

Excel table is an excellent tool for managing lists of data. It is a special-purpose object superimposed on a data set that makes many things easier to handle, for example sorting, filtering, or formatting. In a way it is like a special type of a named range that allows you to treat a set of data as a single entity. In this lesson we discuss what is an Excel Table, why you would you need one, and what are the benefits. We will look at ways to create an Excel table and on some of the options and tools that it has to offer. Please, use the “Excel Table.xlsx” workbook file for this lesson.

Formatting Excel tables is very easy. Let’s learn how to do it in this lesson. Please, continue using the “Excel Table.xlsx” workbook that you started playing with in the previous lesson.

Excel tables are useful on several levels. Here we continue playing with them and also learn about filtering and sorting data in an Excel table. Again, please, continue using the “Excel Table.xlsx” workbook that you were playing with in the previous lessons.