Data Mining In Excel
One of the technologies available in SQL Server Analysis Services is data mining.
Refine results
Product
Audience
Publish date
-
-
Unusual (but cool!) Uses of Excel
Many of you who have been using Excel for a long time have most likely seen some of the creative, interesting, and rather unusual uses of Excel that people have conjured up. -
Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation – Part 1/2
Today’s author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles. -
Printing Envelopes Using Excel and Word
Excel allows you to define names that apply to a range of cells in the worksheet. -
Excel VBA Performance Coding Best Practices
Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. -
Week Numbers in Excel
Today’s author is, Ron de Bruin, an Excel MVP. -
Use the VBA SaveAs Method in Excel 2007
Today’s author is Ron de Bruin , an Excel MVP. -
New and Improved Solver
Thanks to Eric Patterson for putting together this post. -
Adding Every Other Cell in a Column
Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. -
Build your own board game, create playing cards
We recently published an energy calculator template from one of our content partners in Canada, Microsoft Home Magazine. -
Scatter charts with PowerPivot
Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. -
Running a SQL Stored Procedure from Excel (No VBA)
In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure.