myspace live counter
Browse by Tags - Geeky Girl - Site Home - TechNet Blogs

Browse by Tags

Tagged Content List
  • Blog Post: BI Bites 1: Sparklines

    This demo starts a new series of videos showing some of the capabilities of Microsoft's BI stack in bite sized chunks. This video shows how easy it is to add a simple chart to a table by using the new Sparkline feature of Excel 2010.
  • Blog Post: Better with Office - introduction

    SharePoint is part of the Microsoft product stack. This doesn’t mean that it’s just another item on a Microsoft price list. What it means is that it’s designed to work with the other products Microsoft produces. In other posts, I’ve talked about using InfoPath and SharePoint together, but that’s not...
  • Blog Post: Better with Office - Metadata

    What is metadata? The simple definition is that it’s data about data. In the case of SharePoint, it’s information about files and documents stored within SharePoint. There are some bits of metadata that are included as standard, such as who created a document, who last edited it, where in SharePoint...
  • Blog Post: BI Bites 21: PowerPivot Gallery

    This video continues my BI Bites series, showing bite-sized demos of Microsoft's Business Intelligence solutions. Here I show the PowerPivot gallery feature of the PowerPivot add-in for SharePoint Server 2010. This file is available for download from my SkyDrive .
  • Blog Post: Better with Office - Data Connection Libraries

    Previously in this series, I’ve talked about general Office documents, which might be Word files, PowerPoint slide decks and so on. In this post, I’m going to go a bit more specific. I’m going to talk about data connection libraries and how they are they can accessed using Excel 2007. A data connection...
  • Blog Post: BI Bites 6: Excel Dashboards

    This video continues my series of bite sized Business Intelligence demos. In this demo, I show how to create a dashboard in SharePoint 2010 to display parts of an Excel workbook.
  • Blog Post: BI Bites 25: Excel Web App

    This video continues my series of Microsoft Business Intelligence demos. In this demo, I show the Excel Web App, the browser-based version of Excel available through SharePoint and Windows Live. I show some of what you can and can't do in this cloud-based version of Excel. This video is available...
  • Blog Post: InfoPath and Excel Services

    Given that I spent a ridiculously long time trying to get an InfoPath form to interact with a spreadsheet published through Excel Services, I thought this was a suitable subject for a blog post. If I stop someone else feeling like they want to beat themselves to death with their own keyboard, I will...
  • Blog Post: Office 2010 beta is here!

    It’s time to have a play. The public beta has launched and now you can get hold of Office 2010 and SharePoint 2010. You can download it from www.microsoft.com/2010 and try out some of the new features such as: · Conversation threading in Outlook · Improved rules management in InfoPath · The...
  • Blog Post: BI Bites 24: PowerPivot Management Console

    This video continues my series of short business intelligence screencasts. In this demo, I show the Management Dashboard for PowerPivot in Microsoft SharePoint Server 2010. This video is available for download from my SkyDrive .
  • Blog Post: BI Bites 5: Publish to Excel Services

    This video continues my series of demos showing the Microsoft BI offering in bite sized chunks. In this video, I show how to publish items in an Excel workbook to Excel Services in Microsoft SharePoint Server 2010.
  • Blog Post: BI Bites 20: Introducing PowerPivot

    In this video in my BI Bites series, I introduce the new in-memory analytics tool from Microsoft: PowerPivot. I show the Excel add-in and the new tab as well as introducing the range of data sources that can be used in a PowerPivot application. This file is available for download from my SkyDrive...
  • Blog Post: SharePoint for Business Intelligence

    Final video in this series showing how SharePoint can be used to solve a range of business problems. This demo shows how SharePoint can be used for Business Intelligence.
  • Blog Post: BI Bites 22: PowerPivot Charts

    This video continues my series of demos showing Microsoft's Business Intelligence offerings in bite-sized chunks. This demo shows a PowerPivot application in Excel 2010 and how to build a pivot chart based on data in a range of sources. This video is available for download from my SkyDrive .
  • Blog Post: BI Bites 23: PowerPivot Data Connections

    This video continues my series of demos showing Microsoft's Business Intelligence technologies. In this demo, I show how to create a data connection to a SQL table from a PowerPivot file and how to use that data in a pivot chart containing information from other sources. This video is available...
  • Blog Post: It's not piracy - it's the Ultimate Steal

    If you're a UK higher education student or staff member, you can get Microsoft Office Ultimate 2007 for the ridiculously cheap price of £38.95 - if you buy before 30th June 2009. Just go to The Ultimate Steal , register with your academic email address and buy online.
  • Blog Post: Office in the Clouds

    A version of Office Web Apps is now available to SkyDrive users for free! If you log into your SkyDrive, you’ll now see a little section informing you that you can create new Office documents with the familiar client logos. Clicking on one of these takes you to a new page to name your...
  • Blog Post: BI Bites 2: Data Bars

    This video continues my series of demos showing Microsoft BI features in bite sized chunks. This demo shows one of the improvements to conditional formating in Microsoft Excel 2010: negative data bars.
  • Blog Post: Better with Office - Workspaces

    Continuing this series of blog posts, I’m going to talk about document workspaces. The idea behind these is that sometimes a document needs multiple people working together on it. A document workspace is a site in SharePoint that can be used for collaboration. The standard template for this site includes...