Excel for Mac 2011 Essential Training

with Curt Frye
please wait ...
Excel for Mac 2011 Essential Training
Video duration: 0s 6h 32m Beginner

Viewers:

In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.

Topics include:
  • Customizing the Ribbon
  • Formatting worksheets, cells, and cell data
  • Sorting and filtering data
  • Working with formulas
  • Detecting formula errors
  • Creating charts
  • Importing data
  • Inserting objects and graphics
  • Using PivotTables
  • Recording macros
  • Sharing workbooks
Subject:
Business
Software:
Excel for Mac
Author:

Welcome

Hi! I'm Curt Frye. Welcome to Excel 2011 for Mac Essential Training. In this course, I'll teach you all the skills you need to use Excel 2011 effectively, whether you're an experienced user upgrading from an earlier version, or someone who's new to Excel. I'll start by showing you how to run Excel, how to navigate the program's user interface, and how to get help within the program, or online. Then I'll teach you how to manage your workbooks and the data they contain, such as by entering data quickly, adding and deleting worksheets, and by sorting and filtering your data, so you can focus on just the information you need to make a decision.

The next part of the course covers formulas and formatting. And I'll show you how to summarize your data using formulas that range from the simple to the not-so-simple, and how to make your headings and data stand out. In the last part of the course, I'll teach you some slightly more advanced techniques that will let you summarize your data visually using charts, work with external data, manage images and shapes, and even automate routine tasks using macros. In short, I'll show you everything you need to know so you can use Excel 2011 effectively. Thanks again for watching Excel 2011 for Mac Essential Training.

Your time with this course will be time well spent.

Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training .


Expand all | Collapse all
please wait ...
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
please wait ...