This course was originally prepared for one of my large corporate clients to train about 1000 of their employees who needed to quickly learn and get up to speed on the most common and important tasks done in Excel on Mac.
If you are like those 1000 people, and do have to use Excel at work, you have no time to waste. You want to quickly become effective and efficient in your Excel tasks. In this tutorial course you will be able to quickly understand and gain skills in Microsoft Excel on Mac. You will quickly, step by step, gain confidence in using Microsoft Excel.
The topics in this course were carefully hand-picked to develop quick understanding of the most important Excel concepts.
This course begins with Excel 2011 and then gradually transitions to Excel 2016, as soon as it is officially released.
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.
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.
Hi, I am Igor Ovchinnikov.
Welcome to my profile page. This is where you normally get to learn about me and read something like this:
“Igor Ovchinnikov is a corporate trainer with over 10 years of experience. He lives in San Francisco and provides excellent training-delivery services to clients all over the Bay Area. He has delivered training for Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others.
Mr. Ovchinnikov holds an MBA from the Ohio State University.”
Well, frankly, I always have some serious cognitive dissonance whenever I have to write about myself in the third person like this. It’s a bit silly - don’t you agree? So, enough of this out-of-body talk!
First of all, you probably don’t care about me that much. Second, you are probably more interested in why you should buy my courses and what’s in them for you? You may be more interested in how my teaching is different compared to the other great instructors out there?
I have to confess, it is something I've been wondering about too. You know, when someone asks you what you are good at, it’s tough to answer that. Especially, because when you are really good at something, you don’t really perceive it as a big deal. Don’t you agree? Think of something you do really well. Now, do you really work hard on it, or does it come kind of naturally?
So, to answer this question to myself, I recently decided to ask my students. Most of the ones I polled are employees of just one organization where I teach - Stanford University, so the research sample may not be fully scientific. Anyway, I asked a few dozens of my students what they liked best about my teaching style. It was really surprising, that most of them told me that their favorite part was how clear things became after I explained it to them. One of them said literally: “You are a great explainer. It was so confusing before, and now I finally understand it!”
I think, here’s what I can promise you when you enroll in my courses. I promise you clear explanations, so that things will be no longer confusing.
So, here’s my value proposition to you:
When you enroll in my courses and go through the material, you should expect clear explanations that will help you learn and build your skills fast, so you can succeed at your job.
If that is the experience that you are interested in, simply enroll in my courses below.