Category: Office Applications

Office 2016 Rollout Begins

Office 2016 rollout has begins from today (22 September) across the UK. The news from the post earlier this year that Office 2016 was due in the second half of 2015, so the time has come. I’ll be looking into this across the next few weeks. If you’d like help or training with Microsoft Office …

Continue reading

Office 2016 for Mac

Microsoft have now released Office 2016 for Mac, this is ahead of the release of the full Office 2016 suite for Windows based devices, which is due for release before the end of 2015 (no specific dates have been muted at this time). It is available to Office 365 customers using a Macintosh device, whether …

Continue reading

Office for Android

Microsoft have now released their Office for Android package. This provides the availability of the new Word, Excel and PowerPoint apps for Android phone.  Office apps for Android tablets has previously been released and this release now allows all Android uses to access the Microsoft Office applications. For more information read the Microsoft Office Blog …

Continue reading

Using Count Functions In Excel

I was called upon this week to solve a problem using the Excel Count functions. The situation was that the user just didn’t understand the difference between each of the functions available, which I will summarise here. There are 5 Count functions COUNT Counts how many numbers are in the list of arguments COUNTA Counts …

Continue reading

Office 2016 Coming soon

Catching up on the news this week I read that the next version of Microsoft Office is due to appear in the second half of 2015, and Windows 10 has been unveiled by Terry Meyerson. So far there are no details as to the updates, changes, and fixes it will contain, that information generally doesn’t …

Continue reading

Synchronizing Outlook to Hotmail Accounts

Surprisingly those with Hotmail or Live accounts are unable to directly connect to Outlook, even though these are Microsoft products. To allow these accounts (including the newer outlook.com) accounts to communicate with Outlook the Outlook Hotmail connector needs to be installed. The Microsoft Outlook Hotmail allows Microsoft Office Outlook 2003, 2007 or 2010 to access …

Continue reading

Save Time and Effort with Templates in Microsoft Office

In Microsoft Office use templates to create consistent documents and save time. Templates are particularly useful for documents that are used frequently, such as standard letters, weekly reports and presentations or expense forms. A template forms the basis of a document that is perhaps partially written with only some customisation to be inserted to complete …

Continue reading

Inserting the Date and Time into a Worksheet

It happens often, current date and/or time is to be added to a worksheet, perhaps while making a time stamped log of activities. Maybe there is a requirements to have the current data or time displayed automatically in a cell every time formulas are recalculated. There are several ways to insert the current date and …

Continue reading

PowerPoint Presenting Tips

One of the most heard phrases I hear in relation to any of the available presentation suites is “Death by PowerPoint”. In other words there’s total overkill in its usage, and very often it’s totally unnecessary, often as a result or poor presentation skills. When presenting, remember that PowerPoint is a tool to aid effective …

Continue reading

Excel Quick Shortcuts – Formatting

In this article we once again consider some key tips utilising keyboard shortcuts, this time in relation to formatting. There are many possible number formats, all of which can be accessed through the Format cells dialog box. There are however some preformatted options that can readily be accessed using keyboard shortcuts. In many cases these …

Continue reading