Excel Worksheet Protection

Excel Worksheet ProtectionExcel worksheet protection is a great way to prevent people accidently messing up the reports you’ve spent hours creating. However, it is not going to keep confidential data a secret. If someone really wants to get to your data, or see how your model was put together and all the amazing formulas you’ve used then […]

Excel Filters 4 Ways

Excel FiltersFilters are one of my most used Excel tools. They’re not fancy, but they sure do earn their keep. I’ve even bestowed them with some prime real estate in my QAT: Filters allow you to quickly hide rows containing data that don’t meet your criteria. You can also apply multiple filters to one or more […]

Slicers for Excel Tables

Slicers filter Excel TablesDid you know you can use Slicers to filter Excel Tables? It’s like having your cake and eating it too! Not just any cake either, it’s like the most delicious Excel cake you’ve ever eaten and once you get a taste of the ‘Table Slicer Cake’ you’ll be wanting more. The good news is it’s […]

Excel Custom AutoFilter with Wildcards

Excel AutoFilterExcel’s Custom AutoFilter can perform a myriad of tasks that are often overlooked. Just last week we had a question from Alf: “I have a list of 7000+ words and want to search it with variables such as find all words where the third character is “u”, or where the third character is “u” and […]

Excel Find Tool

excel_find_tool_thumbYou’ll be Amazed at what you can CTRL+F in Excel Excel’s Find tool is one of the first features you’re likely to learn and for many of us we only use its most basic feature, which is to find a particular word or value in a cell. It is such a diverse tool that I […]

Excel Advent Calendar

Excel Advent CalendarToday I’ve got a Christmas treat for you with an Excel Advent Calendar that Phil and I created. Before you get too excited I should say that there aren’t any chocolate/candy treats behind each door, plus you have to do a bit of work to actually open the doors! Don’t worry, I’m not the Grinch… […]

My 2014 Microsoft MVP Summit Experience

mvp_logoI arrived back from the 2014 Microsoft MVP Summit in Seattle on Sunday a little tired but bounding with excitement for the future of Excel. It was wonderful to meet my Excel Idols – the other Excel MVP’s and wax lyrical about Excel and other geeky topics. Microsoft took great care to make sure the […]

Excel Custom Data Validation to Limit Entries

Excel Custom Data ValidationIn this tutorial we’re going to look at how Santa is using Excel Custom Data Validation to limit the number of presents kids request on their Christmas wish list. With Christmas fast approaching our kids are already talking about what Santa might bring them this year. Little do they know that Santa will be implementing […]

Excel Protect Ranges with Different Passwords

pass_protect_thumbDid you know you can set different passwords to protect specific ranges of your Excel worksheets? It’s called Allow Users to Edit Ranges and you’ll find it on the Review tab in the Changes group: Let’s say you have several different users of a workbook and you want to restrict each user’s editing rights to […]

Excel Paste Special Operations

paste_special_thumbCopying and Pasting are two of the most common tasks you’ll perform in Excel. This is especially true for me and I can tell because the shortcut keys (CTRL+C for copy and CTRL+V for paste) on the new keyboard I got just last week are already showing signs of wear. Most of the time I […]