Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel 2016 for the Macintosh Professional

Video Introducing this tutorial

Introduction
Excel 2016 for the Macintosh Professional: Introduction


Lesson 1: Learning Excel Basics
Learning objectives
1.1 Open a spreadsheet and enter data
1.2 Get around Excel
1.3 Use the ribbon
1.4 Format numbers in cells
1.5 Use data entry shortcuts (Autocomplete, AutoFill, Fill Handle)
1.6 Select cells and ranges
1.7 Move data around your spreadsheet
1.8 Insert, delete, and clear cells
1.9 Find and replace data
1.1O Use worksheets and workbooks
1.11 Use Excel templates


Lesson 2: Building Formulas
Learning objectives
2.1 Reference cells and ranges of cells
2.2 Reference cells in other worksheets and workbooks
2.3 Build simple formulas
2.4 Understand absolute and relative references
2.5 Use named cells
2.6 Use built-in functions
2.7 Use the Goal Seek tool
2.8 Solve errors


Lesson 3: Using Excel as a Database
Learning objectives
3.1 Make lists with Excel
3.2 Build a data table
3.3 Format data tables
3.4 Sort and filter data
3.5 Calculate with data tables
3.6 Build a pivot table


Lesson 4: Introducing Macros and Visual Basic
Learning objectives
4.1 Record and run macros
4.2 Edit macros
4.3 Explore Visual Basic


Lesson 5: Formatting Data and Charts
Learning objectives
5.1 Format worksheets
5.2 Outline in worksheets
5.3 Understand conditional formatting
5.4 Build charts
5.5 Add Sparklines: small, intense, simple data words


Lesson 6: Printing Excel Spreadsheets
Learning objectives
6.1 Preview worksheets before printing
6.2 Adjust worksheets to fit the page
6.3 Print headings
6.4 Print single and multiple worksheets


Lesson 7: Sharing Spreadsheets
Learning objectives
7.1 Import data from other sources
7.2 Export Excel spreadsheet data
7.3 Add and delete comments
7.4 Track changes
7.5 Accept and reject changes
7.6 Protect spreadsheet data


Summary
Excel 2016 for the Macintosh Professional: Summary