Most people like to see things with their own two eyes. People like visuals especially when dealing with numbers. So if you are in Microsoft Excel and you want to turn your sales figures or budget tracking into a chart, did you know all you need to remember is one key on your keyboard?

Read more...

I have a favorite spot that I like to sit in, my couch. When I ride the train into New York City, I even have a favorite side of the train I like to sit on. Many of us are drawn to doing things a certain way because we are comfortable. One thing I’ve learned as an Entrepreneur is that I need to be open to advice from other people, and what once was awkward now seems second nature to me.

Read more...

” Excel “, how many of us really know how to use it? As many readers might smile to themselves and say; “enough to get by.” Although that may be true, if you knew more about some of the functions that help you calculate, would you double check your formulas?

Over the past month I have been asked about this issue several times; adding up subtotals. If you create a spreadsheet that has groupings of numbers you may find that you want category subtotals and a grand total. But when you create your sheet you may find that it is not very simple. Have you tried using the subtotal formula as apposed to the sum total formula?

Read more...

Do you use Excel to manage your lists? Contact lists, financial lists any data lists at all. Have you ever wanted to find duplicates in your list? With Excel 2007 this new feature has made managing and finding duplicates as easy as clicking a button.

A pop-up window will appear, choose the column that you believe contains the duplicates and uncheck the columns that do not and click OK.

If your column has duplicates they will have been removed.

See easy as pressing a button.

This is Jennifer Shaheen The Technology Therapist with your technology tip of the week.