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 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 →
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 →
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 →
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 →
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 →
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 →
Tableau Public: create charts and interactive dashboards and publish them to the web
One way to describe this software is: take the Excel charting engine, make it a standalone app that can chart data from any source, and give it a web/community sharing component for publishing charts and dashboards on the web. Except this charting engine is light years ahead of Excel in terms of both its capabilities as →
