Master Excel on Apple Mac and Succeed at Your Workplace
4.4 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,390 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Excel on Apple Mac and Succeed at Your Workplace to your Wishlist.

Add to Wishlist

Master Excel on Apple Mac and Succeed at Your Workplace

Master Excel 2011 and Excel 2016 for Apple Mac. Easy-to-follow tutorial to develop skills for success.
4.4 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,390 students enrolled
Last updated 4/2016
Current price: $10 Original price: $65 Discount: 85% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn to use Excel on Mac.
Quickly develop skills in Excel.
Become more efficient and effective at work.
View Curriculum
  • Excel Mac version available on your computer
  1. The best course to quickly learn Excel 2011 and Excel 2016.
  2. A step-by-step tutorial to become efficient and productive in Excel.
  3. A course to help you quickly transition from Excel 2011 to Excel 2016.

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.

Who is the target audience?
  • New Excel users on Mac OSX platform
  • Beginners who want to quickly gain skills and get to the next level
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 37 Lectures Collapse All 37 Lectures 03:30:03
3 Lectures 07:51
Overview of Excel Basics
6 Lectures 31:56

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.

Preview 05:36

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.

Preview 02:54

In this lesson we cover some data entry techniques when working in Excel. Even though data entry is not particularly complex, there are little things that make you life easier. There is no exercise workbook to open, just make sure that Excel is launched.
Entering Data in Excel

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.

Using the Fill Handle - Fill Series Command

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.

Moving and Selecting in Excel

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.

Split Screen and Freeze Panes
Performing Calculations in Excel
3 Lectures 21:46

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.

Preview 05:23

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.

Excel Functions

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.

Preview 07:07
Cell References in Excel
2 Lectures 15:17

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.

Relative and Absolute Cell References

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.

Mixed Cell References
Working With Text and Text Functions
4 Lectures 32:30

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.

Cleaning Data - Using Text Functions

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.

Concatenation - Combining Text Strings

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.

Using Text-to-Columns

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.

Filling Blank Cells With Repeating Labels in an Outline Report
Printing Excel Spreadsheets
5 Lectures 25:50

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.

Printing Spreadsheets

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?

Repeat Titles When Printing

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.

Header and Footer

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.

Printing Specific Ranges, Set Print Area, Clear Print Area

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.

Printing Spreadsheet Gridlines and Headings
Formatting Excel Spreadsheets
4 Lectures 26:03

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.

Number Formatting - General Format

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.

Date Format

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.

Custom Number Formatting

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!

Format Painter
Presenting Data With Excel Charts
5 Lectures 29:11

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.

Excel Charts and Data Series

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.

Charts With Multiple Data Series, Quick Layouts, Chart Styles

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.

Working With Data Series in Excel Charts

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.

Combination Charts in Excel

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.

Combination Charts With Off-Scale Data Series
Working With Excel Tables
3 Lectures 18:19

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.

Creating and Modifying Excel Tables

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.

Formatting Excel Tables

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.

Sorting and Filtering Excel Tables
Wrapping Up The Course
2 Lectures 01:23
Thank you!

Bonus Lecture: Special Offers
About the Instructor
Igor Ovchinnikov
4.6 Average rating
259 Reviews
4,948 Students
10 Courses
Helping you learn fast, so you can do your job well.

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.