Data Mining In Excel
One of the technologies available in SQL Server Analysis Services is data mining.
Excel
Transform data into insightful spreadsheets to help you analyze trends and visualize information.
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.