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
There 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
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?
Displaying date values in a Pivot Table can produce unexpected results.
For example, in the Pivot Table below I have added a Date field to the Column area of my Pivot Table. Unfortunately every date in the underlying data table is different, therefore resulting in a column for every day and a very large Pivot Table. Read more
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
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
Copying a data range that contains hidden data can be challenging. You may have tried this and found that the hidden data travels with the copied range.
In this tutorial I show you how to copy and paste only the visible data – hidden cells are excluded.
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 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
Need a list of weekdays? The Auto Fill button allows us to quickly create a lists of days of the week. However, the list includes Saturday and Sunday. Thankfully Excel offers a very simple solution to create a list that only includes Weekdays. Read more