There is no argument that VLOOKUP is a beautiful & useful formula. But it suffers from one nagging limitation. It cannot go left....
Posted on 30 March 2013 (Downloads: 1555) Info Technology
Sometimes we don’t know what we want. If this happens when I am in a bar, I usually order a cocktail. Just a mix of everything. The same will work in Excel too....
Posted on 30 March 2013 (Downloads: 3348) Info Technology
We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers ba...
Posted on 30 March 2013 (Downloads: 1535) Info Technology
In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel....
Posted on 26 March 2013 (Downloads: 3699) Info Technology
Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks...
Posted on 25 March 2013 (Downloads: 2184) Info Technology
Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and go...
Posted on 25 March 2013 (Downloads: 3731) Info Technology
Blank rows or Blank cells is a problem we all inherit one time or another. This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel sprea...
Posted on 23 March 2013 (Downloads: 2343) Info Technology
Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they h...
Posted on 23 March 2013 (Downloads: 1645) Info Technology
short cuts ...
Posted on 23 March 2013 (Downloads: 708) Info Technology
Microsoft Excel shortcut keys...
Posted on 14 March 2013 (Downloads: 1457) Info Technology
Windows 8 Shortcut Keys Read more at: http://www.caclubindia.com/share_files/files_upload_form.asp...
Posted on 09 March 2013 (Downloads: 767) Info Technology
Basic Shortcuts of MS-Office...
Posted on 07 March 2013 (Downloads: 2180) Info Technology
Use it you will love it.......
Posted on 01 March 2013 (Downloads: 4643) Info Technology
this is free add in utility to convert number/amount/text/indian currency rupees in microsoft excel...
Posted on 28 February 2013 (Downloads: 820) Info Technology
This is use ful file for students...
Posted on 26 February 2013 (Downloads: 1680) Info Technology
This tutorial is the continuation on working with tables in Excel 2007 . You can find the first part in the link – Part 1 – Organize data using Tables in Excel...
Posted on 20 February 2013 (Downloads: 1384) Info Technology
All Excel Formula with examples...
Posted on 15 February 2013 (Downloads: 4315) Info Technology
we can do smartwork with shortkeys ...
Posted on 13 February 2013 (Downloads: 3573) Info Technology
Live class on PF & ESI Enrollment & Returns Filing(with recording)