Tagged Content List

Results for:
sparklines

  • Excel Geek Express—otherwise known as Quick Analysis

    Guest blogger Emily Warn is co-owner of Two Pens , which provides blogging services and teaches business how to write content that grows a social media following. My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number...
  • Apollo 11 & Excel 2010 – Watch History Reimagined for a chance to win

    When you think about it, the ease with which we're able to process and visualize complex mathematics in the digital age is profound. Especially when you consider that it wasn't that long ago that much of this work was done manually. That got us thinking - what would it have been like if Excel had been...
  • Free training: Take the next steps in growing your Excel skills

    In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder...
  • Easy budget management with Excel

    This is post #8 in the Ten Days of Office series celebrating the one-year anniversary of the release of Office 2010 with tips and tricks for getting the most from your Office experience. In today's economy, smart money management is a necessary skill. Whether managing the family budget , planning college...
  • Format column sparkline charts using the date axis and cell merging

    Sparkline charts are great, but there may be times they need a little visual massaging to maximize their usefulness. Consider this scenario: You have a system for which you want to track downtime over the course of a year and (fortunately) it had downtime events in only four of twelve months. Here's...
  • Sparklines: tiny charts show the big picture

      Today’s blog post is brought to you by Judi Hurlock, who writes Excel online training for Office.com.   I write free training courses for Office.com. My job is to learn new features, and the tried and true, and to pass that learning on to you. Recently I heard about a new feature in Excel...
  • 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...
  • One More Sparkline Trick

    In this blog post I’ll walk through one more interesting way you can use sparklines in Excel 2010. In the above example we have the sales for each book category and for each store. While you can’t see the exact numbers in this view, you can get the feel for which sections sell well at the different stores...
  • A Sparkline Trick - Using the Horizontal Axis as a Reference Line

    In this blog post I’ll walk through some of the ways you can use sparklines in Excel 2010 using sample sparklines from the book store demo file: In the above example we have the data for the employee sign-up contest, this is a contest where employees try to get customers to sign-up for a bookstore club...
  • Sparklines – Lining Up the Points

    In this blog post I’ll walk through some of the ways you can use sparklines in Excel 2010 using sample sparklines from the book store demo file: In the above example we have sales for each year, the cost of sales, and net profit for that year all divided by the category of book. One of the things you...
  • Sparkline Axis Options

    In this blog post I’ll walk through some of the axis options for sparklines in Excel 2010 using sample sparklines from the book store demo file: The above sparklines are displaying the number of books by category for each month. The sparklines in this example are giving the history of the count of books...
  • Formatting Sparklines

    In this blog post I’ll walk through formatting sparklines in Excel 2010 using sample sparklines from the book store demo file: The above sparklines are displaying the net profit by month for the three book stores in 2008. The net profit number alone can tell you which stores are doing well, but the sparklines...
  • Adding Some Spark to Your Spreadsheets

    In this blog post I’ll walk through creating sparklines in Excel 2010 using a sample table from the book store demo file: In the table we have the sales for the month of June: a column for total sales for the month, multiple columns for each day’s sales, and rows that break out different book categories...
  • Sparklines in Excel

    Thanks to Sam Radakovitz, a Program Manager on the Excel team, for putting together this series on Sparklines. For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics” , as their inventor Edward Tufte describes them in his book Beautiful Evidence . Sparklines...