What Are You Looking for Help With?
As a follow up to the poll How Often Do You Use Excel Macros, to further lead the direction of Excel Hints, we asked you the question:
Are you looking for more help with Macros or Formulas?
Organize Documents with Office Live
Microsoft has a free service they offer as a solution to store, organize and share your documents online. They’ve actually just made many updates to the service, so I decided to give it a try. I just recently signed up for Microsoft® Office Live Small Business and am planning on writing a review later on the quality of the service.
Read More
Functions or PivotTable?
Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Writing a Macro
You may have heard a macro as being referred to also as a sub or subroutine, but any way you phrase it, it is a set of instructions in VBA used to perform an action. Using macros in Excel will greatly enhance your Excel experience and open up many possibilities through flexibility and speed. In this post we are going to take a look at how to write a simple macro.
Read More
Writing a Custom Function
Using VBA, Excel lets you write custom functions that you can call from any cell in your worksheet (You can also call them from macros you create in VBA, but we’ll revisit this later). This feature is attractive when you are currently using a complicated formula to do some work in your spreadsheet, especially when you have to re-use that formula multiple times. I find that it is easier to read through the formula when it written in VBA, rather than a long winding formula in the formula bar of Excel.
So for this post, we’re going to take a look a small custom function I’ve written to find the last day of the month. So let’s go ahead and take a look at this example.
Read More
