Excel for Mac 2016 Essential Training

Heads up! This course may be archived and/or unavailable.

Learn everything you need to master the Mac 2016 version of the world's most popular spreadsheet program. Curt Frye provides a comprehensive overview of Excel for Mac 2016, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.

Contents:

• Introduction
• 1. Getting Started with Excel
• 2. Managing Workbooks
• 3. Working with Worksheets, Cells, and Cell Data
• 4. Sorting, Filtering, and Managing Worksheets
• 5. Summarizing Data Using Formulas and Functions
• 6. Analyzing Data and Formulas
• 7. Formatting Worksheet Elements
• 8. Working with Charts
• 9. Working with External Data
• 10. Working with Objects
• 11. Exploring PivotTables
• 12. Reviewing and Sharing Your Spreadsheets
• 13. Automating Workbooks Using Macros
• Conclusion