Integrity Training – Microsoft Office Excel 2010 Basic

Modifying a Worksheet (0:18)

Topic A: Moving and Copying Data (0:05)

Moving Data in Worksheets (1:03)

Demo – A-1: Moving Data in a Worksheet (2:34)

Copying Data (0:47)

Demo – A-2: Copying Data in a Worksheet (2:18)

Moving Data by Dragging It (0:25)

Copying Data by Dragging It (0:34)

Demo – A-3: Moving and Copying Data by Using Drag-and-Drop (1:22)

The Office Clipboard (1:05)

Demo – A-4: Using the Clipboard Task Pane (2:08)

Topic B: Moving and Copying Formulas (0:05)

Relative References (0:47)

Demo – B-1: Moving a Formula (2:16)

Demo – B-2: Copying a Formula (1:07)

Demo – B-3: Using AutoFill to Copy a Formula (0:52)

Demo – B-4: Using Paste Link (2:14)

Topic C: Absolute and Relative References (0:06)

Demo – C-1: Observing the Limitations of Relative References (2:18)

Absolute References (0:31)

Mixed References (0:54)

Demo – C-2: Applying Absolute References (2:18)

Topic D: Inserting and Deleting Ranges, Rows, and Columns (0:08)

Inserting a Range (0:47)

Demo – D-1: Inserting a Range of Cells (1:44)

Inserting Rows or Columns (0:49)

Demo – D-2: Inserting Rows (1:19)

Deleting a Range (0:29)

Demo – D-3: Deleting a Range of Cells (1:26)

Unit 03 Review (0:14)

Unit 03 Quiz

Functions (0:14)

Topic A: Entering Functions (0:07)

Function (0:38)

Arguments (0:54)

Range Reference (0:42)

The Trace Error Button (0:26)

Syntax Errors (0:52)

Demo – A-1: Entering a SUM Function (4:26)

Demo – A-2: Using the Mouse to Enter a Function Argument (1:44)

Demo – A-3: Entering a Function in the Formula Bar (1:42)

Inserting Functions (1:02)

Demo – A-4: Inserting a Function (2:19)

Topic B: AutoSum (0:13)

AutoSum Button (0:56)

Demo – B-1: Using AutoSum (2:28)

Topic C: Other Common Functions (0:10)

AVERAGE Function (0:47)

Demo – C-1: Using AVERAGE (2:56)

MIN Function (0:36)

Demo – C-2: Using MIN (1:26)

MAX Function (0:43)

Demo – C-3: Using MAX (0:56)

COUNT Function (0:53)

Demo – C-4: Using COUNT and COUNTA (2:18)

Unit 04 Review (0:14)

Unit 04 Quiz

Formatting (0:23)

Topic A: Text Formatting (0:04)

The Font Group (0:37)

Demo – A-1: Formatting Text (1:58)

Selecting a Non-Contiguous Range (0:22)

Demo – A-2: Formatting a Non-Contiguous Range (0:48)

Formatting Cells (0:31)

Demo – A-3: Using the Format Cells Dialog Box to Format Text (1:38)

Topic B: Row and Column Formatting (0:04)

Changing Column Widths (1:02)

Demo – B-1: Changing Column Width and Row Height (2:51)

Demo – B-2: Applying Color to a Row (0:49)

The Merge & Center Button (0:22)

Demo – B-3: Setting Alignment (1:51)

The Borders Menu (0:52)

Demo – B-4: Applying Borders to Cell Ranges (1:31)

Using the Border-Drawing Pencil (0:25)

Demo – B-5: Using the Border-Drawing Pencil (0:53)

Paste Special Dialog Box (0:49)

Topic C: Number Formatting (0:05)

Number Formatting (0:55)

Demo – C-1: Using the Number Group to Format Numbers (2:53)

The Number Tab (1:04)

Demo – C-2: Exploring the Number Tab (1:27)

Topic D: Conditional Formatting (0:10)

Conditional Formatting Menu (0:58)

New Formatting Rule Dialog Box (1:05)

Rules Manager (1:07)

Demo – D-1: Creating a Conditional Format (4:30)

Demo – D-2: Editing and Deleting a Conditional Format (2:01)

Topic E: Additional Formatting Options (0:12)

Copying and Clearing Formats (1:00)

Demo – E-1: Copying Formats (1:49)

Demo – E-2: Using AutoFill to Copy a Format (1:54)

Applying a Cell Style (0:42)

The Cell Styles Gallery (0:46)

Format a Table (0:59)

Demo – E-3: Applying Cell Styles (0:38)

Demo – E-4: Applying Table Styles and Sorting Data (1:54)

Demo – E-5: Using Find and Replace to Change Formatting (1:58)

Unit 05 Review (0:16)

Unit 05 Quiz

Printing (0:20)

Topic A: Preparing to Print (0:07)

Using the Spelling Checker (1:01)

Demo – A-1: Checking Spelling in a Worksheet (1:44)

Using Find and Replace (0:57)

Demo – A-2: Finding and Replacing Text (1:44)

Page Layout View (0:52)

Demo – A-3: Previewing a Worksheet (2:00)

Topic B: Page Setup Options (0:14)

Changing Scaling Settings (0:49)

Demo – B-1: Setting Page Orientation and Scaling (1:27)

Setting Custom Margins (1:05)

Demo – B-2: Adjusting Margins (2:01)

Preview Information: 

Original Page

Archive Page

Integrity Training – Microsoft Office Excel 2010 Basic Available now at Vincourse.com

Integrity Training – Microsoft Office Excel 2010 Basic Download, Integrity Training – Microsoft Office Excel 2010 Basic Available Now, Integrity Training – Microsoft Office Excel 2010 Basic Order, Integrity Training – Microsoft Office Excel 2010 Basic Reviews, Integrity Training – Microsoft Office Excel 2010 Basic Torrent, Integrity Training – Microsoft Office Excel 2010 Basic Course Download, Integrity Training – Microsoft Office Excel 2010 Basic ClubBuy, Integrity Training – Microsoft Office Excel 2010 Basic Groupbuy