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.

  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.

Welcome!
Navigating Udemy Interface
Example Files
Excel 2011 User Interface
Excel 2016 User Interface
Entering Data in Excel
Using the Fill Handle - Fill Series Command
Moving and Selecting in Excel
Split Screen and Freeze Panes
Excel Formulas
Excel Functions
Using AutoSum In Excel
Relative and Absolute Cell References
Mixed Cell References
Cleaning Data - Using Text Functions
Concatenation - Combining Text Strings
Using Text-to-Columns
Filling Blank Cells With Repeating Labels in an Outline Report
Printing Spreadsheets
Repeat Titles When Printing
Header and Footer
Printing Specific Ranges, Set Print Area, Clear Print Area
Printing Spreadsheet Gridlines and Headings
Number Formatting - General Format
Date Format
Custom Number Formatting
Format Painter
Excel Charts and Data Series
Charts With Multiple Data Series, Quick Layouts, Chart Styles
Working With Data Series in Excel Charts
Combination Charts in Excel
Combination Charts With Off-Scale Data Series
Creating and Modifying Excel Tables
Formatting Excel Tables
Sorting and Filtering Excel Tables

What's included

  • 35 Video Lessons
  • 1 Text Lesson

  • Works on all devices
  • Certificate of completion

Igor Ovchinnikov

Instructor