A macro lets you automate complex or repetitive tasks. By recording keystrokes and mouse movements, you can replay a sequence of commands to perform any series of actions quickly and efficiently.
Archive for the ‘Microsoft Excel 2007’ Category
Working with macros in Excel 2007
Posted in Microsoft Excel 2007 on September 23, 2010 | Leave a Comment »
Converting Text to Columns in Excel
Posted in Microsoft Excel 2007 on June 27, 2010 | Leave a Comment »
Sometimes data isn’t structured the way you’d like it to be. Separating delimited text into columns is easier than you might think.
Excel drop-down lists for accurate data-entry
Posted in Microsoft Excel 2007 on June 12, 2010 | Leave a Comment »
Excel drop-down lists can be used in to make data entry more accurate or limit the selection of data to a pre-defined list.