Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Microsoft Office Starter Edition Tips

20 Jan 2010   #1
Lee

Win 7 Pro x64, VM Win XP, Win7 Pro Sandbox, Kubuntu 11
 
 
Microsoft Office Starter Edition Tips

Here are some tips for those who are playing around with MS Office Starter.


Microsoft Office Starter 2010 Tips and Tricks 6: Excel Starter, Beyond Basics

In this week’s Tips and Tricks article we are going to focus on three features in Excel Starter that allow for quite a bit of utility. When thinking about using Excel Starter to create a family budget, for instance, these features should help you go beyond the basics. Let’s get started.
Define Name

Define Name is a feature to name a cell or a series of cells to later be used in a formula. Not only does this allow you to reference a series of cells easily, it helps define them to make it easier to remember, understand, and reuse them.
Start by opening Excel Starter 2010. In our example we have created a list of Expenses. Select this table, then go to the Formulas tab and click Define Name.

Then type a name into the Name textbox that defines the list and click OK.
.
Once you have done this you can use the Define Name in other formulas like this SUM formula.

Conditional Formatting

Conditional Formatting allows you to set Excel Starter to format particular cells based on the data that is present. There are a number of rules you can set. We’re going to start with an example table of the NFL standings.

Begin by highlighting the cells you are interested in, then, from the Home tab, select Conditional Formatting.

In this example we have selected the Percent column and indicated that we want them to be formatted with a Light Red Fill with Dark Red Text when the value is less than .5 or 50%. We finish by clicking OK.

Conditional Formatting is really great because not only are there a number of different rules that be applied to the formatting, but if those values in those cells change, the Conditional Formatting is still realized. In other words if suddenly a team below a 50% win ratio wins 2 games in a row and is now above a 50% ratio, the cell will no longer be formatted.
Custom Sort

Using the same table of NFL standings we’re going to explore Custom Sort. Start by highlighting an entire table and then from the Home tab, select Sort & Filter and then Custom Sort.

The dialog box shown below will pop up letting you decide how to sort the table. For instance this first sort is based on the Percent column and has sorted the team with the best win percentage to the top.


This custom sort below has sorted alphabetically based on the team name.



Wrap Up


We hope you have enjoyed this Office Starter 2010 Tips and Tricks. With these “beyond the basics” skills, you will have a much easier time keeping your information organized, color coded, and sorted. It is all built into Office Starter. Thanks for reading!
2010 Microsoft Corporation. All rights reserved.


My System SpecsSystem Spec
.

20 Jan 2010   #2

Windows 7 Ultimate Signature Edition
 
 

thank you for sharing this with us all.
My System SpecsSystem Spec
Reply

 Microsoft Office Starter Edition Tips





Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:19 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33