Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

Excel 2003's Toggle Switch sets a variable to one of two values -- true or false. The control acts similarly to a check box, but looks like a button, so it suits cases where users must set single ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

How to create a sorted unique list in an Excel spreadsheet Your email has been sent Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE ...

Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products across multiple departments, or within ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...