Replace-Genius-Featured-Image-2_thumb.jpg

Replace Genius: find and replace text in Excel and Word files, in batch

Finding and replacing text in multiple text files at once isn’t new, but most people in businesses and homes use Word and Excel files, not text files. If you use Excel or Word extensively and would like to perform find and replace operations right from the desktop (and/or in batch), then check out ‘Replace Genius’,

Text Deduplicator Pro Screenshot

Text Deduplicator Plus: easily sort and remove duplicates from a list

What do you do if you have long lists of information that you need to de-dupe or sort? You can use a program like Excel, which is not free, has a very large footprint on your PC, and cannot easily handle really large lists of much more than a million rows. You could fire up

PrintEco Screenshot1

Save paper and print from Office more efficiently, with ‘PrintEco Office’

We’ve all had situations where a simple print command from Excel or Word results in numerous almost-blank pages being uselessly printed with a part or fragment of a table or formatting that uselessly spilled over onto blank pages. In most cases this can be fixed via ‘page break preview’ and/or page setup, but what if

Simple MS Excel Document Converter Screenshot

Convert XLS, XLSX, CSV, PDF and XPS files in batch, with ‘Simple MS Excel Document Converter’

Do you have years’ worth of Excel XLS files that you would like to convert to XLSX or CSV? Or, conversely, do you have XLSX files sent to you that you would rather convert to XLS? If you’ve ever needed to convert Excel files (from or to XLS, XLSX, CSV, PDF and XPS formats) then

Decision Making Tool Screenshot1

Make better decisions with ‘Decision Making Tool’: an Excel based quantitative scoring template

Let’s say that you have to make a decision between a number of options where you have to take into account multiple factors or considerations. It can be very useful to write these down so you can see them in front of you, but it can also be really useful to weigh the different factors

w_winf02c

Free eBook Giveaway: Microsoft Office 2010 Tips & Tricks

Users of MS Office 2010 take note: Microsoft Office 2010 Tips & Tricks is an ebook that offers insights on advanced MS Office functionality valued at $6.95, but offered for free through Wednesday Nov 16th 2011. This ebook contains tips for Word, Excel, PowerPoint & Outlook, and covers many of the features of Office 2010

XY Chart Labeler Screenshot

Add labels to data points in an Excel XY chart with free Excel add-on “XY Chart Labeler”

It is very easy to plot an XY Scatter chart in MS Excel, which is a graph displaying a group of data points that intersect across related variables (such as performance vs. time for example, or sales vs. profitability, etc). What is not easy, however, is adding individual labels to these data points, requiring users

LibreOffice-Screenshto.jpg

Get powerful, free office tools with LibreOffice

Looking for an alternative to paying for Microsoft Office? Tried OpenOffice.org but found it didn’t quite fit? You might find what you need in LibreOffice free office tools from The Document Foundation. LibreOffice consists of six full-featured office tools. Base allows you to manage databases, and create queries and reports to track and manage information.

OfficeTabs-Screenshot3

OfficeTabs: add tabs to Excel, PowerPoint, and Word

OfficeTabs adds tabs to MS Office applications Excel, PowerPoint, and Word, allowing for tabbed navigation across several open documents in the manner familiarized by Firefox or Chrome, etc (see screenshot above) The free version allows for personal, non commercial use, and provides a number of options such as the ability to place tabs on top,

Charting-before-and-after2

CleanCharts: Excel add on creates better looking charts with a single click

CleanCharts is a free add on for Microsoft Excel that can tweak your Excel charts in several different ways to make them more visually appealing. It provides five areas of improvement: removal of “chart junk” (i.e. unnecessary formatting), fixing axis labels and scaling, fixing font sizes, doing away with 3D elements, and changing the color