This week I have useful links for WebCasts and CSS Tutorials Continue reading “This week’s links”
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”
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”
Calculated Items in Excel Pivot Tables allow you to make categories from existing categories. This Tutorial shoes you how!
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”
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.
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”
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”
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.