http://www.excelblog.net Info about MS Excel for Windows Wed, 08 Oct 2008 22:51:15 +0000 http://backend.userland.com/rss092 en asdfasfasdfsadfasddfasdfasdfasdaf http://www.excelblog.net/2008/10/08/test-2/ An introduction video (youtube) description the use and creation of pivot tables in Excel 2007. http://www.excelblog.net/2008/08/17/create-a-pivot-table-in-excel-2007/ Here is a video from freetutorials (youtube) on using Excel to manage simple databases. http://www.excelblog.net/2008/08/17/using-excel-to-manage-simple-databases/ The REPT function repeats text a given number of times. For example, =REPT("*",10) repeats * 10 times in a cell. You can use this function to create a simple bar for values in multiple cells.  Here is a short video on YouTube: http://www.excelblog.net/2008/08/04/bar-chart-using-rept-function/ Personally, I use Excel 2003 at work and Excel 2007 at home. I am constantly (as in 3 or 4 times a weeks) using Excel 2003 files in Excel 2007. I found this tip at vista4beginners.com showing how to have Office 2007 automatically have files in the Office 2003 format: Configure ... http://www.excelblog.net/2008/08/02/how-to-configure-office-2007-to-save-files-using-the-old-office-97-2003-format/ general http://www.excelblog.net/2008/05/17/test/ At work I use pivot tables nearly every day. My work does not involve analyzing business or financial data and still I find pivot tables very useful in manipulating data sets, performing on-the-fly calculations, and preparing final reports. So, what is a pivot table? A pivot table is a data summarization tool ... http://www.excelblog.net/2008/05/12/pivot-tables-a-powerful-tool/ Name Manager, now at Version 4, is a Excel Add-In that I find useful. Many times I have had to deal with workbooks with more than 100 names, many that are no longer valid. Name Manager helps manage such a mess. If you are in need of a ... http://www.excelblog.net/2008/04/01/name-manager-for-excel/ An Excel file saving utility from Jan Karel Pieterse. Autosafe.zip (28 February 2007, 150k, Downloaded: 362 times) Version 3.5 of Autosafe enables use in environments with long paths/filenames. The standard Autosave (note the spelling) utility that ships with Excel just saves workbooks at a set interval, overwriting the file ... http://www.excelblog.net/2007/03/03/version-35-of-autosafe/ A new discussion forum on Excel from XL-Dennis : ExcelKB's discussion forum. What ExcelKB’s Forum is about: • Discussions about software based projects and documentation, both in general terms and more specific projects terms – Best Practical Practice. • Controlling Excel through automation with developing tools like classic VB and VB.NET/VSTO et al. • ... http://www.excelblog.net/2006/01/08/excelkbs-forum/