ITS training resources

Please feel free to download any of the following documents.   All documents are in PDF format.  I will be adding new links from time to time so please check back as time permits.

Drop in sessions will allow you to ask software related questions, discuss ideas for development, or practice your skills in a stress free environment.  Registration for the drop in sessions is not required.  

Windows 7

• Windows 7 overview
• Displaying images as thumbnails 
• E-Mailing web based links using IE8                           

Lotus Notes 8.5

• Lotus Notes overview
• Lotus notes iNotes quick guide
• Lotus Notes archiving
• Opening shared mail applications using iNotes
• TeamRoom
• Frequently asked questions
• The 'All Documents' view explained
• Notes failover
• Type ahead fix

Word

• Tips and Tricks
• List tips
• Table tips
• Password protection
• Adding controls
• Spellchecker error solution
• Styles
• Creating styles
• Disable automatic numbering and lists
• Footnotes and endnotes
• Apply a different header or  footer to the first page of a document
• Odd & even headers/footers
• Restart page numbering at one
• Highlight every instance of a word
• Including filename and path in header or footer
• List  creation
• Mail merge with labels
• Envelopes
• Printing a range in  a merged document
• References
• Repeat table headings on multiple pages
• Section breaks defined
• Section breaks and header or footers
• Default line spacing
• Snap to grid
• Inserting a table of figures
• Track changes
• Using formulas in tables
• Watermarks
• Watermark print issue solution
• Building blocks
• Merge document using two seperate printer trays

 Access

• Creating a simple database
• Joining tables
• Solving the many-to-many relationship dilemma
• The navigation pane
• Tabbed documents
• Filtering reports
• Using the lookup wizard

Excel

• Track changes
• Conditional formatting
• Printing column labels on multi-page workbooks
• Creating a data table
• Creating a pivot table
• Creating a chart
• Creating a chart with two vertical axis
• Linking workbooks
• Protecting a workbook
• Protecting portions of a worksheet
• Using the substitute function
• Using the sumif function
• Using the sumprod function
• Using the countif function
• Using the vlookup function
• Using the rank function
• Using the match function
• Using partial absolute reference
• Using the transpose function to copy data
• Hiding duplicate data

PowerPoint

• Using the slide master
• Applying themes
• Advance slides using timings
• Printing handouts

OneNote

• OneNote features

Groove

• Groove overview

Adobe Acrobat

• Creating a portfolio
• Printing a portfolio
• Forms creation
• Creating a multi-line text field
• JavaScript required for validating mandatory form fields
• Editing PDFS
• Bookmarks
• Creating and adding signatures

 Visio

• Creating an organizational chart
• Creating a project schedule

Keypass Password Safe

• Keypass overview

 Nero ShowTime

• Best usage

Windows Media Player

• Best usage

PCL vs Postscript Printing

• Overview                                                                     

Bits vs. Bytes

• Storage terminolgy defined                       

Safe Browsing

• Safe browsing tips    

 Publisher

• Using a mail merge        

Using adminweb

• File transfer using adminweb

If you have any suggestions for training or inquiries please feel free to contact me by phone at 440-8740 or via e-mail at vwinsor@mtroyal.ca.