Microsoft Excel 2002 Practical Concepts, is a great book that provides you an amazing view of how a person can transform a simple idea into useful-well designed worksheets.
This is what you will find in the book Microsoft Excel 2002 Practical Concepts:
Basic to intermediate exposure to Excel 2002 skills.
Step-by-Step instructions.Every group of steps shows you through a concept or lesson where you will construte, change or improve a Excel 2002 project.
In depth explanation of the "why" behind the skill.
Learning goals are plainly explained at the begining of each chapter.
Written to meet the needs of Excel 2002 students and teachers for a visually oriented text
Contains an amazing number of exercises for you to practice your skills: 21 Micro Tests, 6 Mini Test, 2 Tests, and 9 Challenge Tests.
Chapter 1 Creating the first worksheet
Starting Up Excel
Closing the task pane
Display the toolbars in two separate rows
Entering text in a worksheet
Saving your worksheet
Chapter 2 Calculating a Sum
Objective
To sum a column of numbers
Copy a cell to adjacent cells
How to calculate multiple totals at the same time
Chapter 3 Formatting the worksheet
Objective
How to bold a cell
Change the font size of a cell entry
Change the font color of a cell
Center the title across columns
Micro test 3-1
Use AutoFormat to change the format of the worksheet
Chapter 4 Creating a chart
Objective
Add a chart to the worksheet
Print the worksheet
Mini Test 5-1
Chapter 5 How to create simple formulas
Objective
Micro test 5-1
Enter a simple formula by pointing
Micro Test 5-2
Chapter 6 Formatting the worksheet
Objective
Micro test 6-1
Change the background of a cell
Add a drop shadow to a range
Select a drop shadow
Change the color of a drop shadow
Apply an outline border to a cell
Center the column titles
Add comma style format to non-contiguos selections
format non-contoguos cell using the Currency Style button
Micro test 6-2
Change the alignment of a cell to avoid overflow
Use Today function
Chapter 7 Test Section 1
Test 7-1
Test 7-2
Chapter 8 Functions
Objective
Micro test 8-1
Use the fill handle to create a month series
Micro-test 8-2
Micro test 8-3
Reviewing the formulas
The MAX function
Mini test 8-1
Chapter 9 Working with columns
Use the right-click option to make Copy and Paste
Micro-test 9-1
To insert a row
Micro-test 9-2
To insert several rows
How to eliminate a row
How to insert nonadjacent columns
Type column title on multiple lines within a cell
Micro Test 10-1
Chapter 10 More about formatting
Change the width of a column to best fit
Change the width of a column manually
Change the width of several non adjacent columns with the Colums Width Command
Copying formats to other cells
Micro-test 10-1
Change the name and color of a worksheet
Change the page orientation to Portrait and Landscape
Adding headers and footers
Fit in one page
Chapter 11 Test section 2
Mini Test 11-1
Mini Test 11-2
Challenge Test 11-1
Chapter 12 Order of Operations
Objective
Work with the order of operations, and parentheses
Fast practice test
First method to determine a percentage
Second method to determine a percentage
Mini Test 12-1
How to verify a formula using Range Finder
Chapter 13 Conditional Formatting
Objective
Format numbers using the format cells dialog box
Easy test
Add conditional formating to a range of cells
Chapter 14 Check Spelling, print a partial worksheet, and more
Objective
Check the spelling of a worksheet
Easy test
Print a partial or complete worksheet
Display and print the formulas used in a worksheet
Protect cells and workbooks
Work with the order of operations, and parentheses
E-mail a workbook from Excel
Chapter 15 Sorting Information
Objective
Mini Test 15-1
Increase the conditional formatting
Micro Test 15-1
Mini Test 15-2
To rotate text
Format cell before entering values
Sorting a single column
Sort multiple columns
Test 15-1
Chapter 16 Test Section 3
Challenge Test 16-1
Easy Test
Challenge Test 16-2
Challenge Test 16-3
Chapter 17 Making Decisions
Objective
To use the Zoom box
Divide the window into panes
Use the IF function to perform a logical test
Work with the order of operations, and parentheses
Easy test
Chapter 18 Absolute references
Objective
Fast Practice Test
Diference between Absolute and Relative references
Use absolute references in a formula
Easy test
Chapter 19 Creating a 3-D Pie Chart
Objective
Build a 3-D Pie chart
Modify specific parts of a chart
Enhance the color of a chart
Explode a 3-D Pie chart
Change the perspective of a chart
Add Fill Effects to your chart
Micro Test 19-1
Micro Test 19-2
Show and format the present date
Print multiple sheets
Chapter 20 Working with templates
Objective
Create a template
Micro test 20-1
Transform a template into a workbook
Fine-tune the template
Copy the contents of a worksheet to other worksheets in the same workbook
Edit the contents of a cell
Enter information in each worksheet of a workbook
Chapter 21 Linking multiple worksheets
Objective
Micro Test 21-1
Add a worksheet to a workbook
Relocate a sheet tab
Mini Test 21-1
Link several sheets
Fast Practice Test
Draw a 3-D Pie Chart
"Mocygo supplied me with a very easy to use, well thought-out, quality training resource, one that is obviously designed to be used. It was also very well packed for a safe Trans-Atlantic journey and swiftly
despatched. A highly recommended supplier!"
DJ R. London
"I enjoy this book very much because it was my first time experienced with Windows XP Practical Concepts. I never knew what it was meant until I was given the opportunity"
