Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

Excel

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.

Categories Data and Analytics Tags Excel, Power BI Leave a comment

How to Use Unicode Characters in Power BI

How to display Unicode characters and change their color in Power BI visualizations.

Categories Data and Analytics Tags Excel, Power BI Leave a comment

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.

Categories Productivity Tags Excel, Macro, VBA Leave a comment

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.

Categories Automation Tags Automation, Excel, Outlook, VBA Leave a comment

Retrieve Outlook Address Book Data Using Custom Excel VBA Function

Custom VBA Excel function to retrieve individual data attributes from Outlook address book entries.

Categories Automation Tags Automation, Excel, Outlook, VBA 4 Comments

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.

Categories Productivity Tags Excel, Regular Expressions, VBA Leave a comment

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.

Categories Data and Analytics Tags Excel, Power Query Leave a comment

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.

Categories Data and Analytics Tags Excel Leave a comment

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.

Categories Technology Tags Excel, VBA Leave a comment
Older posts
Newer posts
← Previous Page1 Page2 Page3 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Create Self-Signed S/MIME Certificates
  • How to Use Unicode Characters in Power BI
  • Display Total Inside Power BI Donut Chart
  • Mapping Continents and Countries in Power BI

Latest Posts

  • Creating a Power BI What-If Scenario Analysis
  • Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
  • Manually Create a WordPress Database from the MySQL Client
  • Upgrade PHP and PHP-FPM from the Command Line on a Debian LAMP Stack
  • Install a LAMP Stack Manually on a Debian OS Only Amazon Lightsail Instance

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.