OWA (or Office 365 Web Apps) can be accessed from anywhere in the world. From here you can access your emails and also add automatic replies. The below process will show you how to add automatic replies when not in the office. To access this service, open your web browser and browse to https://login.microsoftonline.com You can also access it by clicking on the Outlook button on our Extranet page: Once at the login screen, enter your email address and, if necessary, select that it is a Work or School account. Then enter your password that you use to login to your work computer. You will receive a message asking you if you want to stay signed in. If you plan on working for a long time with this open, then select 'Yes'. Once you have logged in, you'll be able to see your mailbox as if you were using Outlook. From here, click on the cog-wheel at the top-right next to your name and select 'Automatic replies'. In the next screen, you can enter your automatic reply along with any custom setting you wish to apply such as declining all calendar invites, amongst others.

For Office 2010 and 2013, Power Query for Excel was an add-on. However, for Excel 2016 this comes built-in. You shall find everything you need under the Data tab.

If you notice your Excel file is taking a long time to open or to save, it could be because there are thousands of cells that contain some kind of formatting without you realising. If you tap Ctrl + End on your keyboard, that will take you to the last formatted cell. If it takes you well beyond the cells you have data in, you will need to remove all of these 'formatted' cells to reduce the file size. Select the cell that is one row down and one column to the right of your data. Tap Ctrl+Shift+ then Shift+ . This will highlight all rows below your data. Right-click the selected rows and choose Delete. Again, select the cell that is one row down and one column to the right of your data. Tap Ctrl+Shift+ then Ctrl+. This will highlight all columns to the right of your data. Right-click the selected region and choose Delete. Save your workbook. Tapping Ctrl+End should take you to the last cell of your data.