Books & Videos

Table of Contents

Chapter: Start Here

Getting Started With Excel 2013

02m 20s

The Excel Workbook Explained

02m 24s

Signing Up For Your Own Free SkyDrive

02m 20s

Customize The Quick Access Toolbar

02m 40s

Using The Included Working Files

01m 35s

About The Author

01m 14s

Chapter: Managing Excel Workbooks And Worksheets

Creating And Saving A New Workbook

03m 19s

Opening Workbooks And Save As Options

03m 21s

Saving And Opening SkyDrive Files

02m 22s

Navigating An Excel Workbook

04m 25s

Adding And Removing Worksheets

03m 2s

Renaming Copying And Moving Worksheets

04m 21s

Chapter: Entering And Editing Data In Cells

Entering Text, Numbers, And Dates

03m 29s

Entering Numbers As Text

03m 30s

Editing The Contents Of A Cell

02m 41s

Undo And Redo Actions

02m 50s

Cut, Copy, And Paste

04m 40s

Dragging And Dropping Cells

02m 48s

The Fill Handle

06m 46s

Inserting And Deleting Cells Columns And Rows

04m 9s

Changing Column Widths And Row Heights

04m 19s

Hiding And Un-Hiding Columns And Rows

03m 23s

Searching For Values In A Workbook

03m 0s

Chapter: Math Basics

Getting Started With Basic Math Formulas

05m 15s

Order Of Operation With BODMAS

03m 52s

Introduction To Basic Formulas

05m 41s

Copying Formulas And Functions - Chapter 4

04m 39s

Displaying Formulas On A Worksheet

04m 11s

Chapter: Formatting Worksheets

Selecting Cells For Formatting

02m 53s

Modifying Typeface Font, Size, And Colour

05m 37s

Merging And Wrapping Cell Contents

06m 2s

Using Number Formats

05m 56s

Cell Content Alignment And Orientation

03m 43s

Adding And Removing Borders From A Selection

04m 33s

Applying A Date Format To A Cell Or Range

03m 42s

The Format Painter

03m 48s

Finding And Replacing Formats

06m 13s

Clearing Cell Contents Vs. Clearing Cell Formatting

05m 12s

Chapter: Workbook And Worksheet Management

Worksheet Navigation And Coloured Worksheet Tabs

04m 24s

Moving Or Copying Worksheets Within And Between Workbooks

03m 39s

Viewing And Scrolling Multiple Workbooks At The Same Time

03m 46s

Hiding And Un-Hiding Sheets

02m 28s

Modifying More Than One Worksheet At A Time

04m 45s

Chapter: Page Setup And Printing

Using Print Titles And Print Areas

05m 36s

Paper Size, Orientation, Margins, And Scaling Options

06m 25s

Creating Headers and Footers

06m 3s

Using The Page Break And The Page Layout Views

04m 51s

Printing A Range Of Cells

02m 15s

Running The Spell Checker

04m 27s

Controlling Most Print Settings In One Place

05m 34s

Chapter: Mathematical Formulas

The Sum Function

06m 51s

Copying Formulas And Functions - Chapter 8

06m 45s

Other Mathematical Functions: Average, Min, And Max

05m 52s

Useful Count Functions

03m 26s

Absolute Referencing Explained

07m 8s

Formulas Across Worksheets

07m 7s

3D Referencing

07m 25s

Making Use Of Named Cells And Ranges

08m 15s

Chapter: Advanced Formatting

Enhancing Worksheets Using Themes

04m 34s

Adding, Editing, And Deleting Comments

03m 33s

Creating Your Own Autofill List

04m 23s

Converting Data To A Table For Formatting

05m 24s

Chapter: Security

Activating And Deactivating Worksheet Protection

03m 51s

Protecting Part Of A Worksheet To Aid Data Entry

03m 7s

Password Protecting The Whole Workbook

04m 51s

Chapter: Excel 2013 Templates

Using The 2013 Templates

04m 13s

Creating And Using Your Own Template

04m 39s

Chapter: Graphics Objects

Obtaining And Inserting Online Images

04m 2s

Using SmartArt Graphics

05m 46s

Inserting Shapes And Screenshots

05m 26s

Formatting Graphical Objects

05m 38s

The Stacking Order

04m 51s

Grouping Multiple Objects Together

05m 5s

Using Graphical Objects And Mathematical Formulas

03m 39s

Chapter: Using Charts In Excel

The New Recommended Charts Option

04m 17s

Create A Chart Using The Long Or The Short Method

03m 34s

Formatting A Chart With The 2013 Shortcut Options

03m 22s

Modifying The Chart Type

03m 52s

Formatting Chart Elements

04m 45s

Adding A Trendline

03m 12s

The Pie Chart In Detail

08m 1s

Mini Graphs: Sparklines

05m 50s

Chapter: Excel As A Database

Fixing On Screen Rows And Columns

05m 41s

Fixing Print Rows And Columns

03m 2s

Sorting Data In Excel

05m 59s

Filtering Data To Reduce Dataset Size

06m 3s

Removing Duplicate Entries In The Data

02m 20s

Adding Subtotals To A Worksheet Of Data

04m 49s

Using Text To Columns Effectively

05m 9s

Linking To Data On A Webpage

04m 14s

Chapter: Advanced Formulas

Using An If Formula

05m 1s

Use Of The If Function To Hide Excel Error Messages

04m 51s

Datedif: A Useful But Hidden Formula

04m 37s

Text Manipulation Using Functions

05m 40s

Use The Text Function To Format Numbers

03m 57s

Date Manipulation Functions

03m 39s

Introducing Sumif, Countif, And Averageif

06m 38s

Use Of Rank To Calculate Placings

04m 33s

Flash Fill: The Magic Touch

03m 39s

Chapter: Conditional Formatting

Altering Cell Appearance Based On The Cell Value

04m 1s

Displaying Data Bars, Color Scales, Or Icon Sets

03m 34s

Using Top And Bottom Rules For Formatting

03m 33s

Creating A Formatting Rule From Scratch

03m 37s

Managing The Conditional Formatting Rules

04m 8s

Chapter: What's Next

The New Office Apps For Excel 2013

03m 42s

Ready To Go Advanced

02m 1s