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.
Refine results
Product
Audience
Publish date
-
-
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. -
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. -
Adding Every Other Cell in a Column
Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. -
New and Improved Solver
Thanks to Eric Patterson for putting together this post. -
Use the VBA SaveAs Method in Excel 2007
Today’s author is Ron de Bruin , an Excel MVP. You can find more useful tips and links to Excel add-ins at his website: http://www. -
Week Numbers in Excel
Today’s author is, Ron de Bruin, an Excel MVP. -
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. -
Printing Envelopes Using Excel and Word
Excel allows you to define names that apply to a range of cells in the worksheet. -
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. -
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. -
Data Mining In Excel
One of the technologies available in SQL Server Analysis Services is data mining.