Apps for Office In Excel

Apps for Office in ExcelI want to be clear that when I say apps for Office in Excel, what I am talking about are the apps that you insert into your worksheet from the Excel ribbon. Microsoft have stated that they are moving away from the term Apps for Office though and will be using Office add-ins instead. I’m […]

Customize Default Excel Workbook

Excel custom blank workbookDid you know that when Excel opens a new workbook it uses a template called ‘Book’ to create the new file? This means we can create a custom default Excel workbook by replacing the template file called ‘Book’ with one containing our own formatting. How to Customize the Default Excel Workbook It’s easy to do. […]

Excel Fill Value Down Rows based on Criteria

Excel Fill Down IFA few weeks ago one of our members, Kylie, sent me this question:   “How can I fill column E with the text ‘CURRENT’, if the Position Title in column D matches the first instance of ‘CURRENT’ in column E?” See example data below; Kylie wants to fill the cells bordered in orange: Note: I […]

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