http://www.excelblog.net/blog Info about MS Excel Sat, 04 Jul 2009 17:57:38 +0000 http://backend.userland.com/rss092 en An introductory video (youtube) by bytebodger describing the use and creation of pivot tables in Excel 2007. http://www.excelblog.net/blog/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/blog/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/blog/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/blog/2008/08/02/how-to-configure-office-2007-to-save-files-using-the-old-office-97-2003-format/ 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/blog/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/blog/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/blog/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/blog/2006/01/08/excelkbs-forum/ I read an article in the Denver Post this week regarding Sudoku Puzzles.  I then completed several puzzles at websudoku.com. You can create and solve sudoku puzzles using an MS Excel work book from Andy Pope: AJP Excel Information - Su Doku puzzle. I also found a Sudoku puzzle solver at Office ... http://www.excelblog.net/blog/2006/01/05/ajp-excel-information-su-doku-puzzle/ An interesting idea. But how, beyond the neato factor, would one use an Excel sheet with an embedded Google map? Here's my first attempt at using google maps in excel (download below). Currently I can input an address and have a google map of the address displayed in Excel, with most ... http://www.excelblog.net/blog/2005/08/11/google-maps-in-excel/