Books & Videos

Table of Contents

Chapter: Introduction

Excel 2016 for the Macintosh Professional: Introduction

02m 23s

Chapter: Lesson 1: Learning Excel Basics

Learning objectives

01m 52s

1.1 Open a spreadsheet and enter data

05m 33s

1.2 Get around Excel

04m 39s

1.3 Use the ribbon

04m 4s

1.4 Format numbers in cells

08m 20s

1.5 Use data entry shortcuts (Autocomplete, AutoFill, Fill Handle)

05m 23s

1.6 Select cells and ranges

02m 59s

1.7 Move data around your spreadsheet

03m 17s

1.8 Insert, delete, and clear cells

06m 5s

1.9 Find and replace data

06m 41s

1.1O Use worksheets and workbooks

04m 55s

1.11 Use Excel templates

05m 55s

Chapter: Lesson 2: Building Formulas

Learning objectives

01m 27s

2.1 Reference cells and ranges of cells

06m 51s

2.2 Reference cells in other worksheets and workbooks

09m 39s

2.3 Build simple formulas

04m 54s

2.4 Understand absolute and relative references

05m 41s

2.5 Use named cells

09m 21s

2.6 Use built-in functions

07m 14s

2.7 Use the Goal Seek tool

04m 21s

2.8 Solve errors

11m 58s

Chapter: Lesson 3: Using Excel as a Database

Learning objectives

00m 44s

3.1 Make lists with Excel

05m 42s

3.2 Build a data table

05m 26s

3.3 Format data tables

02m 21s

3.4 Sort and filter data

06m 32s

3.5 Calculate with data tables

10m 0s

3.6 Build a pivot table

06m 12s

Chapter: Lesson 4: Introducing Macros and Visual Basic

Learning objectives

00m 37s

4.1 Record and run macros

10m 57s

4.2 Edit macros

14m 7s

4.3 Explore Visual Basic

12m 42s

Chapter: Lesson 5: Formatting Data and Charts

Learning objectives

00m 47s

5.1 Format worksheets

10m 23s

5.2 Outline in worksheets

03m 10s

5.3 Understand conditional formatting

04m 31s

5.4 Build charts

06m 28s

5.5 Add Sparklines: small, intense, simple data words

04m 14s

Chapter: Lesson 6: Printing Excel Spreadsheets

Learning objectives

00m 30s

6.1 Preview worksheets before printing

09m 40s

6.2 Adjust worksheets to fit the page

07m 3s

6.3 Print headings

09m 33s

6.4 Print single and multiple worksheets

04m 9s

Chapter: Lesson 7: Sharing Spreadsheets

Learning objectives

00m 48s

7.1 Import data from other sources

11m 42s

7.2 Export Excel spreadsheet data

09m 54s

7.3 Add and delete comments

04m 43s

7.4 Track changes

05m 31s

7.5 Accept and reject changes

03m 5s

7.6 Protect spreadsheet data

04m 35s

Chapter: Summary

Excel 2016 for the Macintosh Professional: Summary

01m 42s