Lynda - Excel for Mac 2016 Essential Training
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.
Table of Contents
Introduction1. Getting Started with Excel2. Managing Workbooks3. Working with Worksheets, Cells, and Cell Data4. Sorting, Filtering, and Managing Worksheets5. Summarizing Data Using Formulas and Functions6. Analyzing Data and Formulas7. Formatting Worksheet Elements8. Working with Charts9. Working with External Data10. Working with Objects11. Exploring PivotTables12. Reviewing and Sharing Your Spreadsheets13. Automating Workbooks Using MacrosConclusion