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

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 7 Comments

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

Excel VBA Procedures to Break All External References in Workbook

Excel VBA functions to break all external references and delete defined names containing external workbook references.

Categories Productivity Tags Excel, VBA 2 Comments
Older posts
Newer posts
← Previous Page1 Page2 Page3 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Display Total Inside Power BI Donut Chart
  • How to Use Unicode Characters in Power BI
  • Create Self-Signed S/MIME Certificates
  • Automate E-mail Information Extraction from Outlook into Excel Using VBA

Latest Posts

  • 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
  • Automatically Back Up a Linux Server to Google Drive
  • Linting WordPress Code Using Composer and PHP_CodeSniffer
  • Using Cards To Filter In Power BI

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.