Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Formulas and functions   (RSS)
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
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
Tuesday, August 14, 2007 8:02 PM

Christian Stich on Excel Services: Financial option valuation implemented with Monte Carlo simulation using multithreaded User Defined Functions (UDFs)

Today’s author: Christian Stich, a program manager on the Excel Services team who likes to combine his finance and engineering backgrounds. Christian is going to talk about building a multithreaded UDF for Monte Carlo simulations and using it for options
Posted by David Gainer | 8 Comments
Monday, October 23, 2006 5:25 PM

Excel Performance – New Whitepaper Available

In a recent post, I mentioned there were more Excel 2007 whitepapers coming. Today a whitepaper was released on Improving Performance in Excel 2007 . Here is the summary from the MSDN site: Summary: Learn about the increased worksheet capacity in Microsoft
Posted by David Gainer | 2 Comments
Tuesday, September 05, 2006 11:02 PM

Referencing Tables From RefEdit Controls

SamRad is back with another guest post. Today Sam is writing about another feature he worked on - supporting table referencing from places other than the formula bar. Enjoy. Dave posted about Tables and the new "structure referencing" feature in previous
Posted by David Gainer | 14 Comments
Tuesday, July 18, 2006 6:43 AM

Fun With Tables

A few weeks ago when I asked readers what they wanted to see in the way of content over the next few months, a few people suggested some discussion about everyday use. Accordingly, I am going to write today about some things I was doing with Tables in
Posted by David Gainer | 13 Comments
Wednesday, February 15, 2006 10:55 PM

CUBE Functions 4: Deconstructing the PivotTable

Actually, before I talk about data connections, I want to cover one other way that users can author OLAP formulas ... users can create a PivotTable bound to an OLAP cube and then use the Field List to quickly add all the fields that they care about to
Posted by David Gainer | 7 Comments
Thursday, February 09, 2006 4:00 PM

CUBE Functions 3: Formula AutoComplete revisited

Previously when discussing CUBE functions, I showed a couple of examples of reports based on OLAP data that could be built using CUBE functions. Now I’d like to explain how we’ve done something very special with Formula AutoComplete to make it easy to
Posted by David Gainer | 11 Comments
Monday, February 06, 2006 4:10 PM

CUBE Functions 2: A Few Examples

Last time, I explained the seven new CUBE functions that are available in Excel 12 to fetch data from Analysis Services cubes. With the theory that a picture is worth a thousand words, I would like to walk through a few examples that illustrate how these
Posted by David Gainer | 4 Comments
Thursday, February 02, 2006 8:59 PM

The Excel 12 Blog Rides Again, or “CUBE Functions Part 1”

OK, I am freshly back from a fascinating couple weeks of visiting a number of customers (thanks to all you that spent time with us over the last few weeks), so it is time to get back to talking about Excel 12 features. We’ve already talked about using
Posted by David Gainer | 13 Comments
Friday, October 21, 2005 4:38 PM

Formula building improvements Part 4: Defined Names

Defined names are a very useful tool for authoring formulas. Defined names allow users to name cell ranges, formulas, and values and refer to those names in their formulas. Used in formulas, defined names make formulas easier to read and more robust.
Posted by David Gainer | 33 Comments
Thursday, October 20, 2005 2:28 PM

Formula editing improvements Part 3: new functions

In addition to improving the formula editing UI in Excel 12, the team has spent some time adding to Excel’s function library. Over the years, customers have found new ways to combine and leverage the functions in Excel to build all sorts of things, but
Posted by David Gainer | 23 Comments
Wednesday, October 19, 2005 2:59 PM

Formula editing improvements Part 2: Formula AutoComplete

Last post I covered improvements we made to a long-time fixture of the Excel UI - the formula bar. Today I’d like to introduce a feature that is brand new for Excel 12. The feature is called Formula AutoComplete, and it is designed to make users more
Posted by David Gainer | 32 Comments
Tuesday, October 18, 2005 3:31 PM

Meet the Excel 12 formula bar, or “don’t hijack my grid!”

I’d like to shift gears a bit and talk about the work we’ve done to improve the experience around building and editing formulas. For most customers, this is a core activity in their daily use of the product. In planning for this version of Excel, we took
Posted by David Gainer | 23 Comments
Wednesday, September 28, 2005 1:22 PM

The big picture ...

Before I carry on digging into the details of the new and improved features in Excel 12, I wanted to make sure everyone had a good sense for the work we’ve done in this version. When we were planning Excel 12, we spent a significant amount of time talking
Posted by David Gainer | 18 Comments
 
Page view tracker