How to Search Online using MS- Excel – Perform Research on Any Topic
Would you like to research stock quotes, find definitions to complex words and even search for encyclopedia entries? You can do all this and more by using MS Excel. Using this tip, you can search online for anything you like from Excel Window. This will be useful if you don’t want to switch tabs every […]
LikeOffice Excel Utility – Feature Rich Addon to Simplify your Work
LikeOffice Excel Utility is an Excel Addon which simplifies your work. It has got many features which will lets you do complicated tasks easily. Once installed it creates a new LikeOffice item to the menu in Excel 2003 or a new LikeOffice tab is added to the ribbon in Excel 2007. The features in the […]
How to Show Formulas and Calculated Results in Excel
You can customize your Excel spreadsheets to display only formulas instead of results. This can be especially helpful when you are creating a report or conducting analysis of documents from the data computed by someone else. However, it will serve little or no purpose if you have either just the formulas or only the data. […]
Office Tab – Tabbed Browsing in Ms-Office – Word, Excel, Powerpoint
Office Tab is a small add-on which will bring tabbed browsing to Microsoft office. Generally every new word document or excel worksheet or powerpoint slide we open opens up in a new window and this occupies a lot of space on taskbar and also its hard to manage all the windows. With this application, you […]
How to Use Mail Merge Option in MS-Word for Mass Mailing
Mail merge is one good feature of Microsoft Word which helps you in mass mailing tasks. This is a tutorial which explains how to use mail merge effectively and simplify your work. Mass Mailing refers to mailing more than one person with different options using Mail Merge. This includes to make a set of envelopes […]
How to Print Logical or Mathematical Errors of MS-Excel Cells
Sometimes cells contain logical or mathematical errors that need to be printed. How do you enable printing these errors on paper as proof? If you want the cell errors to be displayed in your printed Excel spreadsheets, you can choose to blank out all error values, or you can convert all cells with errors to […]
How to Print a Draft Copy in MS-Excel [ Save Time, Money, Ink ]
If you find yourself repeatedly printing the same Excel spreadsheet for proofing purposes, here is how you can save plenty of time and money using draft mode. In this mode by printing a draft copy of excel document, although your graphics might not look as nice and the letters and numbers not as sharp as […]
How to Generate Random Numbers in MS-Excel
If you want to generate random numbers for use in your Excel spreadsheet, the RAND function helps to generate numbers without any specifications. But what if you need to generate random numbers only within a given range? Just follow these simple steps to learn how. Click on the cell where you would like to begin […]
Import Calculations from old versions of Excel without a Problem
While upgrading to Excel 2007, you imported calculations from older Excel documents. However, the import wasn’t 100 percent successful and you get the error message ‘#NAME?’ in some cells. The problem occurs if you have used analysis functions such as ‘CONVERT’, ‘CALENDAR WEEK’ or ‘MROUND’ in the calculation, which you had to activate earlier as […]
How to Save and Apply Filter Settings Faster in Excel
Excel has effective filter functions for evaluating table data. Separate filters can also be set for individual columns. This may be good but you have to set the criteria after each time you edit the data. Now that’s tedious! Though there is no evident way to save the filter settings, a user-defined view retains the […]
Prevent Gross Computing Errors in MS-Excel using Hot Fix Package
Microsoft Excel 2007 program commits a faux pas while calculating a particular number range. Excel 2007 is weak in certain number ranges; here, the calculation program gives an output of completely wrong values. This includes results between 65534.99999999995 and 65535 as well as between 65535.99999999995 and 65536. Instead of these numbers, the table calculation shows […]
How to Convert Numbers To Text in MS-Excel [ Change Format ]
In Microsoft Excel, If you have a column of numbers and you need to convert them all to text, you would select the column, then go to Format > Cells, and on the ‘Number’ tab, change the formatting to ‘Text’. That doesn’t quite do it though, the formatted cells will still work as numbers, which […]
« Newer Posts — Older Posts »