We came across a great free (and short) online video course for Word 2010 called Get control of page numbers, headers, and footers! In addition to the video, at the bottom of the page you'll find links to an offline version of the course, online documentation, and a quick reference card. Part nine demonstrates how […]
Blog Posts
MachForm Self-Study Materials
We are pleased to present our new MachForm self-study learning package! MachForm is an online application for creating fillable forms and managing the data you collect. The learning package consists of step-by-step lessons, detailed illustrations, and handouts to tell you all about MachForm at York University. How do I get a MachForm account? MachForm is […]
Tiny tip: Insert Random Data in Excel & Word
Have you ever wanted to create fake data to experiment with? Here are a couple of ways to quickly create random data in Excel and Word 2010 so that you can experiment in a safe place when you're learning a new skill or developing a new project. =randbetween(bottom, top) for Excel 2010 In Excel, the […]
Tiny tip! Shade alternate rows in Excel
Shading alternating rows in an Excel spreadsheet is a great way to enhance the readability of your data. If you've ever done this job by manually highlighting and shading cells, you know it's tedious and your careful formatting can easily get messed up when you edit, sort and filter your data. Here are two quick […]
Tiny tip! Concatenate cell contents in Excel
Have you ever needed to combine the data from two columns in an Excel worksheet into one? Use the ampersand (&) to concatenate cell contents. If you want to add additional characters, include them surrounded by double quotation marks. In this example, we've concatenated two columns and added a hyphen (-) in between using this […]
Special Preview: "MachForm in Pictures"
Special preview for our social media subscribers! If you have started using MachForms, have a first look at MachForm in Pictures, one of the documents we've created to help support MachForm users at York. This document is still considered a draft, so any feedback you care to offer would be much appreciated. MachForm in Pictures […]
tiny tip! Make printable calendars
Ever need a simple paper calendar for planning or for jotting notes? It can be hard to find a ready-made calendar template that's just right. We found two web sites that let you create your own calendars -- you choose the settings like paper size, orientation, number of months per page, and then download the […]
Free online learning at Alison.com!
You've met Lynda--now let us introduce Alison! ALISON.COM provides over 600 FREE video-based e-learning courses on workplace skills, available for you to study on your schedule and at your own pace. We've sampled some of their Microsoft Office 2010 courses and think that this resource is well worth consideration for updating and maintaining your technical […]
tiny tip! Edit Word Styles
Edit Word's built-in styles to suit your needs: In the Styles gallery on the Home ribbon, right-click on the name of the style, select Modify from the shortcut menu, and use the dialog to add or remove formatting from the defined style. Everywhere you've used that style in your document will be immediately updated with […]
Technical Learning Options for York Employees
The Centre for Staff Development & Technical Learning offers three main options for York employees wishing to improve their technical skills: Instructor-Led Courses: we regularly offer classroom-based courses for Word, Excel, Access and PowerPoint as well as Lotus Notes and other specialized topics. For more information, including course descriptions, dates, times and registration procedures, please […]
