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.




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”

Setting up Sharepoint

I am preparing for moving back into   SharePoint study and need to build some Virtual machines with SharePoint 2007 and 2010 to facilitate this.  I have had an amateur attempt at this a few months back and struggled due to lack of preparation. So this time I decided to start with a search for set up articles and this list is the result.

Continue reading “Setting up Sharepoint”

Sunday Night Music – Matt Munro, Deborah Conway

Continuing the tradition, of no technology for one post on Sunday night.

A few songs this week, vastly different genres, to make up for missing last week.

Matt Munro

You Tube doesn’t do this justice – you need to watch the movie with a good surround sound set up. The music is haunting and beautiful. When I have I the mid life crisis sports car, I will drive to Pilton via Gatton and Ma Ma creek (nice winding roads) with this music on the stereo. Continue reading “Sunday Night Music – Matt Munro, Deborah Conway”

Certification Exam preparation tip

Don’t do your preparation exactly the way I did. Continue reading “Certification Exam preparation tip”

Sydney and Brisbane

A few thoughts from my recent trip to Sydney. It was interesting to visit the Sydney CBD for the first time in 7 or so years. Sydney provides an eye opening experience for a simple country boy from Brisbane. Continue reading “Sydney and Brisbane”

VLOOKUP tip sheet and more

I am often recommending the Microsoft Excel Blog as a useful resource to intermediate and advanced excel users. They have some good VLOOKUP articles there, that are worth passing on: Continue reading “VLOOKUP tip sheet and more”

How do you get a sheet name to print in a Cell?

This question often comes up when I am showing how to link between sheets. Continue reading “How do you get a sheet name to print in a Cell?”

Excel resources for 77-602

General Advice

From my recent experience with another exam certification process I recommend:

  • Learn the software thoroughly
  • Poke around in the features you don’t use much
  • Learn the names of menu options and icons and the sequences to get to key tools
  • Don’t overlook the big picture – when and why  to use a particular tool or function
  • Use the exam objectives to identify your weak areas
  • Do as much hands on as you can to reinforce learning from courses and reading

Continue reading “Excel resources for 77-602”

Over 1000 views

My YouTube channel has had over 1000 views. I know movies of cute puppies will get  this many views will get that many views in 10 minutes… but its a big deal for me. So see Excel, Word, PowerPoint, Acrobat and other tips at http://www.youtube.com/user/TrainAScope

Passed Adobe Exams

Over the weekend I passed the following exams:

  • 9A0-128 Adobe® Captivate 4 ACE Exam
  • 9A0-084 Adobe Acrobat 9 Professional® ACE Exam

Steven Knight

Sunday Night Music #8

Up to my neck in course preparation and exam preparation so, continuing the tradition, of no technology in the last post on Sunday night.

In  the mid-late sixties Dad bought an Isuzu Bellette, maroon, with seat belts front and back (which is why he chose it over the competition, seat belts all round was unusual then). The first song I remember on the push button radio was Georgie Girl… Continue reading “Sunday Night Music #8”

Outlook Exam 77-604: MOS: Using Microsoft Office Outlook 2007

Some notes and resources to assist people preparing for Outlook Exam 77-604:  MOS: Using Microsoft Office Outlook 2007

Continue reading “Outlook Exam 77-604: MOS: Using Microsoft Office Outlook 2007”