tag:blogger.com,1999:blog-345719582011-12-14T18:47:41.328-08:00Beginning and intermediate Excel tips and tutorials from noted Excel author Christopher Van Buren.vanburenhttp://www.blogger.com/profile/08137189803084107029noreply@blogger.comBlogger31100tag:blogger.com,1999:blog-34571958.post-1158898575458656132006-09-21T21:12:00.000-07:002006-09-21T21:27:20.656-07:00

A picture is worth a thousand calculations and that's why charting (also known as graphing) is so important for displaying financial and other numerical information. If you get good at making charts in Excel, your intellectual net worth will be "off the chart." So let's get visual and start creating beautiful charts of your data using Excel’s Chart Wizard. In just four easy steps, you can have a

vanburenhttp://www.blogger.com/profile/08137189803084107029noreply@blogger.com0tag:blogger.com,1999:blog-34571958.post-1158511413669333132006-09-17T09:35:00.000-07:002006-09-17T09:44:48.006-07:00

If you're like me, you get tired of tapping the arrow keys to move around inside Windows applications and getting around in Excel is no exception. So I've posted a quick review of the various shortcuts for moving around in Excel and they are especially handy when you need to move long distances within a worksheet. Included is a list of my favorite keyboard commands, sure to get cheers from those

vanburenhttp://www.blogger.com/profile/08137189803084107029noreply@blogger.com0tag:blogger.com,1999:blog-34571958.post-1158508267843888572006-09-17T08:44:00.000-07:002006-09-17T09:02:10.646-07:00

SUM is probably the most commonly used function in Excel or any spreadsheet program. It provides a simple way of adding a set of numbers, especially when those numbers are located in adjacent cells (a row or column of numbers, for example). The SUM function uses the following syntax:SUM(values)The values placeholder can be a list of values, a list of cell references, or a range of cells. Use a

vanburenhttp://www.blogger.com/profile/08137189803084107029noreply@blogger.com0