Video Lesson

Lesson Description

 Video Length 

 View Video

• Adding Cell Color 

• Everything you need to know about changing cell fill colors to create eye-appealing spreadsheets.

 2:34 mins 

•  Changing Margins

• Find out how to change the left, right, top, and bottom margins of your Microsoft Office documents.

 2:12 mins 

• Inserting/Deleting Rows & Columns

• In this lesson we show you how easy it is to both insert and delete either rows and columns to Microsoft Excel spreadsheets. 

1:18 mins 

• Page Layout 

• Learn how to change your document's page layout from portrait to landscape orientation.  This is especially useful when you have a wide spreadsheet that you are having trouble getting to fit onto your document.  

 2:37 mins 

• Worksheets 

•  See how to create, move, rename, and work with Microsoft Excel worksheets.  This lesson is loaded with lots of great information!

2:12 mins  

Working with Data

Video Lesson

Lesson Description 

Video Length 

View Video 

• Formulas - Average 

3:18 mins  

•  Formulas - Sum

1:52 mins 

•  Graphs and Charts

 2:07 mins  

• Importing Internet Data

1:51 mins 

• Sorting Information  

 2:49 mins  

Text Formatting

 Video Lesson

Lesson Description 

Video Length

 View Video 

• Bulleted Lists - Introduction 

• Learn the basics of creating and working with bulleted lists.  These skills carry over to all Microsoft Office programs.

  2:19 mins

• Bulleted Lists - Position Changes 

    3:12 mins 

• Bulleted Lists - Symbol/Picture Changes 

• Find out how to change your bullets to 1000's of different symbols or pictures. 

     2:16 mins  

• Font Formatting

• Everything you ever wanted to know about customizing fonts in Microsoft Excel - size, color, positioning, special effects, and more! 

 2:12 mins

• Inserting Symbols 

• There are 1000's of symbols available for you to use in all of the Microsoft Office programs.  See how easy it is to use symbols in your documents.

1:02 mins  

• Numbered Lists - Introduction 

• Learn the basics of creating and customizing a numbered list.  These skills carry over to all Microsoft Office programs.

 2:53 mins 

• Numbered Lists - Numbering Options

• This lesson covers more advanced numbered list options like customizing outline structure and schemes. 

 2:40 mins

•  Text Boxes

• In this lesson you will learn everything you will need to know about using text boxes to make all of your Microsoft Office documents look more professional.  This lesson covers how to add, move, position, resize, change border options, fill options, and font options of text boxes.

1:58 mins

Graphics & Images

Video Lesson 

Lesson Description 

 Video Length

 View Video 

• Clip Art - Introduction 

• Learn how to insert, move, and delete clip art on your Microsoft Office documents. 

1:03 mins

• Clip Art - Advanced

• Watch this lesson to learn many ways to customize clip art.  You will learn how to change clip art position, color, brightness, contrast, size, add an image border, crop an image, and much more!  

 2:48 mins

• Watermarks 

• In this lesson we will show you the easy steps for creating eye appealing watermarks on your Microsoft Office documents.

 3:04 mins

• Word Art - Introduction 

• Learn several ways to add and position word art on your Microsoft Office documents. 

2:18 mins

 Useful Tools

 Video Lesson

 Lesson Description 

 Video Length

 View Video

• Adjusting Toolbars 

• Ever lose one of your toolbars or get it stuck somehow in a strange location?  Toolbar issues can be maddening! This virtual lesson will show you how to easily fix any toolbar problem that might arise with your Microsoft Office programs.  

1:12 mins

• Format Painter

• Learn how to use this powerful tool to quickly copy and paste formatting from text, tables, clip art, word art, and cell formatting.  This tool is available in all Microsoft Office programs, and once you know how to use the format painter you will be amazed how much time it will save you! 

 3:25 mins

• Print-to-Fit Feature

• The print-to-fit feature in Microsoft Excel is a fantastic tool!  This option allows you to choose the number of printed pages to have your spreadsheet to fit on.  Want your whole spreadsheet to fit on just one page?  No problem, just check out this lesson.  

 2:10 mins

• Zoom Features

• In this lesson we will show you several ways to use the zoom feature in Microsoft Office programs so you can best view your documents in different sizes.