A tutorial on five methods to convert text to uppercase, lowercase, or proper case in Excel. You can watch the video above or follow the tutorial below. If you want to download the file featured in the video, please click here. The VBA code featured in the video tutorial can be found at the bottom […]
Category: Microsoft Excel
Your blog category
Excel’s FILTER Function: Filter Across Multiple Worksheets
In Excel 365 you can use the VSTACK function with the FILTER function to filter across multiple worksheets. You can watch the video tutorial above or follow the instructions below. Download the featured file here. In my scenario I have a workbook that contains four worksheets, one for each customer type: Web, Store, Account Holder […]
How to Create a Checklist in Excel | Interactive Checklist Template with Checkboxes
This tutorial explains how to create checkboxes in Excel. It also explains how to automatically change the row colour if the row contains a checked checkbox. In addition, the video above shows you how to create a % complete bar – so it may be worth a watch! You can download the featured file here. […]