Bill Jelen has been running the for years now. For those that haven’t heard of it, it’s a frequently updated video podcast that teaches you Excel, showing everything from the basics of the fill handle to advanced tips around charting, and everything in between … including some recent tricks with linked pictures. Since there’s a lot of great informat.. more »

There was a recent contest with PowerPivot, see the details of the contest here: http://www.exceleratorsquiz.com/challenge.html There were some great PowerPivot reports submitted, including some from our MVPs: Bill Jelen created a “Tag Cloud & SmartArt Updated Via PowerPivot!” report:   Tushar Mehta created a “Visualize US population trends .. more »

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.  But not all of them are supported as PivotCharts.  Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it with pivot data. So, do you give up? .. more »

With the new Windows 7 Touch platform you now have the ability to interact with applications by touching the screen. This paradigm is a huge success in the mobile market and as the hardware evolves, applications utilizing touch input will become more broadly available. We will likely begin to see touch as the primary interaction method for some PCs .. more »

Programmability Improvements in Excel 2010 , here are more details about the Excel 2010 improvements to aid in migrating Excel 4 Macros to VBA. Excel has a macro facility, known as Excel 4 macros (XLM for short) that was the primary macro language prior to the introduction of VBA in Excel 5.0. Most people have long since migrated their Excel 4 .. more »

I discussed how we have enabled workbooks to be calculated on a Windows HPC cluster. In this post, I’ll describe the other piece of HPC integration we have developed in Excel 2010: offloading the calculation of UDFs to a Windows HPC cluster. User defined functions are one of the most popular pieces of Excel extensibility. UDFs enable customers to cr.. more »

Today’s author is Jan Karel Pieterse, an Excel MVP. In this article, he shows the different locations of the form controls in Excel. You can find additional details on how to use these controls on his web site: http://www.jkp-ads.com/articles/controls.asp. Excel 2007 and 2010 In Excel 2007 and 2010, the form controls and control toolbox co.. more »

, I introduced the work we have done with the Windows HPC team to enable customers to calculate Excel models on a Windows HPC cluster. In this follow up post, I go a little deeper into how we can harness the utility and power of Excel 2010 and Windows HPC to solve complex modeling problems. Modeling Complex Systems using Excel 2010 and Windows HPC .. more »

In this post, I introduce the work we’ve done with the Windows HPC team to integrate Excel 2010 with cluster computing. This is a high level overview and I’ll follow up with the technical details in later posts. High Level Overview of Excel 2010 and Cluster Computing High Performance Computing (HPC) is a branch of technical computing that uses supe.. more »

have covered some of the features of PowerPivot for Excel, and shown how PowerPivot helps users build really powerful BI applications right in Excel. We have described some of the PowerPivot for SharePoint features on this blog as well as the , so for this article I will be focusing on the features that we provide to help IT to manage and .. more »

” in the function’s type string – the string where a character code specifies the type of each parameter: The function’s new trailing int argument is used for an asynchronous call handle, and is invisible on the UDF call in the Excel formula. The Excel model author calls it with a single argument, just like the original synchronous function used to .. more »

In today’s article I will outline three features in Office 2010 that improve table interaction in Excel. These feature additions build on the work started Excel 2007, addressing areas with significant customer feedback and further improving the feature area. The first table improvement feature, AutoFilters in sheet headers, builds on work co.. more »

In the last couple posts, we talked about how editing in Excel Web App works, how it’s different than editing in the Excel desktop client, and the kinds of things you can do in the Excel Web App. If you haven’t read about the editing experience yet, start with the Editing in Excel Web App – Part I post. Today I am going to cover how Excel Web App’s .. more »

Today I’m going to continue on with our baseball stats tracking workbook example and talk more about the editing capabilities in Excel Web App. If you haven’t read Editing in Excel Web App – Part I though, I suggest you check it out first. So now you’ve got a great looking workbook with lots of data and formulas. You send it out to your team and.. more »

Before I get started, if you haven’t already read our Excel Web App 2010 Overview , you may want to take a minute to get acquainted with what Excel Web App is all about. In the next two posts I’m going to be talking about the editing capabilities of Excel Web App, and I’ll use the example of creating a simple baseball stats tracking workbook throug.. more »

Way back in November 2009, I wrote a short announcing the two browser-based solutions the Excel team is delivering as part of the Office 2010 wave of products: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities which ship as part of SharePoint Server 2010. Also included are APIs which enable rich business .. more »

Today’s contributor is Sarah Hothersall, Liaison Director at Lyquidity. She’s providing information about the Workbook Statistics add-in, a free tool for Excel users that was created by Sandy Marshall, a Product Manager at Lyquidity, who is in charge of development of ComplyXL for enterprise spreadsheet management. To download this add-in, visi.. more »

Thanks to Christian Stich, the founder of , for putting together this post on the updated Excel Web Services API. The Excel Web Services API that initially shipped with Excel Services 2007 has been updated and expanded for Excel Services in SharePoint 2010. I will address the additions and changes for the Excel Web Services API for S.. more »

Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: . This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks. As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I so.. more »

Todays author is Daniel Wiesenfeld, an Excel and Access Power User who is sharing his Extreme Lookup Collection with us so we can use the Excel User Defined Functions (UDFs) he created to enhance the lookup functionality. His web site is currently under construction and should be available soon. In the Visual Basic Editor, insert a Module and paste .. more »