Home » Our Blog » Office 365

Tag: Office 365

What’s the difference between a site and subsite in SharePoint?

I often get asked this question, although it’s usually framed more like this: “when should I set up a site instead of a subsite?” or “Isn’t everything a site, anyway?” or “why should I care whether my site is a subsite or not?”  The first thing to note is there is only one top level (root) site in SharePoint – that’s the Home site.
Read more

How to calculate GST at 15% using Excel formulas

sharyn bainesI have been asked twice in one week to please explain how to calculate GST at 15% using Excel formulas.

You can find information on how to calculate GST  (Goods and Services Tax) on the NZ Inland Revenue website. I’ve taken this a step further and put together a tutorial on how to put these calculations into Excel formulas.

 

Read more

Do your documents reflect well on your organisation?

Most of us have used a template in the past to create a presentation or start a document, and many of us are guilty of reusing the last great version of a document as a starting point instead of locating and using a template.  This pragmatic approach helps to avoid wheel reinvention and utilises the efforts of the clever person who created the file in the first place – however, the problem with reusing a last good version versus using a template is that your new file takes on any issues that existed in the original doc, and you could very likely be using out of date branding, terminology and styles.

Read more

Finding and removing duplicate data in Excel

Finding and removing duplicate data in Excel can be a quick process. However, for many people who haven’t learnt how to do this the quick way in Excel, it can be an absolute chore.

One of the many things I love about my job is that I get to work with so many different people from all kinds of organisations. However, it doesn’t matter what industry or region I’m working in the challenges of working with large lists of data are pretty much the same.

Read more

Why are my Outlook folders no longer alphabetically listed?

If you have recently upgraded to a more recent version of Outlook you may be asking ‘why are my folders no longer alphabetically listed?’. Outlook now offers you the freedom of reordering your folders in any order that takes your fancy.

Now you can simply drag your most used folders to the top of the folder list.  No more fussing around placing numbers and zz’s  in front of folder names. Read more