Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How To   (RSS)
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 | 9 Comments
Filed under:

Attachment(s): TextFilesSalesData.zip
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
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
Wednesday, January 16, 2008 7:54 PM

Personalized Data in Excel Services

Today's author: Steve Tullis, a program manager who works on the Excel Services team. I've received a number of questions over the past months from customers wanting to deploy Excel Spreadsheets to SharePoint, such that when a user opens the page, s/he
Posted by Joseph Chirilov | 7 Comments
Filed under: ,
Monday, December 24, 2007 6:01 AM

Integrating Excel (Services) and PowerPoint with the Microsoft SDK for Open XML Formats

Today's author: Danny Khen, a program manager who works on both the Excel and Excel Services teams. What is this about? Office 2007 introduced new default file formats – Open XML. Excel, Word and PowerPoint take advantage of them. One of the nicest things
Posted by David Gainer | 11 Comments
Monday, December 17, 2007 5:31 AM

Intraday Time Series Charts

Today’s Author: Scott Ruble, a lead program manager on the Excel team who focuses on the area of data visualization. Scott is going to discuss how to create an intraday time series chart. Periodically, users need to create a chart where the data occurs
Posted by David Gainer | 22 Comments
Filed under: ,
Wednesday, December 12, 2007 3:17 PM

Switching Data Sources in Excel 2007

Today’s Author: Howie Dickerman, a program manager on the Excel team. Howie is going to discuss different ways to change data sources in Excel 2007. Prerequisite: This post assumes that you have read the blog post entitled “Managing External Database
Posted by David Gainer | 3 Comments
Wednesday, November 28, 2007 1:46 PM

Tracking Split Costs

Today’s Author: Joe Chirilov , a program manager on the who has done a lot of work on both the Excel and Excel Services teams. Joe is going to discuss a spreadsheet he recently built using Excel 2007. Recently a large group of friends and I went on a
Posted by David Gainer | 12 Comments
Friday, November 16, 2007 4:43 PM

Chart Pattern Fills

Today’s Author: Eric Patterson, a program manager on the Excel team. Eric is going to discuss applying pattern fills to chart data points and includes a sample add-in for this purpose. Overview In Excel 2007, the interface for applying Pattern fills to
Posted by David Gainer | 11 Comments
Filed under: ,
Monday, November 12, 2007 2:30 PM

Manipulating and Massaging Data in Excel

Today’s author: Chad Rothschiller, a program manager on the Excel team. Chad is going to discuss using formulas to 'clean up' data in Excel. Overview Excel is a great tool to use when you need to take data in one format, manipulate it into another format,
Posted by David Gainer | 25 Comments
Friday, November 02, 2007 2:58 PM

Iteration & Conway’s Game of Life

Today’s author: Chris Rae, a program manager on the Excel team. Chris is going to discuss iteration in Excel. Iteration is a powerful feature in Excel, but not one that is familiar to a large number of users. I’m going to use iteration in Excel to create
Posted by David Gainer | 13 Comments
Filed under: ,
 
Page view tracker