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

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

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”

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

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

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”