Clean-up conversation: As an email conversation goes to & fro it builds up in both the email messages and the history that is in each message. Remove this duplication using Home-Clean-up-Clean-up Conversation. This deletes messages that are recorded in the history too #Outlook
Applying heading styles: You can quickly make a heading in #Word by applying a Style to the paragraph. Ctrl+Alt+1 makes a main heading, Ctrl+Alt+2 a sub-heading and Ctrl+Alt+3 a sub-sub-heading. #Office365
Select region: Want to select a block of cells in one go. Press Ctrl+* (or Ctrl+Shift+8). Don't forget that many commands like sorting or creating a table don't need the region to be highlighted first #Excel #Microsoft
[ and ] to shrink and grow font: Make your text a little bit bigger (or smaller) using Ctrl+[ or Ctrl+]. Changes the size of your font but keeps any difference so you can keep your headings #Microsoft #Office365
Ctrl + D to duplicate: Want a copy of your shape in #PowerPoint? Ctrl+D duplicates the shape, which is a bit quicker that copy and paste.
Zoom selection in Excel: Zoom to Selection is a great #Excel command. Fit your work to the screen by highlighting what you want and clicking View - Zoom to Selection. Excel will zoom so that the highlighted area fill the screen.
Excel in 100 Tweets 11: Using Autosum for Totals - To total a column or row use Autosum. Click the button and it will guess which cells you want, press enter to confirm. If the guess is wrong, drag the mouse across the cells you want to Sum before Enter.
Excel in 100 Tweets 12: Copying the rest of the row or column using Autofill - The Autofill Handle is the little square in the corner. Drag down to copy the calculation to the whole column, or across to copy it along the row.
Excel in 100 Tweets 9: Simple Arithmetic - All calculations in #Excel start with = . Follow that with the calculation you want to do eg: A2+B4, so the cell's formula is =A2+B4. Other symbols - minus / divide * multiply.
Excel in 100 Tweets 10: Using Brackets to control the maths - Calculations are done in this order: Brackets, Ordinals (power of 2 or 3 etc), Divide, Multiply, Add, Subtract. So 10+4/2 = 12 but (10+4)/2 = 7
Excel in 100 Tweets 5: Merge & Centre - If you've got a heading that needs to span several columns type it into the first column, highlight the range, right-click and choose merge and centre from the top-right of the mini-toolbar.
Excel in 100 Tweets 6: Formatting Numbers - To get the text to look how you want, select the cells and right-click to show the mini-toolbar which has buttons to currency, %, comma separators and decimal places.
Excel in 100 Tweets 7: Formatting Dates - To get the date to look how you want select the option from the Number Format drop down to show either the short date (dd/mm/yyyy) or the long date (dd mmmm yyyy)