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.8 (10 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,370 students enrolled
$35
Take This Course
  • Lectures 37
  • Contents Video: 3.5 hours
    Other: 1 min
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2015 English

Course Description

  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.

What are the requirements?

  • Excel Mac version available on your computer

What am I going to get from this course?

  • Learn to use Excel on Mac.
  • Quickly develop skills in Excel.
  • Become more efficient and effective at work.

What is the target audience?

  • New Excel users on Mac OSX platform
  • Beginners who want to quickly gain skills and get to the next level

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome
Welcome!
Preview
01:46
Navigating Udemy Interface
Preview
05:57
Example Files
Article
Section 2: Overview of Excel Basics
05:36

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.

02:54

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.

07:51
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.
06:21

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.

04:20

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.

04:54

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.

Section 3: Performing Calculations in Excel
05:23

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.

09:16

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.

07:07

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.

Section 4: Cell References in Excel
08:48

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.

06:29

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.

Section 5: Working With Text and Text Functions
05:25

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.

08:25

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.

10:15

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.

08:25

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.

Section 6: Printing Excel Spreadsheets
07:16

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.

05:47

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?

05:24

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.

03:55

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.

03:28

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.

Section 7: Formatting Excel Spreadsheets
05:08

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.

05:54

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.

11:32

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.

03:29

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!

Section 8: Presenting Data With Excel Charts
06:58

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.

03:56

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.

07:12

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.

02:48

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.

08:17

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.

Section 9: Working With Excel Tables
06:48

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.

06:14

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.

05:17

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.

Section 10: Wrapping Up The Course
Thank you!
00:34
Bonus Lecture: Special Offers
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Learn It Your Way!

I love creating on-line courses. It has been my favorite pastime since 2013. I love the independent nature of this activity. There is so much to learn!

Independence is what I value most. I am an independent instructor – a free-lance instructor. My on-line courses are not the only thing that I do. I also teach in a classroom setting. My corporate clients hire me to conduct training for their employees. It is my main job: classroom and face-to-face training – as a free-lance of course. I have been in the training business for over 10 years.

I live in San Francisco and, naturally, most of my clients come from the Silicon Valley and from the Bay Area but not only from here. My corporate clients often ask me to travel to conduct training for them.

I have done training for many organizations for over 10 years. Among the more prominent are: 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. There are too many to list all of them here.

I am also a faculty of the American Management Association and conduct many of their training seminars – both public and private, or on-site. When I am not creating my on-line courses, I teach for one of these, or other fine companies.

I teach a broad range of topics. Such as Software, Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. I do hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

Ready to start learning?
Take This Course