ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for more than 24 hours. So here you have the confession and also your Excel tip for which you wait everyday. So again fulfilling the promise to make you excel at Excel […]
![How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of many]](../../../../wp-content/uploads/2012/09/excel-page-featured-image-150x150.png)
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 Mouse Mayhem - 35+ Mouse tricks for mouse mongers
I know many of the Excel users prefer keyboard shortcuts and Excel does provide plenty of them. But if we are keen to know and remember keyboard tricks then we should pay some homage to PC’s mouse. Following are the double click tricks you can do with your mouse in Excel to make your daily […]
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. […]
Randomly Select a Name from a list in Excel - How To
Suppose you have a long long list of customers from which you have to select a random name. Now this is certainly not a problem if you have tens or even few hundreds of names. But imagine if you have over 85,000 names in which case you cannot hand pic one name. Just imagine the […]
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, […]
Birth Dates Heat Map in Excel - How To
First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date. 7 and 7. Everyone’s birthday is interesting in one or the other. But what if you like to know how the birthdays of employee in an organization are spread over the […]
Conditional SUM in Excel with SUMPRODUCT function
One of our dear member at our Excel facebook page Mr. Zeeshan Sarwar shared a problem in which he wanted to sum only those invoices amounts against which “paid on” date is mentioned. Putting it in simple words it is a conditional sum where you want to sum values on a condition if they are […]
