PowerPivot for Excel 2010 and SharePoint 2010

On Friday, I was catching up on my podcasts and listing to Hilton Giesenow‘s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.

What got my attention was  PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table analysis.

PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Window Tools
Tools Shown in PowerPivot for Excel window

Continue reading “PowerPivot for Excel 2010 and SharePoint 2010”

MYOB Australia Live Accounts

Just a quick post on a topic I promised to cover earlier on….

Opened a trial account for MYOB Australia Live Accounts.

Learned enough to realise that a change to book keeping in the cloud should be made at the end of the financial year. So I will revisit this in June/July 2011 and report back then.

Steven

LinkedIn Groups – as a source of useful resources for E-Learning, SharePoint

I had initially thought of LinkedIn as a resource to make my profile available to prospective clients. I have thought of  Twitter as the more useful tool for resources and research.

Then I learned about LinkedIn Groups.

Maybe I was wrong to underestimate LinkedIn. Continue reading “LinkedIn Groups – as a source of useful resources for E-Learning, SharePoint”

Sunday Night Music

Continuing my practice of the last post on Sunday night reflecting my varied (eccentric?) musical taste and not involving computers at all…

Rooftop Singers – Walk Right In Continue reading “Sunday Night Music”

Snipping and Screenshot Tools

For people needing to put together system user guides and training notes, who need to get screen captures , Windows 7 offers the Snipping Tool and Office 2010 has the Screenshot tool. These two movies briefly show how to use them. Continue reading “Snipping and Screenshot Tools”

More Adobe Captivate Links to Resources

To help new Captivate users I have previously gathered useful links here, Existing Summary of Captivate Links. This post is an update of recent links and resources. Continue reading “More Adobe Captivate Links to Resources”

Free Simple SharePoint 2007 User Guide

Folks,

As a learning aid for myself and to help with preparation for a course I put together a basic guide to common tasks in SharePoint 2007. This a draft and probably wont go much further as I am now moving into SharePoint 2010.  Continue reading “Free Simple SharePoint 2007 User Guide”

Resources to help you when using CDO.sys to create email with ASP and VbScript

Introduction

Currently working on a simple form that emails to a nominated email address which uses  Classic ASP and VbScript. I normally use JMail or similar components installed on IIS depending on what the hosting service has available.

In this case I am using CDO.sys which is native to IIS to achieve the same result.

So having gathered some useful CDO.sys resources and samples, I thought I’d share them via my blog. Continue reading “Resources to help you when using CDO.sys to create email with ASP and VbScript”

Sunday Night Music

Continuing my practice of the last post on Sunday night reflecting my varied musical taste and not involving computers or IT in any way, this is from the Western, Rio Bravo. Continue reading “Sunday Night Music”

Windows 7 Features and coming posts

Windows 7 New Features

Running some Windows familiarisation  sessions shortly, so I thought I’d share some resources and my favourite aspects of Windows 7. Continue reading “Windows 7 Features and coming posts”

Using Outlook Contacts In Word

Here are three ways to use Outlook Contacts in Word

Method One

In a Mail Merge to generate a batch of letters or labels – see full article at Microsoft.

Continue reading “Using Outlook Contacts In Word”

Outlook – removing auto complete entries from “to:”

When composing an email in Outlook, you often have old or incorrect addresses showing up when you start typing in the To box. This article at Office.com shows how easy it is to remove these.

http://office.microsoft.com/en-us/training/change-what-shows-up-in-autocomplete-RZ001050596.aspx?section=7

Regards

Steven

SharePoint 2010 Datasheet view not available

Currently spending some quality time with SharePoint  2010. I ran into a problem with the datasheet view. Found a couple of useful blogs as well as the solution. Continue reading “SharePoint 2010 Datasheet view not available”