Combine Data From Multiple Tables to Create a Clustered Column Chart in Power BI
How to combine data from multiple data tables using DAX to create a clustered column chart in Power BI.
Excel
How to Use Unicode Characters in Power BI
How to display Unicode characters and change their color in Power BI visualizations.
Creating Cascading Drop-down Lists in Excel
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.
Automate E-mail Information Extraction from Outlook into Excel Using VBA
How to automate the extraction of information from e-mails in Outlook into Excel using a custom VBA procedure.
Retrieve Outlook Address Book Data Using Custom Excel VBA Function
Custom VBA Excel function to retrieve individual data attributes from Outlook address book entries.
Parse Cell Value in Excel Using Regular Expressions
How to parse an Excel cell value using regular expressions. This function returns cell value substrings that match the regex pattern.
Microsoft Power Query for Excel Tips and Tricks
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.
Excel Lookup With Multiple Criteria Using SUMPRODUCT or Array Formula
How to perform complex lookups in Excel using multiple criteria through either a formula based on the sumproduct function or an array formula.
Import Worksheets From One Workbook to Another Using VBA
Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.