TIPS, TRICKS AND HINTS

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

Top Microsoft Teams Tips to Keep Your Team Together

People are already feeling strain with the rapidly changing face of Covid-19.  Stress and tensions are naturally high and for many organisations this could be first time they have asked people to work remotely for extended periods.   It’s definitely not our New Zealand cultural norm.  Re-creating your culture with your people working remotely is [...]

Making it Work When Working From Home

Working remotely can be invigorating from time to time, but there’s a reason why we don’t do it permanently. If we’re forced to work remotely for a long period, how do we overcome isolation effects? Working together in an office has a number of social benefits. You participate in office banter which can be fun, and enjoy your office culture. [...]

THREE EDGE TIMESAVERS

It’s a point of pride among many users to immediately swap out their default web browser on Windows from Edge to something else.   To be fair, that’s because Microsoft’s past browsers have fallen behind the marketplace – other browsers are faster and more compatible with more websites.  In fact, we found some of the various support and admin [...]

Excel’s Best Ideas

(It used to be called ‘Insights’ ). It’s Excel’s attempt to make you look smarter and more thoughtful. Simply start with a table (not a pivot table) of data, and hit the idea’s button and see what comes. Based on my experimentation, it gets a little confused with formatting and ‘total’ lines in data, so you may need to [...]

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 [...]