In this guest article, Yoav Ezer shows you how to change the default axis interval in a chart in Microsoft Excel. Find out more about Yoav at the end of this article.

Microsoft Excel is pretty clever and usually the default choices it provides you are good, but sometimes it can be frustrating when it tries to help you and you can not find a way to alter the choices it makes.

Chart axis options are a common example of these frustrations. People often ask us how to override the default Axis Interval. Here is the solution for how to do that.

Read the rest of this entry »

In one of my previous articles I explored how we might find the customer service issues hidden within the masses of text we receive on a daily basis through an online feedback form. In this article we will take a look at what we could do next once we know what the main customer issues are.

Acting on the Data

When we start to see trends forming that is when we can build categories and decide a system of actions for those categories. For instance, we might push certain new messages to our support departments to be expedited automatically, while other less pressing issues can sit in a queue for a little longer.

When we have a ‘security’ issue come through we want to send them quickly to be handled by our ‘security specialist’. If a message contains a request that deal with writing Macros we would want one of the developers to help with that.

Does this sound like something you would like to use?

Read the rest of this entry »

Update: Part 2 of this article can be found here.

Using spreadsheets to analyze numerical or well-categorized data is relatively straightforward. It might not be easy necessarily, but at least you normally know exactly what to do. If you have ever been faced with open-ended text responses, perhaps from a survey, emailed questions or feedback forms, you know how tricky it can be to make sense of it.

The problems are many. Non-standard formatting, having to manually read each response to understand its content, variable length, and those are just the first that come to mind.

What we need is some way to drill down automatically to see if there are any common patterns, and therefore have an immediate starting point to start interpreting the responses.

Read the rest of this entry »

Thinking about upgrading to Microsoft Office 2010?

Each upgrade brings exciting new features, but new versions of your favourite programs can take some getting used to. It’s no different for those of us here at Microsoft who create the Office programs than it is for our customers.

To ease the transition, we’ve put together six handy Office 2010 migration guides to help you step up to the newest versions of Microsoft Access, Excel, OneNote, Outlook, PowerPoint, and Word.

Read the rest of this entry »

PDFTiger is a desktop application that quickly and accurately create PDF documents from Word, Excel, Powerpoint, txt or Images. PDFTiger can also convert PDF files into editable MS Word Documents, Rich Text Documents, Plain Text Files, Images, HTML Files, and Shockwave Flash SWF Files.

.

.

Windows Guides’ Rating	Compatible with	System
4 out of 5

Read the rest of this entry »

In Part 1, I covered some printing techniques to reduce paper wastage, namely Duplex Printing, Multiple Pages per Sheet, Content Editing, Print Preview, and Digital Format. If you haven’t come across it, you are welcomed to look into Part 1 before going into Part 2.

In this part, I will be covering some software that are specifically written to assist computer users in reducing paper wastage, as well as help in saving printing inks (they are expensive!) The software covered are mixed with free and commercial versions, and I list out the pros and cons for each software, and give some recommendations for those who are looking at a free solution. There is one common characteristic for all these software: all of them will be installed as a virtual printer in your operating system to streamline the printing process. So let’s begin with the first printing software:

Read the rest of this entry »