Managing Meetings using OneNote

Ahh…glorious OneNote. The more I use it the more I love it.

For some reason OneNote still seems to be a well-kept secret, but it shouldn’t be, as it’s a brilliant tool for research, planning and collaborating with colleagues and partners.

In this post I’m going to share how OneNote’s awesome digital note-taking features with Outlook integration promote super-efficiency around managing meetings.   Read more

Excel – Restricting editing in worksheets and workbooks

SharynAvatarBlog120x120There may be times when you have created a single worksheet, or an entire workbook containing data, where you do not want other users to be able to change.

By protecting a selection of cells, the entire worksheet or workbook you can feel confident you have minimised the risk of this happening. Read more

Excel – How can I do a VLOOKUP based on more than one value?

There are times when you want to return a match for a VLOOKUP based on two values, not one.  For example, we may have customers who have multiple branches.  Each branch is recorded under the same customer number.  So how do we look up info for a specific branch if all of the branches are using the same customer number?

Read more

Excel – How do I sum a range of cells that include #N/A or #DIV/0! errors?

I think most of us will agree that error values can be helpful, and sometimes extremely unhelpful.  For example, the #N/A error (Value Not Available error) is very helpful when cross-referencing two lists using the VLOOKUP function.  If Excel can’t find a lookup value the #N/A error makes it very obvious.

However if you are wanting to total a range that includes #N/A errors all of a sudden they aren’t so special any more.  Read more

Excel – Finding and removing duplicate data

One of the many things I absolutely 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.

Something I see often is the need to be able to quickly locate and remove duplicate rows of data (excellent for VLookups).  Most people just sort the data and then manually skim through the excessive lines of information trying to weed out the annoying duplicates.  This works, but boy-oh-boy it can be a time waster. Wouldn’t it be easier to have Excel quickly display the duplicates for you?  Then all you need to do is deal with them. Read more

Excel – How do I merge cells within a range that is formatted as a Table?

PROBLEM: when I use “Format as Table” to format a range the “Merge and Center” button becomes inactive and I can no longer merge cells.  Why?
SOLUTION: the Table format will stop the merging of cells.  However there is a work-around.

The Format as Table command can be used to quickly apply a professional format to a selected range.  However, in applying the format you are also applying the functionality that Tables offer.  As a result you will no longer be able to merge cells. Read more

Outlook 2013 and 2016 – why are my folders no longer alphabetically listed?

Outlook 2013 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