Have you upgraded to a tablet or Windows 10 and upgraded to Office 2016? Our customised courses in Office 2016 can guide you to make the most of the new features of Office 2016
There is a button in Excel that let's you show all your formulas at once. This is great for finding errors or just trying to work out what is going on with someone else's spreadsheet.
In the Formulas Toolbar, click the Show Formulas button. When you are finished analysing your spreadsheet, press the Show Formulas button again to turn it off.
Make your Power Point slides more attractive with Smart Art Shapes. Instead of boring bullet points, these colourful, 3D shapes will visually explain your topic.
To create a Smart Art graphic click the Insert Toolbar and click the Smart Art button
A drop cap is a large capital letter at the beginning of a text block that has the depth of two or more lines of regular text. It is a creative way to draw attention to a featured section of text.
Highlight text inside a text box and in the Text Box Tools Toolbar click the Drop Cap button
Tidy up your data and remove duplicates
On the Home Toolbar, click Conditional Formatting -> Highlight -> Duplicate Values
Understanding the Excel Cursors will save you a lot of time and frustration
The Select Cursor will highlight cells and is the most common cursor you see
The Move Cursor will move the highlighted cells to another location. It is a quick version of cut and paste
The Auto Fill Cursor will copy formulas and repeat series such as dates and days
Are people entering in the incorrect data in your spreadsheets?
Make sure the data is valid by using Data Validation.
Go to Data Toolbar-> Data Validation and restrict what can be entered
Perfect for demonstrations, you can now include screen recordings in your PowerPoint presentations with just a few clicks. Just set up whatever you'd like to record on your screen, then go to Insert > Screen recording, and you'll be able to select a portion of your screen to record, capture what you need, and insert it directly into your presentation in one seamless process.
Smart lookup lets you fact-check and research a phrase with results appearing in a sidebar.
Highlight a phrase, click on Review -> Smart Lookup to see results in the sidebar
In Outlook 2016 you can easily attach documents you most recently worked on to your emails from the Insert tab.
When Inserting an attachment, select one of your recently saved files
When you and your colleagues want to collaborate on a document, use real time co-authoring to see everyone’s changes as they happen.
First you save the document to OneDrive or SharePoint Online, so others can work in it.
Next, you invite people to edit it with you. When they open and work on the document in Word 2016 or Word Online, you'll see each other’s changes as soon as they're made.
Get creative and display information in a new way. The new chart types in Excel 2016 are;