Books & Videos

Table of Contents

Chapter: Getting Started

Overview Of Excel 2010

06m 16s

The New File Menu In Excel 2010

05m 9s

Exploring The Excel Workbook

02m 25s

What Will I Be Able To Do At The End Of This Course

03m 53s

Customizing The Quick Access Toolbar

02m 52s

Working With The Ribbons

03m 46s

Using The Files Included With This Course

00m 33s

Chapter: Working With An Excel Worksheet

Creating A New Workbook

01m 36s

Saving A Workbook

02m 25s

Saving In Other Formats

03m 4s

Open A Existing Workbook

01m 45s

Navigating An Excel Workbook

05m 17s

Chapter: Selecting And Entering Data

Entering Text And Numbers

03m 0s

Entering Numbers As Text

03m 47s

Inputting Dates And Times

04m 3s

Editing The Contents Of A Cell

02m 8s

Using Copy And Paste

06m 47s

The FILL Handle

07m 5s

Using Undo And Redo

03m 3s

Shortcuts For Selecting Cells

05m 12s

Inserting Cells, Columns And Rows

05m 17s

Deleting Cells, Columns And Rows

03m 21s

Changing Column Widths And Row Heights

04m 6s

Hiding And Unhiding A Column Or Row

05m 9s

Searching For Values In A Worksheet

05m 34s

Chapter: Developing A Workbook

Formatting And Naming Of Worksheet Tabs

03m 41s

Moving Worksheets Within And Between Workbooks

04m 49s

Copying Worksheets Within Workbooks

03m 17s

Inserting And Deleting Worksheets

03m 33s

Viewing More Than One Workbook

04m 34s

Hiding And Unhiding Worksheets

02m 2s

Chapter: Printing And Page Setup

Using The Print Area Command To Control What Excel Prints

04m 3s

Setting Page Margins And Page Orientation

03m 29s

Creating A Header And Footer

04m 48s

Using Page Break View

02m 55s

Setting Print Titles For Large Worksheets

03m 1s

Printing Gridlines Column Row Headings And Other Related Options

02m 48s

Enabling The New Page Layout View

03m 30s

Running The Spell Checker

03m 23s

Print Preview And Printing The Whole Or Part Of The Worksheet

04m 3s

Chapter: Workbook Formatting

Modifying Typeface, Font Size And Colors

06m 12s

Merging Cells

02m 45s

Applying Number Formats

04m 4s

Aligning Cell Contents

02m 2s

Changing The Text Direction In A Cell

03m 38s

Adding Borders To Cells And Ranges

04m 43s

Applying A Date Format To A Cell Or Range

05m 15s

Use Of The Format Painter

04m 29s

Clearing Cell Contents And/Or Formatting

02m 50s

Chapter: Carrying Out Calculations

Getting Started With Basic Math Formula Addition

05m 23s

Getting Started With Basic Math Formula Subtraction

03m 20s

Getting Started With Basic Math Formula Multiplication

02m 45s

Getting Started With Basic Math Formula Division

04m 22s

Getting Started With Basic Math Formula Operand

02m 36s

Order Of Operations with BODMAS

03m 14s

Introduction To Excel Formulas: SUM

07m 46s

Copying Formulas And Functions

06m 55s

Displaying Formulae On A Worksheet

02m 59s

Some Useful Functions For Counting

04m 6s

Some Useful Functions For Averages

04m 2s

Some Useful Functions For Highest And Lowest

03m 15s

Absolute Referencing Requirements

05m 37s

Formulas Across Worksheets

07m 46s

Functions Across Worksheets

04m 44s

3D Referencing

06m 58s

Making Use Of Named Cells And Ranges

09m 24s

Chapter: Advanced Formatting

Enhancing Worksheets Using Themes

02m 40s

Working With Comments

04m 45s

Creating Your Own AutoFill List

05m 45s

Turning Your Data Into A Table For Formatting

05m 32s

Chapter: Security

Using Protection On A Worksheet

03m 35s

Protecting Part Of A Worksheet To Facilitate Data Entry

03m 59s

Controlling Access To Cell Ranges By Password And Or User Accounts

05m 17s

Saving A Workbook With Password Protection

03m 46s

Chapter: Using Templates

Creating A Workbook From A Template

03m 35s

Creating Your Own Custom Template

06m 16s

Chapter: Graphics Objects

Inserting And Modifying Clipart

07m 37s

Using SmartArt Graphics

08m 11s

Adding Drawn Shapes To A Worksheet

04m 48s

Inserting An External Picture

03m 1s

Adding A Background Image To A Worksheet

02m 57s

Formatting Graphic Objects

05m 2s

Controlling Stacking Order And Alignment Of Multiple Graphics Objects

06m 15s

Grouping Graphic Objects

03m 29s

Accessing Formula Results In A Callout Bubble

05m 10s

Chapter: Using Excel As A Database

Fixing Rows And Columns On Screen

02m 51s

Fixing Rows And Columns For Print

01m 58s

Sorting Data In A Worksheet

06m 9s

Filtering Data In A Worksheet

07m 29s

Removing Duplicates In An Excel Database

02m 36s

Adding And Using Subtotals In An Excel Database

07m 58s

Splitting One Column Of Data Into More Columns

06m 38s

Splitting The Screen To View Different Parts Of The Same Worksheet

04m 28s

Linking To Data On A Webpage

08m 24s

Chapter: Using Charts In Excel

Creating A Chart The Long Way

05m 0s

Creating A Chart The Quick Way

02m 28s

Changing A Chart From A Sheet Object To A Sheet

02m 57s

Modifying Your Chart Type

06m 30s

Controlling Chart Style And Layout

08m 26s

Adding A Trend line To A Chart

05m 44s

Pie Charts In More Detail

05m 24s

Chapter: More Advanced Formula

Adding An IF Function For Cell Comparisons

06m 29s

Using the IF Function To Suppress Excel Error Messages

07m 36s

Text Manipulation With Formulae - Part 1

08m 16s

Text Manipulation With Formulae - Part 2

03m 47s

Date Formula In Excel

06m 37s

DATEDIF - A Hidden But Useful Formula

04m 28s


12m 35s

Use Of A Formula To Rank Scores

03m 24s

Chapter: Conditional Formatting

Changing Cell Appearance Based On Its Value

05m 34s

Editing Conditional Formatting Rules On A Worksheet

04m 51s

Removing Conditional Formatting Rules

01m 47s

Highlighting Duplicate Values Using Conditional Formatting

03m 35s

Identifying The Top Or Bottom Percentage Of A Range

04m 1s

Use Of Data Bars Within Conditional Formatting

04m 32s

Use Of Colour Scales Within Conditional Formatting

04m 4s

Applying An Icon Set To Conditional Formatting Rules

04m 24s

Chapter: Office Web Apps And Excel

What Is Office Web Apps?

02m 47s

Sign In To Or Sign Up For Your Own SkyDrive

03m 17s

Saving An Excel Workbook Into SkyDrive

03m 25s

Accessing And Editing An Excel Workbook Through SkyDrive

03m 45s

Telling Others Where Your Public Documents Are

02m 8s

Direct Linking Or Embedding Of SkyDrive Documents

02m 0s

Creating A Folder Structure Within SkyDrive

02m 32s

Deleting Files From SkyDrive

01m 13s

Chapter: Credits And Beyond

About The Author

01m 17s