|
 A Tip from the Trainers at
|
|
|
August 15, 2008
Excel
classes now enrolling...
Click on the Course Title to view the Course Outline.
Click here
to register!
TRAIN MULTIPLE STUDENTS AND SAVE $$.
Call Full Circle at 610-594-9510 for special group pricing.
___________________________
|
|
Come explore the Microsoft Office 2007 ribbon interface...
|
|
|
|
 It's
"back to school" season and a great time to brush
up on your computer skills or learn a new software
application. Full Circle offers a great selection of courses that
fit your busy schedule. See our promotion coupon below for a
great deal on training in August & September.
We've got five levels of Excel training available in both
2007 & 2003 versions. If you work with
spreadsheets and are looking for hints on how to highlight important
data, you'll appreciate this Trainer Tip on Conditional Formatting.
Excel 2007 offers three ways to draw attention to interesting
cells: data bars, color scales and icon sets. It's just
one of the many new features of Excel 2007.
Come back to school this fall and take an introductory
or advanced level of Excel. Whether you're just
beginning Excel training or would like to learn more, we've
got the training that fits!
|
For Our Excel 2007 Users...
Using
Data Bars to Show Conditional Formatting
Conditional
Formatting helps you explore and analyze data visually, detect critical
issues and identify patterns and trends. A conditional format changes
the appearance of a cell range based on a condition or criteria. You
can use Highlight Cells Rules, Top or Bottom Rules, Data Bars, Color
Scales or Icon Sets to visualize data easily, highlight interesting
cells or ranges of cells and emphasize unusual values.
Excel 2007 enables you to create three new types of conditional
formats: data bars, color scales and icon sets. Data bars are visually
powerful because they display a band of color across the cell depending
on the value of the cell in relation to other cells in the range you
select.
The length of the Data Bar represents the value in the
cell. The higher the value the longer the Data Bar.
1. Select
the range of cells that you wish to apply Conditional Formatting.
2. Select
Conditional Formatting on the Home tab.
3. Point
to Data Bars
4. Select
the desired option - for example, click Blue Data Bar
|
|
|
Back
to School Promo
for selected Office 2007 dates in August & September.
Register two students for the same
course & date, take $50
off the second student's course fee.
Call Full Circle for dates
and courses at 610-594-9510.
(Not valid with training vouchers, PowerPacks, previously
booked courses or other discounts.)
|
|
|
Contact Full
Circle's instructors by email or by phone at
610-594-9510 if you'd like us to address a specific software challenge
in future Trainer Tip issues or if you'd like to share your own
"tip" with the Full Circle team. We look forward to hearing
from you.
|
|
|
