Excel Archives - Hat Full of Data

20th August 2024

Editing Azure DevOps items in Excel

One of the easiest ways to edit a project in Azure DevOps is to connect Excel to the project. This post walks you through connecting to a project and updating the DevOps items in Excel.

DevOps/Excel

5th March 2023

Export data from Power BI Visuals

We have to accept that the business will want to export Power BI data into Excel. This post explores the options.

Excel/Power BI

21st April 2021

Excel Power Query – VBA to Edit a Parameter Value

This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query.

Excel/Power Query/VBA

Category: Excel

Editing Azure DevOps items in Excel

Export data from Power BI Visuals

Excel Power Query – VBA to Edit a Parameter Value