Search results

How to update or change your Office 365 account’s time zone
  • To change time zone for your office 365 account, you must first access your emails via mail.chi.ac.uk (otherwise known as the Office 365 portal). 
  • From your emails, click on the settings cog. This is found of the top right of the screen on the menu bar
  • Once you...
    •
    Changing the default reply setting in Office 365

    The default reply method in Office 365 is reply all (which is different to the Outlook desktop client installed on University computers).

    This guide will show you how change the setting from 'reply all' to 'reply' in Office 365.

  • Click on the settings cog in the top right hand corner...
    •
    Excel - Removing Duplicate Values

    There are multiple ways of highlighting or removing duplicates from an Excel worksheet. 

    Conditional Formatting

    Conditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....
    Excel - Text to Columns

    Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns: 

    Text to Columns

    'Text to columns' is found in the 'data'...
    Excel - Find and replace
    Excel - Find and Replace

    Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
    Excel - Drop-down lists
    Excel - Drop-down lists

    Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...
    PowerPoint - Exporting a PDF
    PowerPoint - Exporting a PDF

     

    Sometimes you may need to convert your PowerPoint presentation to a PDF for various reasons including printing. This is a very easy process and will duplicate your file assuming you have also saved as a PowerPoint file to start with. But it is reasonably well...
    PowerPoint - Keyboard Shortcuts

    Many of the keyboard shortcuts used in PowerPoint are also used in the rest of the Microsoft office suite. 

    The following table itemizes the most frequently used shortcuts in PowerPoint.

    To do this...
    PowerPoint - Zoom Slides (Prezzi)
    PowerPoint - Zoom Slides

    PowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole...