TrainPack | Excel 2010 courseware

Home Workbooks Download Sample Chapters Order Contact us

Individual Workbooks
Basic Excel 2010/2007/2003/ XP/2000/97 | US$95

Basic Word
Advanced Word
Basic Excel
Advanced Excel
PowerPoint
Access
Internet Skills
Basic Windows Skills

F.A.Q.
Testimonials
Policies & Terms

TrainPack
Complete collection of over 50 workbooks | US$995

Office Suite Packages
All manuals for Office 2010/2007/2003/XP/2000 or 97 plus Basic Skills and Internet workbooks. US$595

The Basic Excel workbook

view PDF page
download printable chapter

Spreadsheet skills have become essential for virtually everyone who works with numbers, and are particularly necessary for anyone responsible for the basic numerical tasks associated with running a business, maintaining an office or keeping the household books. The WARP! Basic Excel course provides your learners with a solid grounding in essential spreadsheet creation and management skills. Courseware for Excel 2010, Excel 2007, Excel 2003, Excel XP 2002, Excel 2000 and Excel 97.

Table of contents: (Basic Excel 2010 courseware)

Chapter	What your students will learn
CHAPTER 1 - Getting Started	Starting Excel Title Bar Minimizing, Maximizing, Restoring, Moving and Resizing a Window File Ribbon Tab - Opening a File Status Bar The Ribbon Scrollbars Dialog Boxes

CHAPTER 2 - Customizing Excel	Page Layout Page Break Preview Normal View Show group Customizing the Quick Access Toolbar Excel Options

CHAPTER 3 - Creating a New Spreadsheet	What is a Spreadsheet? Working with Numbers Creating a New Spreadsheet Saving a spreadsheet Undo and Redo last action Editing cell contents and [F2]

CHAPTER 4 - Formatting Text	Adding text AutoFit Column Width Formatting text - Font, Size, Bold and Centering Text Alignment

CHAPTER 5 - Formatting Numbers	Adding and Formatting Currency Calculating a Value using a Multiply Formula Copying and Pasting a Formula Paste Options button The Office Clipboard Paste Special Resizing a column using the mouse Minus Fomula Formatting Values AutoSum Sum Formula Divide Formula Percentages Calculation operators in formulas

CHAPTER 6 - Columns and Rows	Deleting Rows Column Width Row Height

CHAPTER 7 - Borders and Shading	Borders Shading

CHAPTER 8 - Word Tools	Spell Check AutoCorrect Finding text Replacing text Go To

CHAPTER 9 - Page Formatting	Headers and Footers Page Setup

CHAPTER 10 - Charts and Graphs	Creating a Chart Chart Type Chart Title Chart Data Labels Rotating the pie slices Exploding a slice of pie An extra charting exercise

CHAPTER 11 - Clip Art and WordArt	Clip Art Clip Organizer WordArt

CHAPTER 12 - Printing	Print Preview Printing Closing a spreadsheet Exiting Excel

CHAPTER 13 - AutoFill, AutoFormat and Styles	AutoFill Series AutoFormat - Table Styles Gallery Styles - Cells Styles

CHAPTER 14 - Formulas and Functions	Adding Formulas to a spreadsheet Formatting Values Introduction to Logical Functions IF - Logical Function AND - Logical Function Editing a complicated function Worksheet Protection

CHAPTER 15 - Using Help	Starting Help Table of Contents Search Offline Help Search Online Help [F1] Help