Devices everywhere

With the best introduction of Word, Excel and PowerPoint for Android and upgrade of Outlook for Mac recently, I thought I'd revisit my multi device world and give you an update. With Office365 spreading wider I'm finding more and more clients want multi platform training and, well to be honest, I like playing with gadgets. … Continue reading Devices everywhere

Arrange Windows on Screen

Multitasking is much easier when you can have multiple windows on screen at the same time.  These techniques work in both Windows 7 and 8. To tile windows (any windows version): Open the applications you want to see on screen (do not minimise) Right click in a blank area of the task bar Select Show Windows … Continue reading Arrange Windows on Screen

Useful Links for Office 365 Administrators

Not so much a blog this one, but just a few links that I share on Office 365 Admin training courses.  I'll add to this as I find more. Automatic SharePoint Online Site Collection Storage Quotas http://blogs.office.com/2014/08/18/sharepoint-online-simplifies-storage-management/ Office 365 Development Roadmap http://office.microsoft.com/en-gb/products/office-365-roadmap-FX104343353.aspx What is One Drive for Business https://support.office.com/en-US/Article/What-is-OneDrive-for-Business--187f90af-056f-47c0-9656-cc0ddca7fdc2?ui=en-US&rs=en-US&ad=US Office Blogs http://blogs.office.com/ Office Visio Stencil's: http://www.microsoft.com/en-gb/download/details.aspx?id=35772Continue reading Useful Links for Office 365 Administrators

Word for iPad – Getting Started

Microsoft Word for iPad does not have all the features of the Windows desktop version, but it does have sufficient tools available for the majority of documents produced.  Install & Set up Word for iPad Microsoft Word should be downloaded from the App Store and will automatically be installed. Once installed open the app to … Continue reading Word for iPad – Getting Started

Recommended Charts and Pivot Tables

Excel 2013 incudes template charts and pivot tables which are provided by the Recommended Charts and Recommended Pivot Table features. The available options are provided intelligently based on the selected data. Click into or select the data to be pivoted. On the Insert tab, select Recommended Pivot Tables. The dialog box then previews pivot tables … Continue reading Recommended Charts and Pivot Tables

Using Flash Fill in Excel 2013

Flash Fill is a new feature in Excel 2013, which automates tasks such as reformatting dates and other information as well as separating or combining columns of information. Reformatting Data In the above example column A contains unformatted dates, Flash Fill can be used to format them. In the next column, first cell (i.e. next … Continue reading Using Flash Fill in Excel 2013

Visualising Data with Improved Conditional Formatting

Conditional Formatting in Excel 2013 has been improved to let you quickly visualise and comprehend data. You're going to find more styles, icons and data bars as well as the ability to highlight specified items like minimum and maximum values in just a few clicks. First of all highlight the data you want to apply … Continue reading Visualising Data with Improved Conditional Formatting

Getting Started with Office 365 – User Guide

What is Office365? Office 365 is a subscription-based online office and software plus services suite which offers access to various services and software built around the Microsoft Office platform. It is "an always-up-to-date cloud service", due to its rolling updates and incorporates Exchange Server (for e-mail), SharePoint (for internal social networking, collaboration, and a public … Continue reading Getting Started with Office 365 – User Guide

Windows 8.1 – What’s New and should I upgrade?

So you finally got to grips with Windows 8 and now in about 1 weeks time you'll be able to upgrade to Windows 8.1. If that bring you out in a cold sweat imaging all the changes that are coming, worry not, as its not a radical change, more an evolution and some nice tweaks … Continue reading Windows 8.1 – What’s New and should I upgrade?

Planning in Project 2013 – The Important Steps

Creating a Plan Set project start date and default calendar Open the Project Information dialog and choose the required settings. Select Project tab – Project Information. NOTE: DO NOT SET THE STATUS DATE. Do this only when you update the plan from information from timesheets. Enter project custom field information (Project Server Only) To fill … Continue reading Planning in Project 2013 – The Important Steps