Staff often need to maintain a spreadsheet of families and enrolments. Common tasks like adjusting or reorganizing such lists can be repetitive. Here are the first of some time-saving methods suggested from our Excel course: Inserting blank columns Re-ordering columns Combining two columns such as first and last name. Inserting blank columns or rows To
Excel Printing Part Two Part 1 covered the main printing options in Excel. Part 2 covers these further Excel print features: Print Entire Workbook Print Titles Print gridlines Print selected chart Print selected table Print region or selection Set Print Area Add to Print Area How to print formulas in Excel Insert header and footer
We have updated the resources for the course with a video recording of the presentation. Please register to view the webinar Duration: 1 hour The video covers the topics from the course: What is WordPress Planning your website Settings, site health & updates Adding pages & media Menu, widgets & plugins Themes Testing &
We have updated the resources for the course with a video recording of the presentation. Please register to view the webinar Duration: 1 hour The video covers the topics from the course: Getting familiar with Excel Working with Cells Formulas Formatting Cells Work Sheets Creating Tables Generating Charts Preparing for Printing
Excel Printing Part One Just like other Microsoft Office files, you can prepare Excel documents for printing by pressing Ctrl-P to access the Backstage View, or by clicking File -> Print. The Backstage View Anything you do to a document in the Backstage View interrupts the editing of the document and you, can review how
Formulas A main use of a spreadsheet is to calculate numbers. The basics of creating a calculation can be as simple as adding two figures in a single cell. To do this we create an expression called a formula in the cell that will display the result. Using numbers Important - there are no spaces
This tip will show you how to insert a bordered picture as a background into Microsoft Word and adjust the margins so you can compose text in Word for a poster or certificate etc. We’ll use an example picture created in the free Adobe Spark, downloaded A4 size, but similar pictures with wide borders can
When your inbox starts to receive full quota alerts you can turn on Auto-Archive. This will free up space and move mail to a local personal folder. For POP and IMAP accounts, Outlook lets you create an Archive folder or choose an existing folder to use as an Archive. You can set AutoArchive by mail
Knowing how to do periodic backups of data like your email is essential. Outlook lets you export mail to a .PST file. You can keep the backup PST file on the computer or copy it to a USB drive that you can take off site etc. Note: This tip explains how to make COPIES of
Click File at top left hand corner. Click Save As. Select the destination where you want to save the PDF to, e.g. Desktop. Click “Save as type” drop down and select PDF. Click Save
