Removing leading Apostrophe (‘) in Excel from Numbers and Text
This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business application Lotus Notes. If the data is copied or extracted to Excel then these unwanted characters interferes with Excel’s normal functioning. So […]
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 […]
Quickly fill Blank cells with the Value in the Cell Above
There are situations when you ask someone to punch data for you and they come up with one lazy idea to leave the cell blank if the same value is repeating in subsequent cells in the same column. Download the tutorial workbook or look at the picture below to understand the situation better. This is definitely […]
Excel Pivot Tables - Grouping Dates by Week Within Months, Quarters or Years - Workaround
Earlier we learned about grouping and ungrouping time related information very easily using excel pivot tables. It saves huge amount of time in preparing summary pivot table reports with different dimensions of time. However, we also learned one limitation of this feature i.e. if we want to group dates by week within a month or […]
Excel Pivot Tables - Grouping Data by Date and Time
Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for certain period of time. Excel is good and the best thing happened to Excel is Pivot Tables and one of the […]
Running Totals and Running Balance with Excel Pivot Tables - How To
Last time when I discussed how to do running totals and running balance using Excel many different ways were discussed but one was left for today which is doing running totals and running balance using Pivot Tables in Excel. The reason was by that time we didn’t discussed how to make pivot tables. But as […]
How to quickly fill cells with 0 (zero) - Excel Quick Tip
Moments ago an active member of our facebook Excel community Muhammed Bilal Asmat asked this question: Okay for example there is a very large table consists of rows and columns. Some of the cells contains values and some are blanks. So I want to convert cells containing values to zero. The way I am doing […]
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 […]
