Word tutorial

Chapter 1

Word Basics

1/1 - What's Microsoft Word

1/2 - Opening Word

1/3 - The Word Workspace

1/4 - Opening a document

1/5 - Open a document with a design template

1/6 - Creating a new document

1/7 - Go to another document

1/8 - Add toolbars

1/9 - Closing a document

1/10 - Saving a document

Word tutorial

Chapter 2

What's inside Word menus

2/1 - On the File menu...

2/2 - On the Edit menu...

2/3 - On the View menu...

2/4 - On the Insert menu...

2/5 - On the Format menu...

2/6 - On the Tools menu...

2/7 - On the Table menu...

2/8 - On the View menu...

2/9 - On the Help menu...

Word tutorial

Chapter 3

Enter and edit Text

3/1 - Positioning an insertion point

3/2 - Navigating through the document

3/3 - Enter text

3/4 - AutoFill text

3/5 - Selecting text

3/6 - Protecting a document

3/7 - Using Zoom

3/8 - Changing the view mode

3/9 - Working under the Outline View

Word tutorial

Chapter 4

Set Up a document

4/1 - Inserting text or a blank line

4/2 - Deleting text or a blank line

4/3 - Moving text

4/4 - Copying text

4/5 - Using AutoText insertion

4/6 - Insert a comment inside the document

4/7 - Deleting comment

4/8 - Creating a bookmark

4/9 - Using the bookmarks

Word tutorial

Chapter 5

Dressing Up Table

5/1 - Drawing a table

5/2 - Modifying a table

5/3 - Formatting the table

5/4 - Creating table border in color

5/5 - Set up the table in color

5/6 - Auto-Format a table

Word tutorial

Chapter 6

Dressing Up a document

6/1 - Undo deleted actions

6/2 - The document word count

6/3 - Find and replace text

6/4 - Finding a document

6/5 - Inserting the date

6/6 - Creating a footnote

6/7 - Creating a cross-reference

6/8 - Applying formatting text

Word tutorial

Chapter 7

The Word's Toolbox

7/1 - Checking the document spelling

7/2 - Using AutoCorrect feature

7/3 - Using the thesaurus

7/4 - Using the symbol characters

7/5 - Controlling hyphenation

7/6 - Changing text case

7/7 - Formatting the line spacing

Word tutorial

Chapter 8

Dressing Up text

8/1 - Changing the appearance of text

8/2 - Text advanced formatting

8/3 - Changing the character size and style

8/4 - Creating styles

8/5 - Using styles

8/6 - Modifying a style

8/7 - Changing the text color

8/8 - Highlighting the text

Word tutorial

Chapter 9

Set Up Layout

9/1 - Using tabs

9/2 - Creating text border

9/3 - Adjusting line margin

9/4 - Adjusting paragraph margin

9/5 - Numbering lines

9/6 - Aligning text

9/7 - AutoFormat the document

9/8 - Formatting the text in columns

9/9 - Creating a Drop cap

Word tutorial

Chapter 10

Set Up Data

10/1 - Create a mailing document

10/2 - Create a mailing data source

10/3 - Use a data source

10/4 - Merging data and document

10/5 - Setting up the mail document

10/6 - Checking a document

Word tutorial

Chapter 11

Charts and Pictures

11/1 - Inserting a drawing

11/2 - Resizing a drawing

11/3 - Applying color to a drawing

11/4 - Creating a 3D drawing

11/5 - Applying drop shadow

11/6 - Inserting a Clip Art

11/7 - Inserting a WordArt

11/8 - Resizing a WordArt

11/9 - Creating a layout wrapping style

11/10 - Creating a chart

Word tutorial

Chapter 12

Printing

12/1 - Inserting a page break

12/2 - Printing Preview

12/3 - Adjusting the document margins

12/4 - Creating header and footer

12/5 - Creating page numbers

12/6 - Page Setup

12/7 - Printing the document

12/8 - Printing envelopes and labels

12/9 - Printing data labels

Excel tutorial

Chapter 1

Excel Basics

1/1 - What's Microsoft Excel

1/2 - Opening Excel

1/3 - The Excel Workspace

1/4 - Opening a Workbook

1/5 - Opening a new Workbook

1/6 - Opening a Workbook saved

1/7 - Saving a Workbook

1/8 - Saving As a Workbook

1/9 - Exiting Excel

Excel tutorial

Chapter 2

What's inside Excel menus

2/1 - On the File menu...

2/2 - On the Edit menu...

2/3 - On the View menu...

2/4 - On the Insert menu...

2/5 - On the Format menu...

2/6 - On the Tools menu...

2/7 - On the Data menu...

2/8 - On the Window menu...

2/9 - On the Help menu...

Excel tutorial

Chapter 3

Enter and edit text and numbers

3/1 - Navigating easily in a worksheet

3/2 - Entering information

3/3 - Selecting cells

3/4 - Selecting cells easily

3/5 - Use quick feature to select cells

3/6 - Selecting rows

3/7 - Selecting columns

3/8 - Copy / Paste cells

3/9 - Selecting multiple columns and rows

3/10 - Changing and correcting information

3/11 - Duplicating information

3/12 - Select all cells

Excel tutorial

Chapter 4

Dressing Up a Worksheet

4/1 - Using AutoFill with numbers information

4/2 - Using AutoFill with words information

4/3 - Using AutoFill in a row

4/4 - Naming column

4/5 - Deleting column

4/6 - Deleting row

4/7 - Selecting multiple worksheets

4/8 - Duplicating a worksheet

4/9 - Grouping cells

4/10 - Ungrouping cells

Excel tutorial

Chapter 5

Columns and rows in Worksheets

5/1 - Fitting columns

5/2 - Fitting rows

5/3 - Resizing columns

5/4 - Autofitting columns

5/5 - Hiding columns

5/6 - Unhiding columns

5/7 - Adjusting column size

Excel tutorial

Chapter 6

Setting Up a Workbook

6/1 - Divide a worksheet in multiple windows

6/2 - Autoformatting worksheet

6/3 - Protecting worksheet

6/4 - Insert worksheet

6/5 - Moving worksheet

6/6 - Deleting worksheet

6/7 - Navigate through worksheets

6/8 - Naming worksheet

6/9 - Copying information between worksheets

6/10 - Renaming worksheet

Excel tutorial

Chapter 7

The Excel's Toolbox

7/1 - Format cells using Format painter

7/2 - Excel Assistant

7/3 - Format cells using styles

7/4 - Undo cell formatting

7/5 - Check spelling

7/6 - Undo the last action

7/7 - Redo the previously undone action

7/8 - Zoom in the worksheet

7/9 - Resizing a picture

Excel tutorial

Chapter 8

Dressing Up Text

8/1 - Formatting color in a worksheet

8/2 - Center the information in the column

8/3 - Using increase indent

8/4 - Merge and center cells

8/5 - Changing the text style

8/6 - Creating a thick outline border

Excel tutorial

Chapter 9

Adding Formulas

9/1 - Using formula in worksheet

9/2 - Copying a formula

9/3 - Writing a formula

9/4 - Formatting numbers

9/5 - Using formula bar

9/6 - Calculate a total using AutoSum

9/7 - Copy a formula to other cells

9/8 - Calculate subtotals

9/9 - Recording a macro

Excel tutorial

Chapter 10

Setting Up Data

10/1 - Formatting data

10/2 - Sorting data in the worksheet

10/3 - Sort data by Ascending or Descending

10/4 - Using AutoFilter

10/5 - Sorting data with filter

10/6 - Deleting Filter tabs

10/7 - Sorting a column

Excel tutorial

Chapter 11

Charts and Pictures

11/1 - Creating a chart

11/2 - Editing titles in a chart

11/3 - Changing the chart type

11/4 - Updating data in a chart

11/5 - Printing a chart alone

11/6 - Drawing an arrow

11/7 - Creating a text box

11/8 - Deleting a text box

11/9 - Insert WordArt text

11/10 - Moving WordArt text

11/11 - Insert Clip Art

11/12 - Moving Clip Art in the worksheet

Excel tutorial

Chapter 12

Printing Worksheet

12/1 - Defining a print area

12/2 - Using print preview

12/3 - Adding custom headers and footers

12/4 - Print preview

12/5 - Printing a Worksheet

12/6 - Changing page margins

12/7 - Creating page break

12/8 - Setting Up page orientation

12/9 - Using sheet page setup

12/10 - Using advanced page setup

Powerpoint tutorials

Chapter 1

PowerPoint Basics

1/1 - What's Microsoft PowerPoint

1/2 - Open PowerPoint

1/3 - The PowerPoint Workspace

1/4 - Start a new presentation

1/5 - Start a presentation with templates

1/6 - Open a presentation

1/7 - Save a presentation

1/8 - Exit PowerPoint

Powerpoint tutorials

Chapter 2

What's inside PowerPoint menus

2/1 - On the File menu...

2/2 - On the Edit menu...

2/3 - On the View menu...

2/4 - On the Insert menu...

2/5 - On the Format menu...

2/6 - On the Tools menu...

2/7 - On the Slide Show menu...

2/8 - On the Windows menu...

2/9 - On the Help menu...

Powerpoint tutorials

Chapter 3

Dressing Up Slides

3/1 - Create a new slide

3/2 - Select all slides

3/3 - Insert a new slide

3/4 - Change the layout

3/5 - Rearrange slides in the Slide Sorter

3/6 - Delete a slide

3/7 - Undo deleted slide

Powerpoint tutorials

Chapter 4

Formatting Text

4/1 - Select text

4/2 - Enter text

4/3 - Delete text

4/4 - Move text

4/5 - Rearrange text

4/6 - Promote text

4/7 - Collapse text

Powerpoint tutorials

Chapter 5

Formatting Slides

5/1 - Enter text in slide mode

5/2 - Delete text in slide mode

5/3 - Change text font style

5/4 - Change text color

5/5 - Change text format

5/6 - Rearrange text box

5/7 - Demote text

Powerpoint tutorials

Chapter 6

The PowerPoint's Toolbox

6/1 - Manage toolbars

6/2 - Use the Zoom button

6/3 - Check the spelling of a slide

6/4 - Check the presentation spelling

6/5 - Show ruler

6/6 - Reverse an action

Powerpoint tutorials

Chapter 7

Inserting Drawings and Pictures

7/1 - Insert drawings

7/2 - Resize drawings

7/3 - Insert WordArt text

7/4 - Resize WordArt text

7/5 - Insert ClipArt

7/6 - Insert pictures from file

Powerpoint tutorials

Chapter 8

Charts and Organization charts

8/1 - Insert a chart

8/2 - Resize a chart

8/3 - Change the chart type

8/4 - Add chart data

8/5 - Create an organization chart slide

Powerpoint tutorials

Chapter 9

Animating Slide Show presentations

9/1 - Add action buttons

9/2 - Format action buttons

9/3 - Add animation effects

9/4 - Create slide transitions

9/5 - Format slides with color schemes

Powerpoint tutorials

Chapter 10

Rearrange Slides

10/1 - Format bullets

10/2 - Apply a new slide design

10/3 - Change slide view settings

10/4 - Change the display using slide masters

10/5 - Add header or footer notes

Powerpoint tutorials

Chapter 11

Creating and Editing a custom show

11/1 - Navigate through the slide show

11/2 - Preview a slide show

11/3 - Set-Up the slide show

11/4 - Start a slide show

11/5 - Custom a slide show

11/6 - Create a note page

Powerpoint tutorials

Chapter 12

Printing Presentation

12/1 - Presentation layout

12/2 - Print the presentation