Search results

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 - 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...
    Outlook - Focused Inbox
    What is the Focused Mailbox?

    When focused mailbox mode is enabled it will split your Inbox into two Tabs:

    Focused & Other 

    High priority emails are directed to the Focused tab, whilst low priority emails like advertisements and generic newsletter items are directed to the "Other" Mailbox...
    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 and then select "view all Outlook...
    •
    Syncing a Sharepoint storage area with your device
    What is Sharepoint?

    Sharepoint is used to store files, folders, and photos in the 'cloud' (Online) so you can access them easily on multiple devices and share them with colleagues, or with people outside the university. Sharepoint is an extension of OneDrive and can be synchronized with your...