All articles with 'Excel Howtos' Tag
Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

I am stuck with an excel problem and I need your help. While trying to insert an image in to my excel 2007 workbook using VBA I hit on this weird error and not able to use the ActiveSheet.Pictures.Insert method. Do you know why?
Continue »
Most of us think of mastering formulas, learning macros and being supergood with charts when we think of being productive with spreadsheets. But often learning simple stuff like keyboard shortcuts, using mouse and working with menus and ribbons can be a huge productivity booster for us. So as part of this installment of spreadcheats we […]
Continue »Here is a very quick tip if you ever want to hide a cell’s contents in excel
Just use the custom cell formatting (more here) code ;;;
Continue »Hide a Workbook from Nosy Colleagues [quick tip]
![Hide a Workbook from Nosy Colleagues [quick tip]](https://i287.photobucket.com/albums/ll133/pointy-haired-dilbert/hide-excel-workbook.png)
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.
Continue »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.
Continue »Do you want to make a budget vs. actual performance chart but not sure what option to use? Check out these 14 excel charting alternatives and find the one that tells your story.
Continue »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 …
Continue »Highlight Top 10 Values using Excel Conditional Formatting

In excel conditional formatting basics article, we have learned the basics of excel conditional formatting. In this article we will learn how to highlight top 5 or 10 values in a list using excel as shown aside. We will use LARGE excel formula and conditional formatting to do this.
Continue »Excel Conditional Formatting Basics

Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.
Continue »
Learn how to use excel chart templates in this installment of spreadcheats. Save time.
Continue »How to Change Shapes in Microsoft Office 2007

Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”
This is very useful feature, especially when you are using PowerPoint.
Continue »