Books & Videos

Table of Contents

Chapter: Getting Started

How Time Saving Are These Excel Projects?

07m 49s

Making Use Of The Project Working Files

01m 51s

About The Author

01m 39s

An Introduction To Math In Excel

09m 30s

Chapter: Recording And Monitoring Sales Data

Creating A New Excel File To Record Data

05m 33s

Saving Your Workbook In The Correct Format

02m 23s

Improve Your Worksheet With Some Formatting

03m 46s

Adding Formulas To Total Rows And Columns

05m 19s

Adding Formulas The Quick Way

02m 13s

Working Out Our Average Consumption

03m 40s

Conditional Formatting To Improve Presentation

04m 3s

Renaming Sheets And Printing

05m 26s

Chapter: Using Excel For A Profit And Loss

Creating The Data Collection Sheet

03m 27s

Setting Up A List Using A Named Range

06m 0s

Adding Formula To Create January Profit And Loss

09m 13s

Changing The Data Entry To A Single Sheet

08m 10s

Creating The Other Eleven Months - Chapter 3

05m 15s

Using 3D Referencing To Generate The Whole Years Profit And Loss

07m 29s

Exporting To PDF And Emailing To The Accountant

02m 31s

Chapter: Score Sheets For School Sports Day

Setting Up The Scoresheet Structure

06m 49s

Looking Up The Competitor Name

07m 51s

A Near Match Lookup For The Event Scores

06m 30s

Using Sheet Replication To Create The Other Event Sheets

09m 12s

Adding Protection To Protect Your Formula

08m 22s

Data Entering The Actual Results

02m 28s

Completing The Competitor Summary

09m 5s

Creating An Error Check For Events Competed

04m 11s

Adding Up The Scores And Ranking For Position

04m 26s

Chapter: Expenses Claim Form

Expenses Claim Document Setup And Header Page

05m 54s

Adding The First Month

04m 31s

Displaying The Month Name Instead Of The Number

03m 3s

Creating Destination Lookups For January

11m 22s

Protecting January And Setting Print Options

04m 26s

Creating The Other Eleven Months - Chapter 5

06m 10s

Adding A Summary Sheet

05m 20s

Using And Submitting Your Expenses Claim

03m 2s

Chapter: Sales Contacts Management

Setting Up Excel To Store Data And Entering That Data

06m 17s

Creating A Unique ID And Freezing Titles

06m 38s

Calculating New Values Using String Manipulation

07m 41s

Sorting Your Excel Database

05m 18s

Filtering Your Dataset

05m 55s

Removing Duplicate Records From Your Dataset

03m 3s

Mail Merge Using Your Dataset

07m 28s

Form View In Excel

06m 5s

Summarizing The Dataset With Pie Charts

11m 28s

Chapter: Stock Sales Summaries

Starting The Sales Data Record Sheet

06m 8s

Adding A Sales Chart To The Data

06m 19s

Replicate Sheets To Create Other Sales Regions

03m 49s

Summarizing The Sales Data

11m 9s

Importing CSV Format Sales Data

04m 17s

Adding Some Calculations To The Imported Data

01m 53s

Interrogating The Sales Data With A Pivot Table

09m 32s

Formatting The Pivot Table

05m 56s

Sorting And Filtering The Pivot Table

05m 57s

Chapter: Next Steps

Reviewing Absolute And Relative Formulas

09m 30s

What Is The SkyDrive?

05m 46s

Saving An Excel File To SkyDrive

03m 39s

Informing Others That The SkyDrive Document Is There

02m 18s

Excel 2011 Summary

01m 52s

What Is Next?

04m 49s