PC Simplicity Series
PB/262x200/IllusB&W. 48 pp
ISBN: 9781877431296
Microsoft Excel 2007 is a program designed to create and use a spreadsheet. This Guide will take you through the intermediate functions and building your confidence in the skills needed to use the software more productively. It assumes you have the skills taught in the previous Guides.

Table of Contents

Lesson 1 Fill/Series WorkBook Settings Text Wrap Top Align ClipArt Resizing images Top and Bottom Margins Lesson 2 Hyperlinks Activating Hyperlinks Lesson 3 Creating a Chart Moving & Sizing a Chart Chart Legend Chart Plot Area Chart Value Axis Chart Horizontal Axis Chart Data Series Chart Data Labels Major and Minor Gridlines Chart Titles Chart WordArt Styles Lesson 4 Pie Chart Chart Layout Edit Chart Types and Pieces Shape Styles Selecting a Pie Piece Selecting an Area Exploding a Pie Piece Change Chart Type Lesson 5 Group & Outline Close & Open Outlines Outline Levels Ungroup Outlines Subtotals Remove subtotals

Lesson 6 Paste / Values 3D Cylinder Chart Creating a Chart from scratch Data Series Paste / Transpose Lesson 7 IF Formulas Lesson 8 IF Formulas with multiple statements Absolute Cell Referencing Lesson 9 CountIf formula Count formula CountBlank formula Delete Sheets Sumif formula Lesson 10 Conditional Formatting Creating a Template Opening a Template Lesson 11 Link Formula Saving files to a WorkSpace Arrange Windows Cascade

Get your copy now.