How to stop overwriting files in Excel
Is this you? You open the May file and make the changes for June and save it and then remember you hadn’t renamed the file as June. Well, I’ve done that too. (more…)
Excel – How To Create a MINIF and a MAXIF
Excel doesn’t have a MINIF or a MAXIF function and many advanced users create an array formula to provide that functionality. If you have Excel 2010 or later there is a non-array solution. (more…)
Enabling PowerPivot
In my latest free webinar I provided a brief demonstration of PowerPivot in Excel 2013. I forgot to show you how to enable it. Luckily its easy. (more…)
Data Validation to Ensure a Weekend Date
If you want to ensure the user enters a date that is a Saturday or a Sunday, you can use a Custom Data Validation. This example is for cell A1. To open the Data Validation dialog use Alt a v v (pressed in sequence, not held down). Click the first drop down and select Custom. This allows you to enter a formula to determine the data validation. The formula used is =WEEKDAY(A1,2)>5 The WEEKDAY function returns a number from 1…
Pasting Data to the Bottom of a Formatted Table
Formatted tables are a great feature in Excel. They were expanded and renamed in Excel 2007 (formerly called Lists) and their use offers many advantages. (more…)
Running an Excel Macro from a Graphic
These days running a macro off a control button seems to be old school and many people have started running macros off graphics. (more…)