Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Excel 2010 (RSS)

Browse by Tags

  • How it's Made: Tower Defense - a Game in Excel 2010

      This blog post is brought to you by Karen Cheng a Program Manager on the Excel team.     In today's post, we'll show you how the arcade game Tower Defense was created in an Excel spreadsheet (see a video of the game being played here ).  In this game, creeps move toward your castle. You must defend it by placing towers which shoot at the creeps. The more creeps you kill, the more money you get to buy and upgrade your towers. To play, you'll need - · To download the...

  • 10 Days for Office 2010 Series – Reviewing the Dow Jones Industrial in Excel 2010

    Today’s post was written by Excel MVP Nate Oliver. Excel 2010 presents traditional numerical analysts with new and old tools; today we’ll explore two of them. The difference is that the first shall be what we call qualitative, and the second, quantitative. As a real-world example, on a really hot day, qualitative could mean hot, while quantitative could mean 100F. We shall explore both, with Excel 2010, with respect to the Dow Jones Industrial Average (DJIA). Read more here... Read More...

  • Excel 2010 Mobile Post

    Over on the Office Engineering blog they have a post describing Excel Mobile 2010: “In our previous post entitled “Mobility in Office 2010” we briefly described the office applications available on your phone that would keep you productive on the go. In this post we will deep dive into Excel Mobile 2010, which supports over 100 of the formula functions available in Microsoft Excel 2010. In addition, its support for creating and displaying all of the common chart types brings the visual experience...
    Filed under:

  • More Excel 2010 Posts

    There’s some more Excel news, ads, and articles showing up.  Check out this post on the Office blog to see a couple of videos on the introduction of sparklines to Excel, one made by us and another by MrExcel … and since we’re on the topic, below is a couple of recent videos from MrExcel that feature sparklines:   Episode 1195 - Add shading to your sparklines to specify acceptable ranges. Episode 1194 – Add labels to your sparklines. Read More...
    Filed under:

  • More about collaborative editing in Excel Web App

    Thanks to Dan Parish for writing this blog post. In today’s post, I’m going to delve into some of the finer details of collaboration using Excel Web App. If you haven’t already read Collaborative Editing Using Excel Web App however, please start there. It goes over what is supported, how it works, our presence UI, as well as some interesting collaborative scenarios that this feature opens up. Today’s post is really a “Part II” to that post. Multiple Browser Windows Excel Web App allows you to collaborate...
    Filed under: ,

  • PowerPivot Alpha Geek Challenge

    There was a recent contest with PowerPivot, see the details of the contest here: http://wildfireapp.com/website/6/contests/19877?order=recency&view_entries=1   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 over the last 150 years” report: Check out all of the entries here: http://wildfireapp.com/website/6/contests...
    Filed under: ,

  • Windows Touch & Excel 2010

    Thanks to Robin Wakefield for putting together this post on touch. 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 such as wall mounted displays used as a kiosk as well as to enhance the experience...
    Filed under: ,

  • Migrating Excel 4 Macros to VBA

    Thanks to Eric Patterson for writing this blog post. As promised in our 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 macros to VBA; however, some Excel 4 macro capabilities were missing from VBA, which...

  • Offloading UDF’s to a Windows HPC Cluster

    Thanks to Gabhan Berry for putting together this series on high performance computing. In my previous post 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. Overview User defined functions are one of the most popular pieces of Excel extensibility. UDFs enable customers to create their own worksheet functions...

  • Calculating Excel Models on an HPC Cluster

    Thanks to Gabhan Berry for putting together this series on high performance computing. In a previous post , 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 Mathematically modeling complex problems is far...

  • Excel 2010 and High Performance Computing

    Thanks to Gabhan Berry for putting together this series on high performance computing. 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 supercomputers and cluster computing to solve computationally intensive...

  • Management Features of PowerPivot for SharePoint

    Thanks to John Hancock from the PowerPivot team for putting together this post. Previous articles 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 PowerPivot blog , so for this article I will be focusing on the features that we provide to help IT to manage and understand the self-service BI activity. Self...

  • Programmability Improvements in Excel 2010

    Thanks to Danny Khen for putting together this post. What’s new? Excel has been a platform for developing business solutions for a long time now. Developers write code to customize and extend Excel in many ways – automating Excel operations, user interface customizations, data entry forms and extending Excel formulas with user defined functions, to name some key ones. Many developers create very complex applications, which have demanding requirements and push Excel to its limits, so developers are...

  • Table Improvements in Excel 2010

    Thanks to Ben Rampson for putting together this post. 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 completed in the previous version of Excel. In Office 2007, when the table header of a selected table is scrolled...
    Filed under: , ,

  • Collaborative Editing Using Excel Web App

    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 editing functionality enables easier collaboration on spreadsheets among multiple authors. Collaborative Editing – What’s That? Picture this scenario...
    Filed under: ,
1 2 3 4 5 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.