fbpx
Search
Close this search box.

All articles with 'Excel Howtos' Tag

Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

Published on Jul 30, 2009 in VBA Macros
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 »

Do you know these Double-click Tricks in Excel?

Published on Jun 12, 2009 in Excel Howtos, Featured, Learn Excel
Do you know these Double-click Tricks in Excel?

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 »

How to Hide a Cell’s Contents in Excel? [Quick Tip]

Published on Jun 5, 2009 in Excel Howtos, Featured, Learn Excel

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]

Published on Apr 22, 2009 in Excel Howtos, Learn Excel
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.

Continue »

Using Credit Card Numbers in Excel

Published on Apr 7, 2009 in Excel Howtos, Learn Excel
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 »

Budget vs. Actual Charts – 14 Charting Ideas You can Use

Published on Apr 5, 2009 in All Time Hits, Charts and Graphs, Featured

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

Published on Mar 25, 2009 in Excel Howtos, Learn Excel
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

Published on Mar 17, 2009 in Excel Howtos, Learn Excel
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

Published on Mar 13, 2009 in Excel Howtos, Learn Excel
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 »

How to use Excel Chart Templates and Save Time

Published on Mar 10, 2009 in Charts and Graphs, Excel Howtos, Learn Excel
How to use Excel Chart Templates and Save Time

Learn how to use excel chart templates in this installment of spreadcheats. Save time.

Continue »

How to Change Shapes in Microsoft Office 2007

Published on Feb 25, 2009 in Excel Howtos, Office Tips
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 »