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
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 …
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 …
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 …
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 …
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 …