How to combine data from multiple data tables using DAX to create a clustered column chart in Power BI.
How to display Unicode characters and change their color in Power BI visualizations.
How to create cascading drop-down lists in Excel. Selecting an option in the parent cell filters the available options in the dependent child cell.
How to automate the extraction of information from e-mails in Outlook into Excel using a custom VBA procedure.
Custom VBA Excel function to retrieve individual data attributes from Outlook address book entries.
How to parse an Excel cell value using regular expressions. This function returns cell value substrings that match the regex pattern.
Tips and tricks learned from using Microsoft Power Query for Excel including performance improvements, creating total rows and running totals, handling empty tables, and filtering using named range values.
How to perform complex lookups in Excel using multiple criteria through either a formula based on the sumproduct function or an array formula.
Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.