by Usman | Dec 25, 2012 | VBA Funtions
Some days ago, I was working with some data which was distributed in about 18 sheets within a single Excel file. I was supposed to make calculations and then present that file to senior management. Now presentation was important as well. I must have made it easier for...
by Usman | Apr 22, 2012 | Excel Functions, Keyboard Shortcuts
Working with Excel in office environment extensively needs you to work with keyboard. You need to be quick to be productive. Time and motion study proves it that making use of keyboard shortcuts reduces time required to accomplish a task. You must learn the short cuts...
by Usman | Mar 30, 2012 | VBA Funtions
Use of SUM formula is very common to add a range of cells. You can also use SUMIF as well if some condition has to be fulfilled for addition of certain cells. But if we have to add certain cells from a range on basis of cell background color or font color of those...
by Usman | Mar 24, 2012 | Excel Basics, Keyboard Shortcuts
If you are used to keyboard short-cuts, it really makes life easier. You can really do tasks way faster. You have plenty of keyboard shortcuts once you are working in Excel. But you want to open using a shortcut? It’s very easy. Simply go to the Excel icon and...
by Usman | Mar 21, 2012 | Miscellaneous
Era of electronic spreadsheets started from VisiCalc in 1983 and now well developed version of Microsoft Excel 2010 is available at this moment and too much is to appear yet. Name any profession where employees use computers, Excel exists there. No organization...
Subscribe To Excel Newsletter
You will receive it when a new post is published
You have Successfully Subscribed!