Excel tutorial – Copying or moving entire worksheets between workbooks

Posted on April 5, 2012 by Sharyn Baines

I’ve had a number of requests to cover copying entire worksheets between files.  The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data.  Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel. Continue reading →

Posted in Excel, Office 2010 | Tagged , , , , | Leave a comment

Excel tutorial – Working with merged cells

Posted on April 5, 2012 by Sharyn Baines

Ever tried to centre a heading over the top of a number of columns?  It can be a little frustrating, especially when you can’t quite get it to sit as you would like.  Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many.  I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data.  Continue reading →

Posted in Excel, Office 2010 | Tagged , , , , | Leave a comment

Excel tutorial: How to summarize data from multiple worksheets (Part 2 of 2)

Posted on December 8, 2011 by Sharyn Baines

Following on from my previous post on the Excel Consolidate feature I’ve added a video to the Pain in the Tech You Tube Channel showing you how you can use this feature to summarize data from multiple sources using the Pivot Table command. Continue reading →

Posted in Excel, Office 2010, Uncategorized | Tagged , , , | Leave a comment

Excel tutorial: How to summarize data from multiple worksheets (Part 1 of 2)

Posted on December 1, 2011 by Sharyn Baines

I recently ran an Advanced Excel course where I was asked “what is the quickest way to pull data from multiple worksheets into a summary worksheet?”  Excel offers several solutions for consolidating and summarizing data from different worksheets and workbooks. Continue reading →

Posted in Excel, Office 2010 | Tagged , | Leave a comment

Outlook 2010 – disabling the automatic Sending and Receiving of messages

Posted on October 3, 2011 by Sharyn Baines

Have you ever wanted to stop your Outlook messages from being automatically sent as soon as you click the Send button?  Maybe you send out bulk email messages and would like the option of checking your messages before they leave your Outbox. Continue reading →

Posted in Office 2010, Outlook | Tagged , , | Leave a comment

Word training – Adding the document filename and pathname in a Header or Footer

Posted on September 27, 2011 by Sharyn Baines

Today I delivered Office 2010 upgrade training and during the session I was asked to demonstrate how to add the file name and path name of a Word document into a Header or Footer.  Unfortunately this isn’t a simple “one-click” process so I thought it would be an excellent tutorial to share.

Continue reading →

Posted in Office 2010, Word | Tagged , , , | Leave a comment

Outlook 2010 training – Creating a Contact Group / Distribution List

Posted on September 21, 2011 by Sharyn Baines

If you send messages to the same people on a regular basis you may like to create a Contact Group.  Once the group is created you can address messages using the group name and each member of the group will receive a copy.  This eliminates the time consuming process of having to add individual email addresses for each member. Continue reading →

Posted in Office 2010, Outlook | Tagged , | Leave a comment

Excel training – How do I change my Pivot Table back to the classic display?

Posted on September 1, 2011 by Sharyn Baines

If you were familiar with Pivot tables in Excel versions prior to 2007 and 2010 you will have noticed the Pivot Table display is now quite different.  The blue lines are gone, along with the wonderful drag-and-drop feature. Continue reading →

Posted in Excel, Office 2010 | Tagged , , | Leave a comment

PowerPoint training – 3 Presenting with PowerPoint tips you will love!

Posted on September 1, 2011 by Sharyn Baines

If you present using PowerPoint you will love these tips.

Tip #1: Often when I’m presenting there are times when I need to pause my presentation.  For example, a break may be scheduled mid-presentation. Continue reading →

Posted in Office 2010, PowerPoint | Tagged | Leave a comment

Excel training – Excel shortcut tips using Ctrl, Shift and the arrow keys

Posted on August 31, 2011 by Sharyn Baines

This month has been a very busy month and due to the nature of the training courses I have been running I seemed to be sharing this set of tips often.

Hence the creation of this tutorial.  I thought it was about time I created this so every one can benefit! Continue reading →

Posted in Excel, Office 2010 | Tagged , | 5 Comments