Use Mouse to Edit Formula Ranges [quick tip]
Here is a fun way to edit formula ranges. Just select the formula, press F2 and when you see the borders around the ranges used in that formula start dragging / resizing these borders to edit the formula range.
Hide a Workbook from Nosy Colleagues [quick tip]
Do you have a nosy colleague who would like to see what you are up to? Then use the hide workbook feature in the ribbon.
and the Winner is…
The winner for our first visualization contest is decided. Curious? Read on…
Using Credit Card Numbers in Excel
Do you know that it is not so straight forward to use credit card numbers in excel. Yes, excel uses a precision of 15 digits and thus when you enter a credit card number (16 digits) it is converted in to scientific format and the details are lost. Read on to learn the work around.
Search a Spreadsheet Full of Data using Conditional Formatting
Many of us use spreadsheets to manage huge lists of data, like customer data bases, salesperson data bases etc. Today we will learn a little conditional formatting trick that you can use to search a worksheet full of data and highlight the matching cells.
Using Array Formulas in Excel – Find if a list has duplicate items
In this installment of our spreadcheats series, we will learn how to use array formulas and findout if a list has any duplicate items. We will use Countif and array formulas to do this …
Excel Links of The Week – Malmo Edition
In this week’s excel links learn how to make bingo cards, make your random numbers unique and prepare your data for charting and much more…