Browse by Tags
All Tags »
Formulas and functions (RSS)
A few weeks back I wrote several posts on the improvements we have made to Excel’s function library. I’d now like to share with you a draft of a whitepaper we are planning to release when Excel 2010 ships. The whitepaper describes all of the improvements
Read More...
In the past two posts I talked about all of the improvements we have made to the function library in terms of accuracy and consistency. In this post I will describe the UI changes we have made to help users take advantage of these improvements in Excel
Read More...
The second part of the function improvements work we are making for Excel 2010 is to create a more consistent function library. We have implemented a new naming scheme to allow consistent and accurate naming convention for functions. Also, we have added
Read More...
Thanks to Jessica Liu for putting together the next few posts on function improvements. In Excel 2010, we made many improvements to Excel's function library. Excel 2010 will feature an accurate and consistent function library while remaining compatible
Read More...
Today’s author is, Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ There are four primary week numbering systems in use worldwide. Each system has subtle differences
Read More...
Today’s author is Bob Umlas, an Excel MVP since 1994, and author of This isn’t Excel, it’s Magic , a book that is filled with tips and tricks for getting the most out of Excel. This tip is a formula which enables you to access a list of values interspersed
Read More...
I’m sure many of you have built a spreadsheet like this before: you’ve got a table of data; one of the columns in this table contains a formula which references a span of columns in the same table. The number of columns you need to reference may change
Read More...
Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, discusses two different approaches to analyzing data in Excel. Edit: I've attached a file at the bottom of this blog that contains spreadsheets of the examples discussed
Read More...
Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, gives an overview of some new functions in Excel 2007 and along the way shows us how to do some simple expense tracking. Considering the current economic environment, one
Read More...
Today's author, Dan Battagin, a Program Manager on the Excel team, talks about joining two tables in Excel (a.k.a. returning multiple rows for VLOOKUP). Today, we'll take a look at the VLOOKUP function, and work out a way to get around its major drawback
Read More...
Today's author, Charlie Ellis, continues discussing the spreadsheet he built to solve Sudoku puzzles. In my previous post , I walked through a number of formulas for setting up the valid values and solution board. In this post we'll cover using iteration
Read More...
Today's author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles. The spreadsheet can be found in the attachments at the bottom of this post. For those of you who don't already know,
Read More...
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
Read More...
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,
Read More...
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
Read More...
