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
valtonray

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





Similar help and support threads
Thread Forum
I can't OPEN Microsoft office starter 2010.
I had been using Office Starter 2010 for about a week, now suddenly when I try to open it I get a pop up message that it cannot be opened. Try again or repair the product in control panel. But I see no option in the control panel to repair such thing, and trying again is not working. What else can...
Microsoft Office
Microsoft Drops Office Starter Edition
Read more at: Microsoft Drops Office Starter Edition | PCWorld
News
Why I cannot open my Microsoft office starter 2010 ?
I have a microsoft office starter 2010 . I can open it until last week.. Can anybody tell me why?
Microsoft Office
Removing microsoft office 2010 starter
Hi,Just bought my wife a new windows 7 laptop last week she had an xp before.Its a nice little machine.On it has microsoft office 2010 starter pack and every time she opens office it has that right hand pane which we cant seemed to get shot of.She had open office on the old xp and she found it...
Microsoft Office
Microsoft Offers Free Starter Edition for PCs or Portable USB Key
Read more and download at: Maximum PC | Microsoft Offers Free Starter Edition for PC For more information about Office Starter 2010: What is Office Starter 2010? - Starter - Office.com
News
Upgrading Office 2010 Starter Edition
Just bought a new HP PC and it came with Office 2010 Starter Edition. Haven't actually used it yet, though. I've been looking around to find out what the "upgrade" prices are to turn this into Office 2010 Home and Student -- and apparently, there aren't any. If I understand it, the...
Microsoft Office

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 23:09.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App