Home and end in Word
Home and end in Word: Jump to the end of the line by pressing the End key. Use Home to jump to the beginning. #Microsoft #Office365
Creating an appointment from an email
Creating an appointment from an email: Drag an email to the Calendar in #Outlook to make an appointment with the email content as the body of the appointment. #Office365
Clean-up conversation
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
Ctrl + enter for page break
Ctrl + enter for page break: Type in a Page Break in #Word using Ctrl+Enter. #Microsoft
Ctrl + arrow to move to end of block
Ctrl + arrow to move to end of block: Quickly navigate around your #Excel spreadsheet. Press Ctrl+arrow to jump to the end of the block in the direction of the arrow #Office365
Applying heading styles
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
F5 GOTO
F5 GOTO: Hit F5 to jump to a different cell in #Excel. The dialog box remembers previous cells you've jumped from. In #Word you can pick a particular page.
Select region
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
QAT below ribbon
QAT below ribbon: The Quick Access Toolbar is the little row of icons at the top-left of #Excel #Word etc. Move it closer to your work by right-clicking it and selecting Show QAT below the Ribbon.
[ and ] to shrink and grow font
[ 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
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.
F5 GOTO in Word
F5 GOTO in Word: Quickly jump to another page in #Word by pressing F5 to bring up the Goto dialog. #Office365
Zoom selection in Excel
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
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
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
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
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
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
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
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)