Books & Videos

Table of Contents

Chapter: Your Excel 2016 Journey Starts Here

Quick Introduction To The New Excel 2016 Interface

03m 16s

Do I Need A Microsoft Account?

02m 39s

About Your Author

01m 35s

Using The Included Working Files

02m 15s

How To Access Your Working Files

01m 15s

Chapter: Managing Excel Workbooks And Worksheets

Creating And Saving A New Workbook

05m 26s

Opening And Closing Workbooks

05m 0s

Saving And Opening Excel Files To And From OneDrive And iCloud

04m 1s

Saving Excel Files In Other Formats

05m 33s

Adding, Deleting, Moving, And Copying Worksheets

07m 16s

Using The Excel 2016 Templates

06m 53s

Chapter: Entering And Editing Data In Cells

Entering Text, Numbers, And Dates

07m 51s

Editing The Contents Of Cells

05m 39s

Undo And Redo Your Actions

04m 1s

Cut, Copy, And Paste

07m 3s

Drag And Dropping Cells

04m 3s

The Fill Handle

08m 33s

Inserting And Deleting Rows And Columns

06m 21s

Changing Column Widths And Row Heights

05m 16s

Hiding And Unhiding Rows, Columns And Sheets

05m 33s

Searching For Values In A Workbook

05m 24s

Chapter: Math Basics

Getting Started With Basic Mathematical Operators

05m 18s

Order Of Operation With BODMAS

04m 6s

Introduction To Basic Formula

06m 52s

The New Formula Builder And Quick SUMs

07m 20s

Copying Formula And Functions

07m 3s

Displaying Formulae On A Worksheet

05m 22s

Chapter: Formatting Worksheets

Selecting Cells For Formatting

05m 17s

Modifying Typeface, Font Size And Colors

06m 26s

Cell Alignment, Orientation And Merging

05m 11s

Using Number Formats

05m 46s

Adding And Removing Borders

05m 27s

Applying Date Formats To Cells

07m 20s

Format Painter And Fill Formatting

05m 28s

Clearing Cell Contents And Formatting

03m 35s

Chapter: Page Setup And Printing

Paper Size, Margins, Orientation And Scaling

05m 39s

Using A Print Area And Printing Titles

05m 34s

Using The Page Break Tools

04m 15s

Creating Headers And Footers - Method 1

05m 17s

Creating Headers And Footers - Method 2

05m 45s

Other Print Options And Checking Spelling

06m 5s

Generating A PDF From A Worksheet

03m 47s

Chapter: Mathematical Formulas

The SUM Function

04m 30s

Other Mathematical Functions - AVERAGE, MIN And MAX

07m 9s

Useful Count Functions

05m 27s

Averages, Mean, Mode, And Median

07m 46s

Using PI In Formula

05m 12s

Absolute Referencing Explained

06m 42s

Formulas Across Worksheets

05m 38s

3D Referencing

06m 42s

Making Use Of Named Ranges

06m 47s

Dates, Shapes, And Formula

07m 45s

IF Statements

05m 56s

Chapter: Advanced Formatting

Adding, Editing, Deleting, And Printing Comments

05m 53s

Creating Your Own Custom List

03m 28s

Converting To A Table For Formatting

04m 22s

Chapter: Security

Activate And Deactivate Worksheet And Workbook Protection

04m 35s

Protecting Part Of A Worksheet To Aid Data Entry

02m 59s

Password Protecting The Workbook File

04m 5s

Chapter: Excel 2016 Summary

What You Have Learned

05m 4s