All articles in 'Excel Howtos' Category
Ok, Excel Hyperlinks may not be able to rescue you from an imploding planet, but they can add to the useability of your Excel Projects.
This post looks at Hyperlinks. What they are and how to use them in your workbooksContinue »
Excel can be a bland collection of cells with text and numbers or it can be a playground where you can have interactive engagement with your models.
The choice is yours!
Excel provides a small number of tools to allow you to interact with your models.
These tools are called Form Controls and can be added into and linked to your models data.
This post will look at the various types of Form Controls and discuss their application and use.Continue »
Here is a fun formula to write.
Given a number in cell, I want you to find the sum of digits in it. So, for eg. if you have the number 3584398594 in a cell, the sum would be =3+5+8+4+3+9+8+5+9+4, equal to 58.
Now, how would you write a formula to find this sum automatically based on the number entered in the cell?
Go ahead and figure it out. If you can, come back and check your answer with mine below.Continue »
Transferring data regularly between Excel and Word for the production of Word based forms or reports cab be tedious if it involves much more than a few numbers.
This post looks at a technique for automating this process.
Lets say you have some data in 2 columns and you want to compare row by row to spot the differences. Of course you can write a formula or apply conditional formatting. But there is a quick and dirty solution that works just as fine.Continue »
In the final post of the Are You Trendy? series we will look at the use of Excel Charts and associated Trendlines for trend analysis and I will give you a free tool (Normally valued at $200, I wish) which will allow interactive assessment of a Charts Trendline Y value for any X value.Continue »
Does your data hold hidden secrets?
In Part 2 of Are You Trendy? we will examine the Excel functions that assist us in Trend Analysis.
The Properties button on the Developer Tab in Excel 2007/10 can be used to access a number of Worksheet properties normally only available through VBA and even a few which aren’t available through VBA.
Lets take them for a spin.
Often you may have a set of data and need to know what an intermediate or future value of that data may be.
This week we will investigate 3 methods of tackling this problem using Excel.
In this post we’ll look at manual forecasting.
Today I am asking you a tricky formula question. This is asked by Ionel on the Introduction to VLOOKUP, OFFSET & MATCH Formulas post. The question is, I have data in three columns: A,B,C and I want to get the average of the closest two values out of three in each row. Could you help […]Continue »
Often, while creating a complex model or dashboard, you may want to include additional training material in the workbook. So let us learn how to embed flash movies, Youtube videos etc. in to Excel workbooks.
To Embed Flash Movies, Youtube Videos in to Excel, follow these steps.Continue »
Today, we will learn an interesting array formula trick to test if a list is sorted or not. During last one week, I got 2 requests from different clients for some excel related work. Both of them had one thing in common. To test whether a list is sorted or not. So I got thinking, […]Continue »
Ashish sends out this SOS thru email, “I need your help in putting filters . Can we filter the cells on the basis of their even or odd character. i.e in the table of 1-1000, i wish to filter, 1,3,5,7,…”
An odd request, I must say. But nevertheless, possible in Excel.
Read this quick tip, If you want know how to filter odd or even rows only in a list of values.Continue »
New to Excel 2007 is the Picture Selection Pane.
This is a neat little tool which allows quick sorting and editing of the visibility of pictures and other objects on a worksheet.Continue »
WordArt is a quick and easy to use tool to allow Excel users to add pizzazz to the presentation of your worksheets.
This is a quick tutorial in the use of WordArt.