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 [...]
Ribbon Hero 2 – A Free Game for Learning Microsoft Office
June 16, 2011 By Leave a Comment
Ribbon Hero 2 : Clippy’s Second Chance is a free game from Microsoft Office team. You can play the game inside Office 2007 or 2010 applications on Windows 7, Vista, or XP. The game is aimed to get users to explore the office applications (Word, Excel, PowerPoint, or OneNote) in an entertaining way. “Yes, we [...]
Create a Pivot Table Report in Google Docs Spreadsheets [New Feature]
May 18, 2011 By Leave a Comment
If you are familiar with Microsoft Excel, you may use Pivot Table to quickly summarize large amounts of data. Now Google added this feature to Google Docs. Let us see how to create a Pivot Table report in Google Docs. First create a Spreadsheet in Google Docs; Create New->Spreadsheet and prepare a sample data as [...]
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 [...]
Microsoft OFV Add-in for Office 2003 and 2007 to Boost Security
April 17, 2011 By Leave a Comment
Office File Validation (OFV) is a security add-in for Office 2003 & 2007. It first introduced in Microsoft Office 2010. OFV for Microsoft Office 2003 & 2007 verifies that a particular binary file (such as .doc) complies with the application’s expectations. If files fail to conform to the format, user will be notified for possible [...]
[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 [...]
Open and Edit Files Created Using Microsoft Office 2007 or 2010 in Earlier Versions
March 26, 2011 By Leave a Comment
You can directly open and edit documents, workbooks, and presentations that were created in earlier versions of Word, Excel, and PowerPoint in newer versions (Microsoft Office 2007/2010). But what about opening and editing files that were created in newer versions of Office in earlier versions (Microsoft Office 2000, Office XP, or Office 2003). For this purpose [...]
Recent Comments