We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,594,809.27 | Books Available: 785,790 | Members Online: 268

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

Search - Essentials of Excel 2000

Essentials of Excel 2000
Author: Shelly Siegel, Kevin A. Siegel

Who says spreadsheet programs have to be hard to learn? You'll be shocked to learn how easy it is to learn Excel 2000 using our "skills & drills" approach to learning. If you open this book on Monday morning, you'll be proficient with Excel by Tuesday afternoon. And when you have finished with this book, you'll be able to comfortably cre... more »ate simple-to-complex spreadsheets that include absolute and relative formulas. You'll know how to format cells and cell ranges, control pages, work with multiple sheets and even create slick-looking charts. You'll also be able to create your own templates, record and edit macros, and test your data. All this... in two days (or less)! This is the same course that would cost you nearly $600 if you went on-site to a professional training facility. Now you can bring the class to you... and save a bundle. Here's exactly what you'll learn... Module 1 Lessons: The Basics The Excel Environment, 1-2 Copy Files to the Hard Drive, 1-2 Launch Excel 2000, 1-3 Use ToolTips, 1-4 Move From Cell to Cell,1-4 Type and Edit Text in a Cell, 1-6 Save an Excel Worksheet, 1-7 Cell Ranges, 1-8 Select a Range of Cells, 1-8 Resizing Columns, 1-9 Resize One Column Using AutoFit, 1-9 Use AutoFit to Resize More than One Column1-9 Resize a Column Manually, 1-10 Worksheets, 1-10 Move Between Worksheets, 1-10 Group Worksheets, 1-11 Enter Data on Multiple Worksheets, 1-12 AutoFill, 1-13 Use AutoFill to Enter Data, 1-13 Insert a Worksheet, 1-14 Delete Worksheets, 1-15 Naming Worksheets, 1-16 Rename and Move Worksheets, 1-16 Module 2 Lessons: Formulas Formulas Overview, 2-2 Create a Simple Formula, 2-2 Use AutoFill to Duplicate a Formula, 2-3 AutoSum, 2-3 Use AutoSum, 2-3 Relative Cell References, 2-4 Create a Relative Cell Reference, 2-4 Absolute Cell References, 2-5 Create an Absolute Cell Reference, 2-5 Functions, 2-8 Use Functions with Formulas, 2-8 Copy Data between Worksheets, 2-10 Formatting Cells, 2-12 Move cell contents, 2-12 Delete and Insert Rows and Columns, 2-12 Manually Format Selected Cells, 2-13 Format Cells Automatically, 2-15 Module 3 Lessons: Charts Charts Overview, 3-2 Create a Chart using Chart Wizard, 3-2 Resize and Move a Chart, 3-4 Change the Placement of the Legend, 3-5 Change the Color of a Data Series, 3-5 Change the Appearance of a Charts Title, 3-6 Change the Chart Type, 3-7 Change Chart Data, 3-7 Add a Graphic to the Chart, 3-8 Use Color Blends in the Chart, 3-9 Altering Data, 3-10 Change the Effect of Chart Data, 3-10 Module 4 Lessons: Worksheet Setup Worksheet Setup, 4-2 Adjust a Worksheets Margins & Orientation, 4-2 Insert a Manual Page Break, 4-4 Insert Headers and Footers, 4-4 Print a Workbook, 4-6 Module 5 Lessons: Importing, Filtering & Sorting Data Importing Data, 5-2 Use the Text Import Wizard, 5-2 Filtering and Sorting, 5-4 Filter a List, 5-4 Custom Filters, 5-6 Create a Custom Filter, 5-6 Sorting, 5-8 Sort a List Using Single Criteria, 5-8 Sort a List Using Multiple Criteria, 5-8 Advanced Filtering Techniques, 5-9 Filter Data with the Advanced Filter, 5-9 Copy Filtered Data to Another Location, 5-11 Pivot Tables, 5-12 Create a Pivot Table with the PivotTable Wizard, 5-12 Change the Layout of a Pivot Table, 5-15 Charts from Pivot Tables, 5-17 Create a Chart from a Pivot Table, 5-17 Module 6 Lessons: Testing Data Testing Data Overview, 6-2 The IF Function, 6-2 Use the IF function, 6-2 The OR Function, 6-4 Use an OR function, 6-4 The AND Function, 6-6 Use an AND function, 6-6 Styles, 6-8 Create Styles, 6-8 Module 7 Lessons: Naming & Linking Naming Cells and Ranges, 7-2 Define a Name, 7-2 Go To a Defined Range of Cells, 7-2 Delete a Name, 7-3 Create a Name, 7-3 Linking Worksheets, 7-5 Link Individual Cells, 7-5 Link Cell Ranges, 7-6 Linking Names with Sheet Level Names, 7-7 Define a Sheet Level Name, 7-7 Link Cells using Sheet Level Names, 7-7 Consolidating, 7-9 Consolidate Figures From Multiple Worksheets, 7-9 Freezing & Splitting Worksheets, 7-11 Freeze Panes, 7-11 Split the Worksheet, 7-12 Hide a Column, 7-13 Comments, 7-14 Create and Use Comments, 7-14 Custom Views, 7-15 Use Custom Views, 7-15 Protection, 7-16 Protect a Worksheet, 7-16 Hide Formulas, 7-17 Module 8 Lessons: Templates & Macros Create Formulas, 8-2 Delete Cell Contents, 8-5 Add Comments, 8-5 Create and Use a Custom Template, 8-6 Practice Recording a Macro, 8-8 Create a Macro, 8-9 Macro Editing, 8-12 Edit a Macro, 8-12

ISBN-13: 9781891762543
ISBN-10: 1891762540
Publication Date: 1/26/2000
Pages: 138
Rating:

0 stars, based on 0 rating

Publisher: Iconlogic
Book Type: Spiral-bound
Members Wishing: 0
Reviews: Amazon | Write a Review

Back to the Top ↑

Search - Essentials of Excel 2000

Loading...