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 […]
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 […]
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 […]
Excel Pivot Table Slicers: Old Filters got Overhauled!
First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention is however, very opposite. I would really like that you must convince rather pressurize IT department of your company to have […]
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 […]
20+ Excel Table tricks to turbo charge your data
Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]
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 […]
