Books & Videos

Table of Contents

Chapter: Welcome

Introduction

03m 24s

Using The Working Files

02m 10s

About The Author

01m 18s

Chapter: The Simple Ones Are The Best Ones

How To Enter Numbers And Retain The Leading Zero

04m 17s

Using The Fill Handle For Quick Data Patterns

06m 29s

Controlling Pages On Printing

05m 54s

Adding Hyperlinks To Excel Objects

04m 34s

Recommended Pivot Tables

04m 42s

Recommended And Quick Creation Charts

04m 23s

Ctrl Keyboard Shortcuts

09m 46s

Chapter: Excel Interface Shortcuts

Accessing Ribbon Commands With The Keyboard

04m 59s

Customize The Ribbons And Quick Access Toolbar

07m 12s

Activating And Deactivating Interface Options

05m 24s

Chapter: Workbooks And Worksheets

Moving Swiftly Between Workbooks And Worksheets

04m 32s

Displaying File Path, File Name And Sheet Name

05m 19s

Controlling The Quantity Of Worksheets

03m 30s

Chapter: Data Organization

Creating A Table

03m 17s

Table Styles Of Your Own

04m 45s

Creating And Using Custom Views

05m 22s

Testing What Ifs With Goal Seek

05m 18s

Use Scenarios To Experiment With Different Values

05m 54s

Chapter: Entering Data And Formatting

Managing Cells With Large Text Content

05m 20s

Creating And Managing A Pick List

04m 46s

Multiple Sheet Data Entry And Sheet Management

05m 4s

Chapter: Working With Dates And Times

Inserting The Date And Time As Static Or Dynamic

04m 13s

Time Difference And Duration: Particularly Over 24 Hours

06m 46s

Calculate Time Required To Reach Investment Goal

04m 9s

Chapter: Working With Data And Formulas

Create Your Own Fill Handle Lists

06m 56s

Flash Fill In Action - Completing Data Columns

04m 50s

Removing Duplicate Values

03m 35s

Work Out Mortgage Repayments

05m 55s

Adding Comments To Formulas

03m 40s

Displaying The Formula In Use: Formula Text

03m 59s

Use Watch To Keep An Eye On A Cell Value

04m 46s

Adding Formulas To Text Boxes

04m 25s

Chapter: Charts And Pivot Tables

Create A Chart With A Single Key

04m 49s

Summarizing Data Using A Sparkline

06m 32s

Reference A Pivot Table Value In A Formula

04m 48s

Separate Worksheets From A Single Pivot Table

03m 59s

Drilling Down Into Pivot Table Data

04m 26s

Chapter: Conclusion

Shortcut Summary

03m 8s