Excel 2003

PC Simplicity Series

Computer guides that are not too big, not too small... but just right!

For Microsoft Office 2003 -- as well as others such as Dreamweaver, Flash and MYOB. These easy and affordable guides make it all so SIMPLE.
Used by thousands at home, in large & small businesses, schools, training institutions, and Government departments.
These 'just right' guides will get you working. Fast.

Each book is printed and bound with a soft cover. These books will be sent by post, and are not available in a downloadable format. Worldwide postage and handling charges are included.

Scroll down to view details of the following Dreamweaver MX Tutorials on this page: Getting Started and Advanced

Microsoft Excel 2003 - Getting Started   Microsoft Excel 2003 is a program designed to create and use a spreadsheet. This Guide will take you through getting started and building your confidence in the skills needed to use the software productively. Click Here to view 2 pages of content in PDF format.  This book is 44 pages in length. Table of Contents Session 1 Running the Excel program Close the Task Pane Main Menu bar Activating menus Extend menu Cancel a menu Moving a Toolbar Standard Toolbar Zoom Reference bar Switching Sheets Scrolling Go To Moving around with Shortcuts Name Box Task Pane Exiting the Program Session 2 Numerical Entries Body Area Date Entries Selecting Cells Increase Decimal Position Cancel a Selection Sum Formula Currency Format Undo, Redo New Folder Saving a File Closing a File New Sheet Session 3 Open a sheet Edit Deleting Center Align Bold Sum Formula AutoSum Resave Inserting Rows Merge & Center Underline Session 4 Widening Columns Font Colour Font Size Session 5 Multiply Formula Divide Formula Session 6 Save File to Another name Options/ Recently Used Files List Opening Files from the Menu Switching between Files Compare Side by Side New Session 7 Print Preview Zoom Margins Divide Formula Arrange Windows Session 8 Column Width Fonts Page Setup – Landscape Session 9 Selecting an Entire Sheet Size Lines & Borders Repeat Last Function Session 10 Right Lines/Borders Using Excel as a Calculator Session 11 Decrease Decimal Selecting an Entire Row Tools Options Sheets in Workbook Selecting an Entire Column Outline Borders

Microsoft Excel 2003 - Popular Functions   Microsoft Excel 2003 is a program designed to create and use a spreadsheet.  This Guide will take you through the most used 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 Guide. Click Here to view 2 pages of content in PDF format.  This book is 44 pages in length. Table of Contents Session 1 Inserting Rows Borders Fonts Format Cells Lines and Borders Border Colours Copy Paste Average Formula Maximum Formula Minimum Formula Numerical Formatting Number Formatting Fill Color Session 2 Save As Displaying Multiple Sheets Switching between Sheets Session 3 Inserting Multiple Rows Inserting Columns Deleting Rows Clearing Formats Sorting Align Text within a Cell Multiple Column Widths Descending Sort Session 4 Add 1 Formula Selecting an Entire Sheet AutoFit Multiple Column Widths Copy & Paste Replace Cut Session 5 Print Preview Page Setup - Print Row Titles Gridlines Row and Column Headings Margins Landscape Headers and Footers Printing Session 6 Absolute Referencing Print Areas Session 7 Selecting Multiple Areas Compare Side by Side Session 8 Today Formula System Date and Time Date Formats Session 9 Absolute Reference Shortcut Selecting Multiple Columns Freeze Panes Drawing Toolbar Session 10 Text Wrapping Editing Sheet Tags Session 11 Inserting Comments Editing Comments Session 12 Data Sort Selecting Rows Session 13 AutoFilters Filter Data Return All Records Multiple Filters Custom AutoFilters Removing Filters

Microsoft Excel 2003 - Intermediate   Microsoft Excel 2003 is a program designed to create and use a spreadsheet.  This Guide will take you through the most used 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 Guide. Click here to view 2 pages of content in PDF format.  This book is 44 pages in length. Table of Contents Session 1 Fill/Series WorkBook Settings AutoFilter Filter Data Filter All Inserting Pictures Page Break View Resizing a Picture Normal View Session 2 Custom Filters Filter Blank Filter Sort Session 3 Formula View AutoFormat Headers and Footers Clear Formats Creating a Chart Moving & Sizing a Chart Chart Type Chart Objects Chart Fonts Selecting Bars Chart Bar Patterns Session 4 Drawing Arrows Row & Column Labels Session 5 Pie Charts Editing a Pie Piece Exploding a Pie Piece Session 6 Group & Outline Close & Open Outlines Outline Levels Session 7 Paste Special / Values Column Chart Paste Special / Transpose Session 8 IF Formula Session 9 IF Formula Session 10 IF Formula Absolute Referencing Session 11 COUNTIF formula COUNT formula COUNTBLANK formula SUMIF formula Session 12 Creating a Template Conditional Formatting Opening a Template Session 13 Link Formula Saving files into a WorkSpace Arrange Windows Cascade

Microsoft Excel 2003 - Advanced   Microsoft Excel 2003 is a program designed to create and use a spreadsheet.  This Guide will take you through the most used 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 Guide. Click here to view 2 pages of content in PDF format.  This book is 64 pages in length. Table of Contents Session 1 Fill/Series WorkBook Settings AutoFilter Filter Data Filter All Inserting Pictures Page Break View Resizing a Picture Normal View Session 2 Custom Filters Filter Blank Filter Sort Session 3 Formula View AutoFormat Headers and Footers Clear Formats Creating a Chart Moving & Sizing a Chart Chart Type Chart Objects Chart Fonts Selecting Bars Chart Bar Patterns Session 4 Drawing Arrows Row & Column Labels Session 5 Pie Charts Editing a Pie Piece Exploding a Pie Piece Session 6 Group & Outline Close & Open Outlines Outline Levels Session 7 Paste Special / Values Column Chart Paste Special / Transpose Session 8 IF Formula Session 9 IF Formula Session 10 IF Formula Absolute Referencing Session 11 COUNTIF formula COUNT formula COUNTBLANK formula SUMIF formula Session 12 Creating a Template Conditional Formatting Opening a Template Session 13 Link Formula Saving files into a WorkSpace Arrange Windows Cascade