May 04
How are your Excel skills? Average? Enough to get by? Have you ever thought that with just a little training, you may be able to get your work done faster, and maybe reduce the errors that occasionally sneak in?
Click here to read the full text of the article at AccountingWEB.com.
Apr 30
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link
Mar 29
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link
Mar 25
In rare instances, you might need to search and replace the * or ? characters with something else. To keep Excel from seeing these as wildcard character, Ture Magnusson reports that you can just precede them with a tilde (~). Thus, if you're replacing question marks with a different character, use ~?.
Mar 25
Press Ctrl-A to select all cells, and then choose Insert, and Reset All Page Breaks.
Mar 25
Did you know that it's not possible to assign the name History to an Excel worksheet? This is a reserved sheet name that Excel uses in conjunction with the rarely used Track Changes feature that appears on the Tools menu. To work around this limitation, add a period or a space after the word History.
Mar 25
You can lock certain rows or columns in place as you scroll through a worksheet. Position your cursor below any rows and/or to the right of any columns that you wish to freeze in place, then choose Window and Freeze Panes. Unlock the rows/columns by choosing Window, and then Unfreeze Panes.
Mar 25
To close multiple Excel files at once, hold down the Shift key while you click on File,and then Close All.
Mar 25
Decision Models can help you create more effective spreadsheets by understanding Excel's calculation secrets.
Mar 25
To move a worksheet row, select the desired row(s) and then while holding the Shift key down, use the left mouse button to grab the edge of the selection. You can now drag and drop the row where you wish. This technique also works with columns, or even a group of cells.
Mar 25
Buy a copy of John Walkenbach's Excel 2002 Formulas today from Amazon.com. Another book that we highly recommend is Microsoft Excel Version 2002 Inside Out by Craig Stinson and Mark Dodge.
Mar 25
There's much more to Excel's SUBTOTAL function than meets the eye, such as the ability to only sum visible cells. Refer to Excel's online help for more information.
Mar 25
If you purposely need to use a circular reference in a worksheet, make sure that you enable the Iteration option by choosing Tools | Options, click the Calculation tab, then toggle the Iteration checkbox. Otherwise, you'll repeatedly get error messages stating that Excel can't evaluate the formula.
Mar 25
When entering a formula in Excel 97 or 2000, press Ctrl+Shift+A to view the arguments for the function. For instance, typing =DSUM into a cell, then pressing Ctrl+Shift+A will return =dsum(database,field,criteria). In Excel 2002/XP, a screen tip appears automatically once you type the function name.
Mar 25
To make your formulas completely invisible to a user, select the cells, choose Format | Cells, click the Protection Tab, then select the Hidden checkbox and click OK. Next, apply the same color to the text within the cells as your background, i.e. white letters on a white background are invisible. Finally, choose Tools | Protection | Protect Sheet to enable protection, which will prevent the formulas from appearing on the formula bar.