Blog or Wiki – The Prime Directive – To Share

It occurred to me while explaining wikis and knowledge banks on a recent course, that this blog is more of a wiki than a traditional blog. The ultimate purpose or “the prime directive” of this web presence is to share useful tidbits that I find with you.  The secondary purpose is to act as a portable on-line reference, I can use when asked questions while on site training and consulting.

So lets share some resources…

Found these via discussions in LinkedIn.

For Presenters using PowerPoint

ARE YOUR SLIDES A SLEEP-AID?

This is all about moving from endless bullet points to more effective graphical metaphors. PowerPoint 2007/2010 make this easier than ever before. Features makeovers of  bullets to visual approaches and interviews with known experts on presentations. Continue reading “Blog or Wiki – The Prime Directive – To Share”

Keeping pictures in line with text in Word 2007

Question:  Keeping pictures in line with text in Word 2007/Word 2010

Answer:

  • In the document, click in the text where they want the picture to go
  • Select the Insert tab
  • Choose Picture – insert the picture
  • Having inserted the picture, make sure it is still selected
  • From the Picture Tools Tab
  • Choose Wrap TextSquare (or other choice as required)
  • Don’t use Position – you need to leave position as the default “in line with text”
  • If text is added above the image the image will now stay with its associated text, but with the text wrapping around the image.

Steven

How to do mathematically accurate Venn diagrams in Excel 2007

Question: How to do mathematically accurate Venn diagrams in Excel 2007 (as distinct from the ones in Smart Art)

Answer:  Widely discussed question on the web – there doesn’t appear to be a plug in for this

Looked in the Office Marketplace but couldn’t find anything close (The office marketplace also lacks decent search tools, so I might have missed it…)

There is an article on mathematically accurate Venn diagrams – which details building them up step by step at http://blog.data-miners.com/2008/10/creating-accurate-venn-diagrams-in.html

I haven’t tried it – but it looks like it would work.

Steven

SharePoint reading and resources

Folks,

A very short summary of SharePoint resources for the end user and trainer starting out on SharePoint. Continue reading “SharePoint reading and resources”

Twitter Lists make Twitter manageable. Here are some I made earlier…

Folks

Twitter is an undervalued resource for leads to IT and Business resources. But as I am only able to review my Twitter account every couple of days, I felt I wasn’t getting value out of it, just seeing masses of posts. So I have set up some lists, which filter the accounts you follow by categories you create.  I know I am the last person to discover this feature, but really useful, all the same!

You might find them useful, so here they are: Continue reading “Twitter Lists make Twitter manageable. Here are some I made earlier…”

Setting up ongoing access to another inbox in Outlook 2010 – Is this the best way?

Folks, we all know how easy it is in Outlook  to switch on and off your view of a shared Calendar, once sharing has been set up. You just click a check box, if you still have permission, you see the Calendar.

So we come to sharing Inboxes. In Outlook 2010, once sharing permissions have been given to you, you just go to the File tab and choose Open, Other User’s Folder. Every single time you need to access the Folder.

The question arises – how do we do this on an ongoing basis?

So based on an article on the Microsoft web site and bits I picked up in discussions on this point around the web, I have pieced the following rough outline together: Outline of process for feedback and comment (PDF)

And now I take my first steps into two way conversation using Twitter and LinkedIn. Crowd-sourcing, perhaps. Is the process I have outlined the best way??? – your comments please!

Steven

SharePoint Resources and Technet

Folks

In a recent discussion about preparing for SharePoint study the discussion ranged over Technet and Podcasts and other resources people might find useful. Continue reading “SharePoint Resources and Technet”

Excel Charts – Small and Large values on the same axis

This is a question that came up recently. My first thought was add a secondary axis, but in this case the small and large values were in the same series. I thought there might be something available as a third party add-in for Excel.

Solutions to Try

I did find an answer by Jon Peltier which looks good and gives step by step detail, but also appears to be a lot of work. This article provides links to alternative approaches at tushar-mehta.com and andypope.info – which has a zipped example to look at. If you are seriously  into graphs you should visit Jon Peltier’s blog. Continue reading “Excel Charts – Small and Large values on the same axis”

Four things to check when using Outlook 2010 for the first time.

For people moving to Outlook 2010, I have upload a video to YouTube covering: Four things to check when using Outlook 2010 for the first time.

These are:

1. Spelling
2. Signature
3. Contact Linking
4. Time Zones

I must remember not to gesture while I talk as I record, which leads me to bump the desk and the noise comes up through the microphone (which is on the desk)

Steven

Acrobat Resource (and Acrobat and SharePoint)

In the past I have have posted links to various Acrobat resources. Adobe have now created an all encompassing Acrobat user resource that includes recorded how to video, forums, articles and live seminars. This can be found at http://acrobatusers.com/.

This seminar “Working together with Office and SharePoint” looks interesting. Australian (Brisbane) readers should note that the time translates to Thursday, 17 March 2011 at 3:00:00 AM. I can get up OK  for the 4:30 or 5pm seminars, for this I’ll set my alarm, wish me luck.

Steven

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”

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”

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”