![Copy Paste Row Height in Excel [Quick Tip]](../../wp-content/uploads/2013/04/1-minute-excel-tutorial-150x150.png)
Copy Paste Row Height in Excel [Quick Tip]
In Excel we have the ability to easily copy and paste the column width using paste special and the beauty of this trick is that you simply have to copy the column having a desired width and go the column of which you want to adjust the width and hit Alt+ Ctrl+V > from the […]
Hiding Gridlines in Excel - Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were “forced” to disappear by filling the cells with white fill colour. Yes it does work but its not the right way to do it. […]
Create Simple Dial Charts in Excel - How To
Charting or graphing is one of the biggest punch Excel has. Visual presentation of data greatly improves user’s ability to comprehend the information and significantly cuts down the time to take decisions. That is why executives around the world rely on charts and graphs rather than simple reports full of words. Believe me nobody has […]
How Excel VLOOKUP Works: How to use it - Explanation with Example
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better I explained the example of mathematical lookup table to find the rate. If you haven’t read that article yet then I strongly recommend to read that first and then come to […]
How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of many]
Functions to Excel is like Sense to Humans. Humans with absent sense are no better than crawlers walking on two legs, without functions Excel is just another program with ability to store information and doing simple maths. In a nutshell functions made a spreadsheet program that can really excel at data. Functions are like ready […]
Excel Pivot Table tutorial for Absolute Beginners: Creating your First Pivot Report [2 of 2]
In my last tutorial Part 1 of this little jump start series on Pivot Tables for Absolute Beginners I explained what excel pivot tables are the science behind their working through example and explained how pivot table let you analyze and make great reports by presenting them in meaningful way. If you didn’t understood what we […]
Excel Pivot Table - Introduction: What, Why and How for Absolute Beginners [1 of 2]
Excel is surely a cavalry of features. And if we count the ways in which each feature can be useful just makes the whole think almost countless. However, for every feature one must know what it is, why and where we might need it and finally if we need it then how to use it […]
Excel Find based on cell formatting - When appearance matters
Most probably you might have not found this little find option in Excel i.e. find by cell formatting. Basically it let you include additional condition to find only such results that hold specific format of the cell. Remember format includes: Text format that includes: Font size, font color, font type, font style, font effects i.e. […]
10+ ways to SUM Top N values in data range - Ready to be Ben 10 of Excel?
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently discussed how to do conditional SUM as well where we learnt to add up only those values that certain criteria. However, […]
Introduction to Excel Tables - Data beyond just formatting
Many people think converting data into table is basically a formatting options giving it colours and other eye candies like giving data “zebra lines”. But there is much more to it beside data formatting and face lift that comes in terms of functionality and features that are available if data is maintained in tables. In […]
