Blog

Excel

Your Best Friends in Excel

When dealing with large amounts of data, save time by learning about your "best friends" in Excel. Your best friend today is the "vlookup". Download the practice workbook and follow along. You will learn how to combine important information from multiple spreadsheets with just a few clicks. Download practice workbook (Compatible with MS Excel 2007 or higher). read more

Posted in Excel, Productivity, tutorials | Post Comment

Excel Functions - SumIF AND Combined

Excel Sumif
Maybe you'll laugh now that you know I just switched from Microsoft Office Professional 97 (wince - don't throw tomatoes) to the new 2007 Office Suite. Literally within minutes I was loving the new features of Word and especially Excel. We build a lot of websites, but spreadsheets come into play a lot when prepping/scrubbing data for database insertion or just practical business applications. There are actually some new functions that make spread sheeting less of a chore and actually a bit enj.... read more

Posted in Excel, tutorials | Post Comment

web design corner image