TIPS, TRICKS AND HINTS

Our full library of tips and tricks that will make you look like a legend is at kambium.co.nz

Compare two (near) identical Word files, without going insane

Of course, in a modern cloud world, this shouldn’t happen! We should share a link to a file and use versions to maintain it’s history.  But we’re not in a perfect work, and we often get multiple people updating copies of the same file.  Its all good until we have to figure out what’s changed. Did you know that Word can do this for you? Either [...]

9 Common Excel Mistakes

We were reminded of the risks of messing up spreadsheets in a recent : The scary fact they quote is that are wrong! The consequences of relying on bad information as a result can be insane! That reminded me of a couple of lessons from years ago in terms of good spreadsheet design.   1. Check calculations It’s so easy, especially when [...]

Have you noticed the new Office search?

We love that Office365 keeps improving.  One of the most common challenges we all have is finding things. So, if this resonates for you,  the new search feature might be just what you need. It lets you search for help, files and people to share your file with from the app you’re working in.  (or use Alt-Q)     Just [...]

When words fail you

If you are like me, sometimes you don't know the right words to type into the "help" search. Lucky for us, Office is keen to help. It's there to help us. Our friends at Kambium have explained it in the video below, or you can give it a try yourself! In the sample below, I wanted to highlight all the cells in Excel where the data meets a [...]

Does OneDrive make the cloud work for you?

Microsoft's geek-fest is called Ignite and we've been following it from afar. It was a OneDrive announcement that caught our eye today.  With lots of choice, and ingrained user habits, everyone has their favourite cloud sync tool. There's an innovation race to be the cloud sharing tool of choice. As users, we're the beneficiaries of this and it's a [...]

Changes to the Microsoft Office Ribbon (again!) for Office 365

Microsoft love tweaking the Office ribbon bar. I’m never sure if it's an improvement or not, and that’s certainly the case now.  It is probably a personal preference. Actually, this time it’s not a replacement, although it may look that way – it’s a simplification option, although it looks to be ‘on’ by default. The intent is to keep the [...]

Keeping up with One Note

I reckon that OneNote's being used by about a third of the people I see in meetings.  And that means that about two-thirds of people are missing out! I've been a big OneNote fan for ages because OneNote conquered my personal chaos of unstructured notes and paper everywhere.  For the last several years, I've been able to find things, and that's [...]

Keeping up with Microsoft Office updates

If you have Office 365, then you have the latest version.  Office updates monthly with new features – but are you USING them?  Office gets smarter every month, but are you? The new capabilities can help you work smarter and be more productive, but only if you can find the time to assess and adopt them. But it’s so hard to find the time! As [...]

New cool stuff in your Office 365

Microsoft are continually updating Office 365 with awesome new tools and more efficient ways of working.  Keeping up with these and learning how to use them is a big challenge, which is why we created the Kambium service in our computer coaching business. Here are a few of the latest and greatest Office 365 additions... You can now see [...]