About SpreadsheetsGet the latest headlines from the About.com Spreadsheets GuideSite.Excel 2007 CONCATENATE Function- June 23, 2008 Excel 2007 CONCATENATE Function Ted French Excel 2007's CONCATENATE function can be used to join together data from two or more cells in a spreadsheet. For example, it can be...http://spreadsheets.about.com/b/a/000273.htm Basic Microsoft Works Spreadsheets Tutorial- June 20, 2008 Since Microsoft Works is usually part of the bundled software that comes on many new computers, it is often seen as an inferior product and it is either...http://spreadsheets.about.com/b/a/000272.htm Protect Data in Excel 2007 Pt. 2- June 18, 2008 One of Excel's security features is the Protect Data option. What it does is allow you to lock up all or parts of a spreadsheet to prevent accidental or intentional...http://spreadsheets.about.com/b/a/000271.htm Protect Data in Excel 2007 Pt. 1- June 16, 2008 One of Excel's security features is the Protect Data option. What it does is allow you to lock up all or parts of a spreadsheet to prevent accidental or intentional...http://spreadsheets.about.com/b/a/000270.htm Basic Excel 2003 Spreadsheet Tutorial- June 13, 2008 Last post dealt with a basic tutorial on creating a spreadsheet in Excel 2007. Since then I've heard from more than one reader reminding me that there are still people...http://spreadsheets.about.com/b/a/000269.htm Basic Excel 2007 Spreadsheet Tutorial- June 11, 2008 Ive heard from more than one person that their initial reaction the first time they open a spreadsheet program is one of bewilderment. As one person said, There were...http://spreadsheets.about.com/b/a/000268.htm Customizing Excel 2007 Auto Fill Handle- June 9, 2008 Excel 2007 Auto Fill Handle Ted French One of Excel's more useful "Auto" features is the Auto Fill handle. What it does is allow you to easily add preset...http://spreadsheets.about.com/b/a/000267.htm Using the IF Function to Enter Text- June 6, 2008 The IF function is one of the more popular functions used in Excel. One reason for this is that the IF function adds flexibility to a spreadsheet by introducing decision making....http://spreadsheets.about.com/b/a/000266.htm Creating a Drop Down List in Excel 2007 Part 2- June 4, 2008 Creating a Drop Down List in Excel 2007 Ted French One feature in Excel that can save you some time if you have to enter...http://spreadsheets.about.com/b/a/000265.htm Nested IF Functions in Excel- June 2, 2008 One of the more popular functions in Excel is the IF function. Some people, however, shy away from using this versatile function because of its apparent complexity. In doing so,...http://spreadsheets.about.com/b/a/000264.htm |