Excel 2007

Text Preview:
2007 by CustomGuide, Inc. 1502 Nicollet Avenue South, Suite 1; Minneapolis, MN 55403
This material is copyrighted and all rights are reserved by CustomGuide, Inc. No part of this publication may be reproduced,
transmitted, transcribed, stored in a retrieval system, or translated into any language or computer language, in any form or by
any means, electronic, mechanical, magnetic, optical, chemical, manual, or otherwise, without the prior written permission of
CustomGuide, Inc.
We make a sincere effort to ensure the accuracy of the material described herein; however, CustomGuide makes no warranty,
expressed or implied, with respect to the quality, correctness, reliability, accuracy, or freedom from error of this document or the
products it describes. Data used in examples and sample data files are intended to be fictional. Any resemblance to real
persons or companies is entirely coincidental.
The names of software products referred to in this manual are claimed as trademarks of their respective companies.
CustomGuide is a registered trademark of CustomGuide, Inc.
                Table of Contents
The Fundamentals................................................. 9
 Starting Excel 2007............................................................................................................................................... 10
 What's New in Excel 2007.................................................................................................................................... 11
 Understanding the Excel Program Screen ........................................................................................................... 12
 Understanding the Ribbon.................................................................................................................................... 14
 Using the Office Button and Quick Access Toolbar .............................................................................................. 15
 Using Keyboard Commands ................................................................................................................................ 16
 Using Contextual Menus and the Mini Toolbar..................................................................................................... 17
 Using Help ............................................................................................................................................................ 18
 Exiting Excel 2007 ................................................................................................................................................ 20
Worksheet Basics ............................................... 21
 Creating a New Workbook.................................................................................................................................... 22
 Opening a Workbook............................................................................................................................................ 23
 Navigating a Worksheet ....................................................................................................................................... 24
 Entering Labels..................................................................................................................................................... 25
 Entering Values .................................................................................................................................................... 26
 Selecting a Cell Range ......................................................................................................................................... 27
 Overview of Formulas and Using AutoSum.......................................................................................................... 28
 Entering Formulas ................................................................................................................................................ 29
 Using AutoFill........................................................................................................................................................ 31
 Understanding Absolute and Relative Cell
 References ........................................................................................................................................................... 32
 Using Undo and Redo .......................................................................................................................................... 33
 Saving a Workbook .............................................................................................................................................. 34
 Previewing and Printing a Worksheet .................................................................................................................. 36
 Closing a Workbook ............................................................................................................................................. 37
Editing a Worksheet............................................ 39
 Editing Cell Contents ............................................................................................................................................ 40
 Cutting, Copying, and Pasting Cells..................................................................................................................... 41
 Moving and Copying Cells Using the Mouse........................................................................................................ 43
 Using the Office Clipboard.................................................................................................................................... 44
 Using the Paste Special Command...................................................................................................................... 45
 Checking Your Spelling......................................................................................................................................... 46
 Inserting Cells, Rows, and Columns .................................................................................................................... 48
 Deleting Cells, Rows, and Columns ..................................................................................................................... 49
 Using Find and Replace ....................................................................................................................................... 50
 Using Cell Comments........................................................................................................................................... 52
 Using the Research Task Pane ............................................................................................................................ 54
Formatting a Worksheet ..................................... 56
 Formatting Labels................................................................................................................................................. 57
 Formatting Values................................................................................................................................................. 58
 Adjusting Row Height and Column Width ............................................................................................................ 59
 Working with Cell Alignment ................................................................................................................................. 60
 Adding Cell Borders, Background Colors and
 Patterns ................................................................................................................................................................ 61
 Using the Format Painter...................................................................................................................................... 63
 Using Cell Styles................................................................................................................................................... 64
 Using Document Themes ..................................................................................................................................... 66
 Applying Conditional Formatting .......................................................................................................................... 68
 Creating and Managing Conditional Formatting
 Rules..................................................................................................................................................................... 70
 Finding and Replacing Formatting ....................................................................................................................... 72



                                                                                                                  Florida Atlantic University                              3
Microsoft Office Excel 2007 Review .................. 74
Index ..................................................................... 81




4           2007 CustomGuide, Inc.
Introducing                                                    What People Are Saying
CustomGuide                                                    "I have saved hundreds of hours of design

Courseware
                                                               time by just picking and choosing what I want
                                                               from the courseware."
                                                                                     -- Stephanie Zimmerman
Thank you for choosing CustomGuide courseware as the                                 Lancaster County Library
solution to your training needs. A proven leader in the
computer training industry, CustomGuide has been the           "We have been able to customize our training
key to successful training for thousands of students and       sessions on all Microsoft Office products, at
instructors across the globe.                                  all levels. The ROI of these guides is great."

This manual is designed for computer users of all                                           -- Dawn Calvin
experience levels. Novice users can use it to learn skills              Las Virgenes Municipal Water District
such as creating formulas, while advanced users can use it
to create and format charts.                                   "All in all, the friendliest, most open and easy
                                                               to understand tutorial of its type that I've ever
All this information is quickly accessible. Lessons are        seen."
broken down into basic step-by-step instructions that
answer "how-to" questions in minutes. You can print a                                           -- W. Boudville
complete 300-page training manual or a single page of                                              Amazon.com
instructions.
                                                               "...curriculum that is of high quality, student
Here's how a CustomGuide manual is organized:                  friendly, and adaptable to the audience."
Chapters                                                                                   -- Sherrill Wayland
Each manual is divided into several chapters. Aren't sure                      St. Charles Community College
if you're ready for a chapter? Look at the table of contents
that appears at the beginning of each chapter. It will tell    "...a nice training option for almost any need.
you the name of each lesson and subtopic included in the       Their complete Microsoft Office package is
chapter.                                                       by far the best deal on the market."
Lessons                                                                       -- Technical Assistance Program
Each chapter contains lessons on related topics. Each                                       Purdue University
lesson explains a new skill or topic and contains an
exercise and exercise file to give you hands-on-               "Any instructor teaching classes on Windows
experience. These skills can also be practiced using           or Microsoft Office will definitely want to
CustomGuide Online Learning.                                   give serious consideration to this important
Review                                                         collection of titles that will definitely fit well
A review is included at the end of the manual. Use these       into their classroom learning."
quiz questions and answers to assess how much you've                                            -- Dale Farris
learned.                                                                              Golden Triangle PC Club
                                                                "The materials are exceptional  I am so
                                                               excited about using them! Thanks to you and
                                                               your team for doing this wonderful work!"
                                                                                          -- Shannon Coleman
                                                                                             Learning Post Ltd.




                                                                       Florida Atlantic University                  5
Download Link:
Share Link: Forum Link:

More on Computer & Internet

  • Picture: Name: Period GL UNIT 5: SIMILARITY

    Name: Period GL UNIT 5: SIMILARITY

    File Size: 648.11 KB, Pages: 15, Views: 90,835 views

    Name: Period GL U N IT 5 : S IM IL A R I T Y I can define, identify and illustrate the following terms: Similar Cross products Scale Factor SAS ~ Similar Polygons Similarity Ratio Indirect measurement Ratio Similarity Statement AA ~ Proportion Geometric …
  • Picture: Medical Office Communication - Coursewareobjects.com

    Medical Office Communication – Coursewareobjects.com

    File Size: 6,159.55 KB, Pages: 40, Views: 91,981 views

    Medical Office 26 Communication http://evolve.elsevier.com/klieger/medicalassisting The daily functioning of a medical practice relies on good communication skills. As you have learned in previous chapters, effective communication involves excellent skills not only in speaking and listening but also in conveying nonverbal and written messages. Medical assistants …
  • Picture: State Income Tax Return Amendment Form provided by

    State Income Tax Return Amendment Form provided by

    File Size: 2,802.37 KB, Pages: 8, Views: 61,022 views

    State Income Tax Return Amendment Form provided by taxamendment.com You can download this form to file a state income tax amendment. For details on how to file or efile the amendment please check the California tax return amendment page. You can also get your tax …
  • Picture: OPEN CHANNEL HYDRAULICS AKAN SOLUTION MANUAL

    OPEN CHANNEL HYDRAULICS AKAN SOLUTION MANUAL

    File Size: 0.00 KB, Pages: 5, Views: 16,809 views

    OPEN CHANNEL HYDRAULICS AKAN SOLUTION MANUAL STARTUP HANDBOOK FEBRUARY 18, 2015 Open Channel Hydraulics Akan Solution Manual Startup Handbook OPEN CHANNEL HYDRAULICS AKAN SOLUTION MANUAL DOWNLOAD: OPEN CHANNEL HYDRAULICS AKAN SOLUTION MANUAL Getting Open Channel Hydraulics Akan Solution Manual is easy and simple. Mostly you …
  • Picture: Lab 9: Respiratory Physiology - College of Charleston

    Lab 9: Respiratory Physiology – College of Charleston

    File Size: 365.27 KB, Pages: 8, Views: 9,079 views

    Lab 8 Respiratory Physiology Laboratory 8 Respiratory Physiology The primary function of the respiratory system is to exchange oxygen and carbon dioxide between air and blood. This function sustains metabolism (via increasing blood oxygen and releasing blood carbon dioxide) and regulates blood pH. To completely …

Leave a Reply

Your email address will not be published. Required fields are marked *