PowerQuery Parameter in Excel

I share in this post how you can define Parameters for Power Query in Excel.

Use Data Model Relationships instead of XLOOKUP/ INDEX/MATCH in Excel

I share in this post a recent learning about how to use data relationships in Excel (instead of e.g. INDEX/MATCH or XLOOKUP)

Excel: PowerQuery Table with Excel Custom Column: no overwrite

I share in this post a nice learning / feature in Excel PowerQuery

Excel VBA: Get local path of file in OneDrive Sync location

I share here an issue you might encounter when using macros with sync'ed files from OneDrive, SharePoint.

Excel Transpose Data

Excel challenge: How to transpose data in Excel from horizontal to vertical

I present here a solution beyond using the Transpose Excel function based on Power Query.

Jira-Excel Integration for bulk edit based on R4J Excel Plugin

I have presented in the R4J German User Group on 2023-09-20 how we use the R4J Excel Plugin to bridge Jira and Excel.

PowerBI: How to import an Excel file located in a SharePoint

I share here a recent learning about how to load data from an Excel file located in a SharePoint into PowerBI.

Excel Index Match

I have stumbled recently again upon the Index/Match combo and forgot that the 3rd argument in MATCH is most needed and shall be set to 0.

Jira Excel VBA Module with Basic functions

I share in this post some examples how to use Jira REST API from Excel VBA. This post is a WIP/Draft. If you are interested in me explaining more, leave a comment.

How to automatically refresh Pivot Tables in Excel

I share a way to refresh Pivot Table automatically in Excel. Credit to Excel Campus

Excel: How to concatenate Table column with delimiter - only visible cells

I have the recurring need to concatenate values in an Excel Table but especially only unfiltered visible cells. (One common use case of mine is to get a list of Jira Issue Keys to easily link to multiple issues)

I explain here to solutions I know and share a VBA macro to do this in one click. 

Excel: Copy Visible Cells only

I was looking for a way in Excel to copy the selection but only of the visible (not hidden) cells.

I share here my solution.

Excel VBA: Table to Json

I had to look for a possibility to convert a Table (aka ListObject) in Excel to a Json String in Excel VBA. I share here my findings and current solution.

Connections Excel Tool Presentation

This post is a placeholder for a potential presentation. 

It was submitted to DNUG Connections German User Group https://dnug.de/call-for-abstracts/

Jira Export Excel Tool

If you want to export a Jira Filter to Excel or csv, you will face the 1000 issues limit so that the built-in export does not work.

I present here a nice Excel/VBA-based tool that make Jira filter export to Excel a one-click solution.

Excel Trick: Average/Formula for visible range only TLDR; SUBTOTAL(10x,

Today I have learned this trick in Microsoft Excel:

How to calculate an average for a range but for only the visible cells? (e.g. if you hide some rows or use a filter in a Table.)

Microsoft Teams: Export Team Members to Excel

In this post I explain how to export the list of a Microsoft Teams Team members to an Excel file including the email of each user, using a PowerShell script from an AutoHotkey script.

This is included in the Teams Shortcuts PowerTool.