How-To Geek on MSN

Microsoft Excel isn't a database, please stop using it like one

Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated ...
CMS Wire

Excel, SQL, Python: What's Your Data Flavor for Customer Experience?

Taking a look at how marketers can unlock the power of data analysis using traditional tabular software and data languages. Marketers would like to unlock the power of data — but with so many ...
Houston Chronicle

How to Use SQL Statements in MS Excel

With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations. If you have a large data source, such as an Access ...
CMS Wire

SQL Server 2008 R2: Business Intelligence for Excel and SharePoint

An opportunity to speak with Sabrena McBride, Senior Product Manager for SQL Server, provided a lot of insight into what's new in R2. Some of the highlights: Among other things, SQL Server 2008 R2 is ...