Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Thursday, May 08, 2008 10:07 PM

PivotTables: Calculated Items

Today's author: David Gainer, a Program Manager on the Excel team. PivotTables are designed to help users make sense of large amounts of data by providing an easy way to build a summarized report. In addition, PivotTables can be rearranged easily, so
Posted by Joseph Chirilov | 7 Comments
Filed under: ,
Wednesday, April 30, 2008 1:41 PM

Append Multiple Text Files into a Worksheet without Code

Today's author: Mark Gillis, an Excel and SharePoint writer, who's been through six versions of Office, survived to tell the tale, and picked up a thing or two along the way. Excel doesn't have an easy way to append multiple text files into one worksheet
Posted by Joseph Chirilov | 10 Comments
Filed under:

Attachment(s): TextFilesSalesData.zip
Tuesday, April 22, 2008 3:37 PM

Improving Sheet Selection

Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago I got a question through email asking if we could change the 'grid selection color' in Excel. Or at least I called it 'grid selection
Posted by Joseph Chirilov | 14 Comments
Filed under:

Attachment(s): Selection-Shapes-and-Userform.zip
Friday, April 18, 2008 2:50 PM

Building the Excel Media Player – Part 3

Last post we talked about how to use Excel as a flexible development environment and touched on how to use ActiveX Controls to enhance your solution and using tables programmatically to manipulate data. In this post we are going to drill into how to add
Posted by Joseph Chirilov | 1 Comments
Filed under: ,
Wednesday, April 16, 2008 8:31 PM

Building the Excel Media Player – Part 2

Last post we talked about how to use Excel as a flexible development environment and touched on the benefits of using Office graphics to build your UI. This post goes into how to use ActiveX controls in Excel and how to contain and manipulate data in
Posted by Joseph Chirilov | 2 Comments
Filed under: ,
Monday, April 14, 2008 5:39 PM

Building the Excel Media Player – Part 1

Today's author, Jon Adams, a Tester on the Excel team. A copy of the spreadsheet discussed in this post can be found as an attachment at the bottom of this post. As you are probably well aware, Excel is a very versatile tool and is often used in ways
Posted by Joseph Chirilov | 5 Comments
Filed under: ,

Attachment(s): MediaPlayer.xlsm
Thursday, April 10, 2008 3:46 PM

Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”

We sometimes get mails from our customers claiming to have found a calculation error in Excel, when in fact the calculation isn't wrong, but the side effects of binary floating point precision make it seem that way. Today's author: Jessica Liu, a Program
Posted by Joseph Chirilov | 13 Comments
Wednesday, April 02, 2008 11:44 AM

Statistics and Business Data: Detecting Unexpected Values

Today's author, Gabhan Berry, a Program Manager on the Excel team. A copy of the spreadsheet discussed in this post can be found as an attachment at the bottom of this post. Introduction When faced with a table of data, what kind of techniques do we employ
Posted by Joseph Chirilov | 3 Comments
Filed under:

Attachment(s): Binomial Distribution.xlsx
Wednesday, April 02, 2008 9:11 AM

Office Open XML, a.k.a. IS 29500

As everyone who has followed this blog already knows, we introduced a new file format with Office 2007 (and Excel 2007) with the extension .xlsx called Office Open XML (OOXML). Microsoft submitted the new file format to Ecma International, and in December
Posted by Joseph Chirilov | 0 Comments
Filed under:
Friday, March 28, 2008 10:55 AM

Shadows on Charts and Cells in Excel 2007

Today's author, Helen Hosein, a Program Manager on the Excel team. Certain shadows created in Excel 2003 look different Excel 2007. In particular, you might notice that your old cell shadows, as well as shadows on things like Chart Titles might look a
Posted by Joseph Chirilov | 7 Comments
Filed under: ,

Attachment(s): CellShadows.xlam
Monday, March 24, 2008 4:11 PM

Setting up Excel Services to Refresh Workbooks When Opened.

Today's author, Pej Javaheri, a Product Manager on the Excel Services team, talks about one of the more common configuration questions we hear about from customers. One of the challenges in sharing Excel workbooks is ensuring that the right people see
Posted by Joseph Chirilov | 3 Comments
Monday, March 10, 2008 9:20 AM

SharePoint 2008 Conference Recap

The BI Blog does a quick recap of the SharePoint 2008 Conference that just passed with particular emphasis on the popularity of the Excel Services session: Dan Parish, from the Microsoft Excel Services team, presented how you can extend the capabilities
Posted by Joseph Chirilov | 0 Comments
Thursday, March 06, 2008 1:41 PM

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. I'm talking about things like writing the Pac-Man game completely in Excel ,
Posted by Joseph Chirilov | 15 Comments
Wednesday, March 05, 2008 12:45 AM

Handling Workbook Dependencies using Excel Services

Today's author, Sanjay Kulkarni, a Program Manager on the Excel Services team. We have heard from several customers about scenarios where they have workbook dependencies. So the output of one workbook is used in other workbooks for calculations. The dependencies
Posted by Joseph Chirilov | 3 Comments
Attachment(s): WorkbookDependencies.zip
Tuesday, March 04, 2008 6:48 PM

Example file for PivotTable / Data Validation Trick

Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for
Posted by Joseph Chirilov | 3 Comments
More Posts Next page »
 
Page view tracker