Books & Videos

Table of Contents

Chapter: Introduction

Is This Cookbook For You?

04m 59s

About Your Chef

01m 29s

How Big Is My Excel Oven?

04m 43s

The Included Working Files

02m 35s

How To Access Your Working Files

01m 15s

Chapter: Dealing With Time

Welcome To Excel - Date And Time

07m 57s

Formatting A Date

10m 23s

Converting Dates From Imported Data

05m 38s

Figuring Out Monthly Sales

08m 6s

Building A Timesheet Calculator

08m 29s

Working Out How Old Your Staff Are

07m 56s

Calculating Dates Using Functions

08m 23s

Prevent Negative Time From Displaying As Hashes

07m 20s

Highlighting Dates In The Current Week Or Month

06m 52s

Forcing The User To Input The Correct Time Format

06m 14s

What Will The Date Be This Friday?

04m 34s

Chapter: Speeding Up Excel

Reasons And Solution For Slow Excel Files

05m 21s

Exploring File Reduction Methods

05m 34s

Ever Tried XLSB?

02m 14s

Using Keyboard Shortcuts

04m 11s

Creating Macros To Speed Up Repeated Formatting

06m 20s

Chapter: Errors In Functions

Exploring Common Error Codes

07m 0s

Troubleshoot And Hide Error Messages

08m 24s

Errortype Function For Handling Errors

05m 59s

Chapter: VLOOKUP Speciality Cake

The Basics

07m 24s

Perfoming A Two Column Lookup

08m 5s

Dealing With #N/A

04m 25s

When #N/A Is Not Really #N/A

06m 38s

Can We Lookup To The Left

06m 1s

Chapter: Powerful Pivot Pie

Data Summaries In A Jiffy

07m 46s

Formatting, Labelling, And Sorting

06m 34s

Filtering The Data

07m 9s

Using The Recommended Pivots

04m 57s

Adding A Pivot Chart

07m 20s

Calculating Mean, Mode, And Median In Pivot Tables

10m 9s

Chapter: Data Loaf

Summing Only The Filtered Results

05m 48s

Physically Changing Numbers Including Adding Leading Zeros

07m 36s

Creating An Auto-List Of Your Own Departments

04m 23s

Splitting A Cell By Text And Number

08m 24s

Filter Unique Values From Your Data List

05m 24s

Dragging Rows Or Columns To Change The Order Of Items

04m 56s

Creating A Comma-Separated List From A Column Of Data

04m 50s

Sorting Data By Row Values Instead Of Columns

03m 53s

Autonumbering For Record Rows

02m 58s

Filtering Rows By Color Rather Than By Value

03m 20s

Chapter: Layout Tart

Creating Your Own Ribbon Tab

07m 42s

Splitting And Freezing Views To Help Navigate Large Sheets

05m 53s

Comparing Two Workbooks Using Synchronous Scrolling

04m 18s

How To Ctrl- Or Alt-Tab Between Worksheets

03m 58s

Merging Across Multiple Columns

03m 29s

Color One Cell Based On The Value Of Another

03m 59s

Chapter: Mathematical Melange

Use An Array Formula To Build Multiple Cell Values

04m 29s

How To Reverse A Cells Contents

05m 30s

Creating A Squared Symbol Within A Formula

03m 9s

Count Values Based On Multiple Criteria

05m 0s

Find Missing Numbers From A Sequence

05m 17s

Chapter: Quick Quiches

Force A Carriage Return Within A Cell

03m 24s

Column Row Insertion Deletion And Hiding With The Keyboard Only

05m 14s

Use A Formula To Calculate The Day Of The Week As A Name

05m 0s

Searching For The Special Question Mark And Asterisk Characters In Excel

04m 25s

One Command To Create A Chart

02m 56s

Display The Current Sheetname On The Sheet

04m 53s

Display A Yes-No Dialog Box When Running Macros

07m 46s

Creating A Hyperlink

05m 8s

Make Cell References Absolute Very Quickly

02m 43s

Chapter: Spicy Charts

Graphing With Two Y Axes

04m 16s

Displaying A Set Of Smaller Values In A Separate Pie

05m 51s

Keeping A Continuous Line Even With Data Missing

03m 24s

Fill In Missing Date Labels On A Chart

03m 54s

Chapter: Other Clever Titbits

Saving As A CSV Without Warnings

07m 42s

Create A Random Text String

08m 32s

Chapter: The End

Good Luck

05m 28s