Your blog category
Step 1: Overview The macro CopyRecordsBasedOnCriteria helps filter data based on multiple criteria and copy the results to a new […]
Pull Data From One Worksheet to Another Automatically Based on Cell Criteria In Excel Read Post »
In this Microsoft Excel video tutorial I explain how to convert numbers into their words equivalent. You can do this
Convert Numbers into Words in Microsoft Excel – With or Without Currency Read Post »
Here is a step-by-step tutorial on how to fix the #REF! error in Microsoft Excel, based on the provided source:
How to Fix the #REF! Error in Excel Read Post »
This tutorial explains how to use a slicer to filter data in a PivotBy report in Microsoft Excel. Understanding the
Excel PIVOTBY Function Hack!! – Use Slicer to Filter PIVOTBY (using LAMBDA Function) Read Post »
Here is a step-by-step tutorial on how to use Microsoft Excel’s Co-pilot feature to perform lookups between worksheets. Ensure that
This tutorial explains how to use the new Microsoft Excel Online Co-pilot tool to quickly remove spaces in your data
Quickly Remove Spaces in Excel for VLOOKUP or XLOOKUP – New Excel Online CoPilot Tool Read Post »
This tutorial will outline the methods for reducing the file size of an Excel workbook as presented in the provided
How to Reduce File Size of Excel | Compress Excel File – 4 Methods Read Post »
A tutorial on five methods to convert text to uppercase, lowercase, or proper case in Excel. You can watch the
How to Change Case in Excel – UPPER, lower & Proper (With or Without Formula) Read Post »
In Excel 365 you can use the VSTACK function with the FILTER function to filter across multiple worksheets. You can
Excel’s FILTER Function: Filter Across Multiple Worksheets Read Post »
This tutorial explains how to create checkboxes in Excel. It also explains how to automatically change the row colour if
How to Create a Checklist in Excel | Interactive Checklist Template with Checkboxes Read Post »
