| My Basket | My Account |   

Bookmark and Share

Excel 2007 Introduction
(ISBN: 9781906990008)

Buy Dreamweaver CS4 Introduction CD

Microsoft Excel 2007 Intro Training CDMicrosoft Excel 2007 represents a major upgrade to this industry-standard powerhouse. The interactive video tutorials included on this training CD give an in-depth introduction to all the major features of the program, from entering and formatting data to the creation of complex formulas.

Main Topics

Sample Tutorials

Table of Contents

Getting Started

What can Excel do?
Using the Excel Ribbon
Using the Office button
Using the Quick Access toolbar
Creating a new workbook
Moving around workbooks and worksheets

Entering and Editing Data

Editing cells and entering text
AutoComplete, AutoFill and custom lists
Entering and formatting numbers
Entering and formatting dates
Entering formulas with the AutoSum tool
Undo and Redo
Cut, Copy and Paste
Drag and Drop

Excel Formulas

Formula basics
Adding formulas to an invoice
Operator precedence
Relative and absolute references
Using named ranges
Calculating markup

Formatting Cells

Setting Font attributes
Text alignment and text wrap
Using the Format Painter
Using Cell Styles
Creating your own styles

Excel Functions

If statements
Concatenation
The SUMIF function
COUNT, COUNTA and COUNTBLANK
COUNTIF and COUNTIFS

Editing Cells, Columns and Rows

Highlighting cells, rows and columns
Setting column width
Setting row height
Inserting and deleting rows and columns
Inserting and deleting cells

Editing Worksheets

Inserting and deleting sheets
Renaming and colouring sheet tabs
Reordering sheets
Moving sheets between workbooks
Hiding and unhiding sheets
The Freeze Panes command
Splitting a worksheet into panes

Page Setup and Printing

Using Quick Print
Print Preview
Excel's three page view modes
Orientation, margins and page size
Headers and Footers
Print Titles
Print Area

Creating charts

Anatomy of an Excel chart
Creating a chart
Manipulating charts
Creating a column chart
Creating a line chart
Creating a pie chart
Creating a bar chart
Printing charts

Back to top