T4T Video Library

Excel - Split Fields Using Text to Columns

Learn how to split one field into multiple fields.

In this example, we take a field called Full Name and split it into First Name and Last Name.

Excel - Combine Fields Using Concatenate

Learn how to combine multiple cells into one cell.

In this example, we take fields called First Name and Last Name and combine them into a field called Full Name.

Excel - Paste Special

Learn how to use Paste Special to eliminate potential headaches when moving or deleting data.

In this example, we override our original concatenate function which allows us to move our data anywhere without changing the look.

PowerPoint - Image Manipulation

Learn how to edit images in PowerPoint.

In this example, we'll demonstrate how to crop an image and save it as a new file to be used in other applications.

PowerPoint - Animate

Become an animaniac: Impress your audience by controlling your bullet points.

In this example, we take a few simple bullet points and have them appear on successive mouse clicks.

Excel - Pivot Tables - Part One

Crash course on Pivot Tables - Party One

We've split this lesson into two parts: Part One will cover how to quickly create a pivot table while Part Two goes into a bit more detail.

Excel - Pivot Tables - Part Two

Crash course on Pivot Tables - Part Two

We've split this lesson into two parts: Part One will cover how to quickly create a pivot table while Part Two goes into a bit more detail. You should probably watch Part One first.