Ultimate Excel Shortcut Guide Become a Power User in Days!

Course Curriculum

Chapter 1: Welcome

Lecture 1: Important – Download These First – Working Files

Lecture 2: 0101 Introduction

Lecture 3: 0102 Using The Working Files

Chapter 2: The Simple Ones Are The Best Ones

Lecture 1: 0201 How To Enter Numbers And Retain The Leading Zero

Lecture 2: 0202 Using The Fill Handle For Quick Data Patterns

Lecture 3: 0203 Controlling Pages On Printing

Lecture 4: 0204 Adding Hyperlinks To Excel Objects

Lecture 5: 0205 Recommended Pivot Tables

Lecture 6: 0206 Recommended And Quick Creation Charts

Lecture 7: 0207 Ctrl Keyboard Shortcuts

Chapter 3: Excel Interface Shortcuts

Lecture 1: 0301 Accessing Ribbon Commands With The Keyboard

Lecture 2: 0302 Customize The Ribbons And Quick Access Toolbar

Lecture 3: 0303 Activating And Deactivating Interface Options

Chapter 4: Workbooks And Worksheets

Lecture 1: 0401 Moving Swiftly Between Workbooks And Worksheets

Lecture 2: 0402 Displaying File Path, File Name And Sheet Name

Lecture 3: 0403 Controlling The Quantity Of Worksheets

Chapter 5: Data Organization

Lecture 1: 0501 Creating A Table

Lecture 2: 0502 Table Styles Of Your Own

Lecture 3: 0503 Creating And Using Custom Views

Lecture 4: 0504 Testing What Ifs With Goal Seek

Lecture 5: 0505 Use Scenarios To Experiment With Different Values

Chapter 6: Entering Data And Formatting

Lecture 1: 0601 Managing Cells With Large Text Content

Lecture 2: 0602 Creating And Managing A Pick List

Lecture 3: 0603 Multiple Sheet Data Entry And Sheet Management

Chapter 7: Working With Dates And Times

Lecture 1: 0701 Inserting The Date And Time As Static Or Dynamic

Lecture 2: 0702 Time Difference And Duration: Particularly Over 24 Hours

Lecture 3: 0703 Calculate Time Required To Reach Investment Goal

Chapter 8: Working With Data And Formulas

Lecture 1: 0801 Create Your Own Fill Handle Lists

Lecture 2: 0802 Flash Fill In Action – Completing Data Columns

Lecture 3: 0803 Removing Duplicate Values

Lecture 4: 0804 Work Out Mortgage Repayments

Lecture 5: 0805 Adding Comments To Formulas

Lecture 6: 0806 Displaying The Formula In Use: Formula Text

Lecture 7: 0807 Use Watch To Keep An Eye On A Cell Value

Lecture 8: 0808 Adding Formulas To Text Boxes

Chapter 9: Charts And Pivot Tables

Lecture 1: 0901 Create A Chart With A Single Key

Lecture 2: 0902 Summarizing Data Using A Sparkline

Lecture 3: 0903 Reference A Pivot Table Value In A Formula

Lecture 4: 0904 Separate Worksheets From A Single Pivot Table

Lecture 5: 0905 Drilling Down Into Pivot Table Data

Chapter 10: Conclusion

Lecture 1: 1001 Shortcut Summary