How to Hide Zero Values and Error Values in Excel Spreadsheets

1.jpg

In spreadsheets where we used formulas extensively some of the cells may contain zero values as well … [Read more...]

Combined Use of Excel Logical Functions IF, OR, AND

1.jpg

My last office related article on this site was on 27th November. Today it is 27th December that … [Read more...]

Excel 2010 Keyboard Shortcuts’ Quick Reference Cards

wlEmoticon-smile.png

Remembering keyboard shortcuts is not so complicated as you think. Regular use is the only solution … [Read more...]

How To Prepare Business, Financial Statement Forms Or Templates In MS Excel

TR101877334.png

You may wonder why I have not written any office related articles recently. Even though there is a … [Read more...]

Prevent Invalid Data Being Entered in to Cells in Excel

Excel includes tons of useful functions, commands and other features. To grasp all of them is not … [Read more...]

[How to] Find Commands in Microsoft Office 2007 & 2010 Quickly

For users familiar with earlier versions of Office programs may face some problems when they first … [Read more...]