Sold Out
Sold Out
Book Categories |
Part 1 | Learning the Basics | |
1 | Getting Started | 2 |
An Overview of Workbooks | 6 | |
Entering Data | 6 | |
Entering Text | 7 | |
Entering Numbers as Text | 9 | |
Entering Values | 11 | |
Entering Dates and Times | 12 | |
Moving Around | 13 | |
Selecting Ranges | 14 | |
Giving Excel Instructions | 15 | |
Using Menus | 16 | |
Using Shortcut Menus | 19 | |
Using Toolbars | 20 | |
Saving Workbooks | 23 | |
Getting Help | 24 | |
Quitting Excel | 27 | |
2 | Editing and Formatting Worksheets | 28 |
Opening Existing Workbooks | 30 | |
Editing Basics | 31 | |
Changing Entries | 31 | |
Copying Entries | 31 | |
Moving Entries | 33 | |
Inserting and Deleting Cells | 36 | |
Clearing Cells | 38 | |
Checking Spelling | 39 | |
Editing Workbooks | 39 | |
Inserting and Deleting Worksheets | 40 | |
Copying Worksheets | 40 | |
Naming Sheets | 41 | |
Moving Worksheets | 42 | |
Formatting Basics | 43 | |
Changing Character Formatting | 44 | |
Changing Alignment | 44 | |
Changing Column Widths | 45 | |
Wrapping Text in Cells | 46 | |
Adding Titles | 48 | |
Specifying How Values Should Be Displayed | 50 | |
Copying Formatting | 52 | |
Creating Templates | 54 | |
3 | Performing Calculations | 56 |
Simple Calculations | 58 | |
Doing Arithmetic | 58 | |
Totaling Columns of Values | 60 | |
Using the AutoSum Button | 60 | |
Using the Sum Function | 61 | |
Referencing Formula Cells in Other Formulas | 62 | |
Naming Cells and Ranges | 62 | |
Creating a Calculation Area | 65 | |
More Calculations | 68 | |
Averaging Values | 68 | |
Identifying Highest and Lowest Values | 70 | |
Calculating with Names | 71 | |
Formulas That Make Decisions | 72 | |
Copying Formulas | 74 | |
Linking Worksheets with Formulas | 75 | |
Printing and Publishing Worksheets | 78 | |
Previewing Worksheets | 78 | |
Setting Up the Pages | 79 | |
Printing Worksheets | 82 | |
Publishing on an Intranet or the World Wide Web | 83 | |
Part 2 | Building Proficiency | |
4 | Graphing Worksheet Data | 88 |
Setting Up the Worksheet | 90 | |
Automatic Formatting | 91 | |
Plotting Graphs | 92 | |
Sizing and Moving Graphs | 96 | |
Updating Graphs | 96 | |
Changing the Graph Type | 97 | |
Using Graph Custom Types | 102 | |
Fine-Tuning Graphs | 103 | |
Adding and Formatting Text | 104 | |
Enhancing the Graph's Border | 107 | |
Adding Gridlines | 107 | |
Previewing and Printing Graphs | 108 | |
5 | Extracting Information from a List | 110 |
Sorting Data | 113 | |
Adding Sort Codes | 114 | |
Using One Sort Column | 115 | |
Using Two Sort Columns | 116 | |
Using Three Sort Columns | 116 | |
Keeping Headings in View | 117 | |
List Basics | 118 | |
Finding Records | 120 | |
Adding and Deleting Records | 121 | |
Filtering Records | 122 | |
Customizing Filters | 123 | |
Summarizing Data | 126 | |
Consolidating Data | 126 | |
Creating Pivot Tables and Pivot Charts | 128 | |
Modifying a Pivot Table | 131 | |
Plotting the Pivot Table as a Pivot Chart | 133 | |
6 | More Advanced Calculations | 134 |
Creating the Supporting Tables | 137 | |
Counting Entries | 140 | |
Creating an Estimate Worksheet | 141 | |
Looking Up Information | 142 | |
Completing the Estimate | 144 | |
Projecting Profit Margin with Iteration | 145 | |
What-If Analysis | 148 | |
Using Goal Seek to Find One Unknown Value | 148 | |
Using Data Tables to Calculate the Effects of One or Two Variables | 149 | |
Using Scenario Manager to Test Multiple Scenarios | 152 | |
Creating Scenarios | 153 | |
Changing Scenarios | 155 | |
Creating Scenario Reports | 156 |
Login|Complaints|Blog|Games|Digital Media|Souls|Obituary|Contact Us|FAQ
CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X
You must be logged in to add to WishlistX
This item is in your Wish ListX
This item is in your CollectionQuick Course in Microsoft Excel 2000
X
This Item is in Your InventoryQuick Course in Microsoft Excel 2000
X
You must be logged in to review the productsX
X
X
Add Quick Course in Microsoft Excel 2000, Quick Course books offer you streamlined instruction in the form of no-nonsense, to-the-point tutorials and learning exercises. The core of each book is a logical sequence of straightforward, easy-to-follow instructions for building useful business skills, Quick Course in Microsoft Excel 2000 to the inventory that you are selling on WonderClubX
X
Add Quick Course in Microsoft Excel 2000, Quick Course books offer you streamlined instruction in the form of no-nonsense, to-the-point tutorials and learning exercises. The core of each book is a logical sequence of straightforward, easy-to-follow instructions for building useful business skills, Quick Course in Microsoft Excel 2000 to your collection on WonderClub |