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 you 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
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
