Excel documents are often ‘living’ documents that are intended to be viewed and updated collaboratively. To avoid users introducing errors to your documents, Excel’s protection options can lock or hide cells or formulas. The Protect Workbook command locks the entire document. It isn’t encrypted and can still be viewed but changes require a password. The Protect Sheet command
This guide demonstrates how to password protect a PDF created in Microsoft Word or Publisher. With the file open in Word or Publisher, click on File go to the Backstage view. Select Save As from the menu and navigate to the desired save location. Use the Save as type dropdown to select the PDF file
This tip will explain a method of creating Contact Groups in Outlook from an Excel spreadsheet by importing the data, sorting the new contacts by “Company” and then creating Contact Groups. This method assumes you have a large number of contacts (30+) in an Excel spreadsheet. If you only need to create a smaller number
This tip will explain one of two methods of creating contact groups in Outlook from an Excel spreadsheet. The guide assumes you have the contact details in an Excel spreadsheet sorted into the appropriate groups. Our example uses an Excel spreadsheet of family contact details sorted into each child’s enrolment group. If you need a
Make sure you are making a professional impression by setting up your email username correctly. This tip will explain how. As well as assisting with recognisability, this process also helps to ensure your mail isn’t mistaken for spam. Below are to emails sent from the same account one before editing the account name and one
This guide is a sequel to https://kindergarten.vic.gov.au/tips/planning-your-website/ Once you have the rough structure and hierarchy of your website you can start detailing it out with content. The content refers to the text copy, logos, images, PDFs and other files that you will be populating your site with. In the same way your site’s users have
If you are using a WordPress theme, widget or block pattern with place-holder images you might need make custom or unique icons to replace them. This technique will work for making larger logos too. Before: After: You can do this quickly with the free web app Adobe Cloud Express. Make a free account here: https://express.adobe.com/sp/.
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
This tip will show you how to create simple contact forms for your WordPress site. This example will use the plugin WPForms, one of many form builders you can find in the WordPress plugin store like Contact Form 7, Jetpack and others. You might find your site already has a plugin that handles forms or has
This tip will explain how to restore your WordPress site from a file and database backup. It is the sequel to the Tip - Making a WordPress file and database backup and assumes you have followed those instructions and made a back up copy of the site files and downloaded the database tables as an
