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

Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint

Power Query examples to access Excel data in the current workbook, local file, or SharePoint path. Data structured as a worksheet, table, or named range.

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

Using Cards To Filter In Power BI

How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.

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

Faster Excel Calculations By Minimizing Range Boundaries

Excel calculation speed can be improved by reducing the size of an evaluated range. This custom VBA function removes empty boundary cells from a range.

Categories Productivity Tags Excel, VBA Leave a comment

Counting Based on Background Color in Excel

How to count all Excel cells in a range based on background color using a custom user-defined function in VBA.

Categories Productivity Tags Excel, VBA Leave a comment

Concatenate Ranges, Arrays, and Values Using Excel VBA

How to concatenate ranges, arrays, and values in Excel using a custom function with options for a delimiter and setting row or column priority.

Categories Productivity Tags Excel, VBA Leave a comment

Excel Lookup Using Date Ranges and Multiple Criteria in Power Query

How to use Power Query to retrieve a value when the date from the first table exists between an effective date range in a second table.

Categories Data and Analytics Tags Excel, Power Query 2 Comments

Display Excel File Modified Date in Power BI

How to display the last modified date of the underlying source Excel data file used in a Power BI report.

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

Display Total Inside Power BI Donut Chart

How to display a total and percent of total at the center of a Power BI donut chart.

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

Combination Clustered and Stacked Column Chart in Excel

How to combine clustered and stacked columns in one Excel chart without changing the source data structure.

Categories Data and Analytics Tags Excel 10 Comments
Older posts
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.