In spreadsheets where we used formulas extensively some of the cells may contain zero values as well as error values. Zero values may appear as a formula result at the same time error value may be caused by errors in formulas. Error value like #DIV/0!, #NAME? and #VALUE are common. By hiding these values you [...]
Combined Use of Excel Logical Functions IF, OR, AND
December 27, 2011 By Leave a Comment
Excel 2010 Keyboard Shortcuts’ Quick Reference Cards
November 27, 2011 By Leave a Comment
Remembering keyboard shortcuts is not so complicated as you think. Regular use is the only solution to train your brain (or finger ) to use keyboard shortcuts flawlessly. But one should know about the available keyboard shortcuts in Excel or any other application in order to practice it regularly. I assume many of you may [...]
How To Prepare Business, Financial Statement Forms Or Templates In MS Excel
November 17, 2011 By Leave a Comment
You may wonder why I have not written any office related articles recently. Even though there is a special category dedicated to Office Tips on this site, you can see only few articles there. It is not due to time constraint, dearth of inspiration or anything like that. I intentionally opt out of writing office [...]
Prevent Invalid Data Being Entered in to Cells in Excel
April 21, 2011 By Leave a Comment
Excel includes tons of useful functions, commands and other features. To grasp all of them is not easy. For example you can see several functions like date & time, database, engineering, financial, information, logical etc. in Excel. In my opinion it is not important to learn all of them. It is better to concentrate on [...]
[How to] Find Commands in Microsoft Office 2007 & 2010 Quickly
April 15, 2011 By 1 Comment
For users familiar with earlier versions of Office programs may face some problems when they first use Microsoft Office 2007 or 2010 programs because of the ribbon interface. The menus and toolbars, in some programs, have been replaced with the Ribbon. The Ribbon is designed to help you quickly find the commands that you need [...]
Combine Data From Several Worksheets into a Master Worksheet in Excel
March 8, 2011 By Leave a Comment
To summarise data you can use PivotTable, Formulas or Data Consolidation in Excel. In this tutorial we can see how to use Data Consolidation to combine data from separate worksheets into a master worksheet. Data Consolidation is a very useful command in Excel. So carefully follow the below steps as it will be very handy [...]
Five Useful Excel Tips That No One Can Just Ignore
February 24, 2011 By Leave a Comment
Excel 2007 : Print Your Company Logo on the Bottom Side of All Pages
January 3, 2011 By Leave a Comment
Rearrange Data From Columns to Rows or Vice Versa in Excel
January 1, 2011 By Leave a Comment
Recent Comments