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
Win 10 - won't upgrade due to Microsoft Office Starter 2010 HELP!!!!
So I am trying to do the upgrade as I have had some issues with my desktop for a while. Simply will not open Malwarebytes except in safe mode. Other programs wouldn't open either. So I began mainly using my laptop. Needless to say I now HAVE to use my desktop for a few days and decided to upgrade...
General Discussion
Microsoft Office Starter 2010
I would like to find and downlaod the 2010 office starter edition. Anyone know where I can find it? I have microsoft office 2003 and I would like to keep that, can I have more then one office on my computer at the same time?
Microsoft Office
Microsoft Drops Office Starter Edition
Read more at: Microsoft Drops Office Starter Edition | PCWorld
News
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 11:33.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App