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.




2    2007 CustomGuide, Inc.
                                                             Table of Contents
Creating and Working with Charts ........................................................................................................................ 9
 Creating a Chart ...................................................................................................................................................10
 Resizing and Moving a Chart ............................................................................................................................... 12
 Changing Chart Type............................................................................................................................................ 13
 Applying Built-in Chart Layouts and Styles........................................................................................................... 14
 Working with Chart Labels.................................................................................................................................... 15
 Working with Chart Axes ...................................................................................................................................... 17
 Working with Chart Backgrounds ......................................................................................................................... 18
 Working with Chart Analysis Commands ............................................................................................................. 19
 Formatting Chart Elements................................................................................................................................... 20
 Changing a Chart's Source Data.......................................................................................................................... 22
 Using Chart Templates ......................................................................................................................................... 23
Managing Workbooks...........................................................................................................................................25
 Viewing a Workbook............................................................................................................................................. 26
 Working with the Workbook Window .................................................................................................................... 28
 Splitting and Freezing a Workbook Window......................................................................................................... 30
 Selecting Worksheets in a Workbook................................................................................................................... 32
 Inserting and Deleting Worksheets....................................................................................................................... 34
 Renaming, Moving and Copying Worksheets ...................................................................................................... 35
 Working with Multiple Workbooks......................................................................................................................... 37
 Hiding Rows, Columns, Worksheets and Windows ............................................................................................. 39
 Protecting a Workbook ......................................................................................................................................... 41
 Protecting Worksheets and Worksheet Elements ................................................................................................ 43
 Sharing a Workbook ............................................................................................................................................. 45
 Creating a Template ............................................................................................................................................. 47
Working with Page Layout and Printing ............................................................................................................. 49
 Creating Headers and Footers ............................................................................................................................. 50
 Using Page Breaks............................................................................................................................................... 52
 Adjusting Margins and Orientation ....................................................................................................................... 54
 Adjusting Size and Scale...................................................................................................................................... 55
 Adding Print Titles, Gridlines and Headings ......................................................................................................... 56
 Advanced Printing Options................................................................................................................................... 57
More Functions and Formulas............................................................................................................................. 60
 Formulas with Multiple Operators......................................................................................................................... 61
 Inserting and Editing a Function........................................................................................................................... 62
 AutoCalculate and Manual Calculation ................................................................................................................ 64
 Defining Names .................................................................................................................................................... 66
 Using and Managing Defined Names................................................................................................................... 68
 Displaying and Tracing Formulas ......................................................................................................................... 70
 Understanding Formula Errors ............................................................................................................................. 72
Working with Data Ranges................................................................................................................................... 75
 Sorting by One Column ........................................................................................................................................ 76
 Sorting by Colors or Icons .................................................................................................................................... 78
 Sorting by Multiple Columns................................................................................................................................. 80
 Sorting by a Custom List ...................................................................................................................................... 81
 Filtering Data ........................................................................................................................................................83
 Creating a Custom AutoFilter ............................................................................................................................... 84
 Using an Advanced Filter ..................................................................................................................................... 85
Appendix of Common Functions......................................................................................................................... 87
 Financial Functions............................................................................................................................................... 88
 Date & Time Functions ......................................................................................................................................... 90



                                                                                                                Florida Atlantic University                            3
    Math & Trig Functions...........................................................................................................................................92
    Statistical Functions..............................................................................................................................................94
    Lookup & Reference Functions ............................................................................................................................95
    Database Functions..............................................................................................................................................96
    Text Functions ......................................................................................................................................................97
    Logical Functions..................................................................................................................................................98
Index .....................................................................................................................................................................106




4            2007 CustomGuide, Inc.
Introducing                                                    What People Are Saying
CustomGuide                                                    "I have saved hundreds of hours of design
                                                               time by just picking and choosing what I want

Courseware
                                                               from the courseware."
                                                                                     -- Stephanie Zimmerman
                                                                                     Lancaster County Library
Thank you for choosing CustomGuide courseware as the
solution to your training needs. A proven leader in the        "We have been able to customize our training
computer training industry, CustomGuide has been the           sessions on all Microsoft Office products, at
key to successful training for thousands of students and       all levels. The ROI of these guides is great."
instructors across the globe.
                                                                                            -- Dawn Calvin
This manual is designed for computer users of all                       Las Virgenes Municipal Water District
experience levels. Novice users can use it to learn skills
such as creating formulas, while advanced users can use it     "All in all, the friendliest, most open and easy
to create and format charts.                                   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                                           -- W. Boudville
answer "how-to" questions in minutes. You can print a                                              Amazon.com
complete 300-page training manual or a single page of
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
                                                               collection of titles that will definitely fit well
Review
                                                               into their classroom learning."
A review is included at the end of the manual. Use these
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: