This week’s links

This week I have useful links for WebCasts and CSS Tutorials Continue reading “This week’s links”

Store and recall frequently used text in Word 2007

This short video shows how to store and recall frequently used text in Word 2007 Continue reading “Store and recall frequently used text in Word 2007”

Grouping by Dates in Pivot Tables Excel 2010/2007

How to summarise data in Pivot Tables using Dates. Very useful if you need to summarize point of sale data, maintenance or expense records by month, week or fortnight (14 days) Continue reading “Grouping by Dates in Pivot Tables Excel 2010/2007”

How to Create Calculated Items in Pivot Tables

Calculated Items in Excel Pivot Tables allow you to make categories from existing categories. This Tutorial shoes you how!

Continue reading “How to Create Calculated Items in Pivot Tables”

Diagrams from Word 2003 to Smart Art

A quick set of links to help those moving from Word 2003 to Word 2007 or Word 2010, who have diagrams to convert to Smart Art. Continue reading “Diagrams from Word 2003 to Smart Art”

Harvard Style Referencing in Word 2007/2010

Following a recent question from a Word 2007 Advanced session,  where people liked the Referencing feature in Word 2007 (and its there in 2010 as well) but were disappointed that it didn’t support the Harvard system that local colleges and universities use, I decided to dig further.

Continue reading “Harvard Style Referencing in Word 2007/2010”

xps – How to view .xps files

XPS – XML Paper Specification files and how to view them.

I have used the XPS format to print a copy of a web page for later offline reading when I haven’t had Acrobat Pro installed. I have then been able to read them via Internet Explorer 8.

On a recent course, I was asked how to read XPS files. To my surprise, and possibly Microsoft’s, someone was actually using XPS. Continue reading “xps – How to view .xps files”

Calculated Fields in Pivot Tables

The following short movie illustrates preparing calculated fields in pivot tables in Excel 2010. This technique is very similar for Excel 2007.  This is the first of a short series on Pivot Tables that I am preparing.

Requires Flash Player 9 or better. Continue reading “Calculated Fields in Pivot Tables”

Conditional formatting of columns in Excel 2007

We can easily do conditional formatting of columns in Excel 2007. A common questions is how to format a row based on a value in the row. Watch this movie to see how.

This is an older movie prepared in Captivate 4, exported as an avi and then converted using Adobe Media Encoder, before being uploaded to You Tube. It was prepared to answer a support call from a course.

Continue reading “Conditional formatting of columns in Excel 2007”