charl-potgieter / SpreadsheetBILinks
Excel, VBA, Power Query, Power Pivot / DAX utilities
☆29Updated last year
Alternatives and similar repositories for SpreadsheetBI
Users that are interested in SpreadsheetBI are comparing it to the libraries listed below
Sorting:
- Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA☆75Updated 3 years ago
- This repository contains all projects, coding standards, boilerplate, and best practices. This is intended to share my experience and exp…☆12Updated 7 years ago
- A collection of M code to get various formats from Excel sheets in Power Query☆52Updated 8 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆88Updated last year
- Code I've written in the Power Query language (M)☆21Updated 7 months ago
- Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)☆85Updated 2 years ago
- Power Query utility library with a functional twist☆48Updated 8 years ago
- Various M Queries that you can use to make life easy-peasy☆74Updated 8 years ago
- Modules that extend the functionality of Power BI/Power Query☆130Updated 7 years ago
- A collection a useful tools for building Microsoft Power BI queries☆81Updated 7 years ago
- Excel VBA Functions Package for Business Data Analysts. VBA has a reputation among some for being a "step child" programming language, ho…☆74Updated 4 years ago
- VBA snippets and code library☆48Updated 2 years ago
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆25Updated 8 years ago
- A collection of functions for use in Excel Power Query by Tycho Grouwstra☆14Updated 5 years ago
- Collection of useful Excel functions and subs written in VBA☆20Updated last year
- A collection of data connectors for Power BI☆33Updated 7 years ago
- A collection of functions for use in Excel Power Query☆242Updated 4 years ago
- Library with VBA, used in multiple projects.☆161Updated last year
- Visual Basic Applications (VBA) modules written by myself (or credited to others in-comment) to increase the speed and accuracy of data c…☆13Updated 5 years ago
- Decompiler for Power Query code☆18Updated 7 years ago
- ☆28Updated 11 months ago
- Collection of Power Query snippets as shown on powerqueryformatter.com☆43Updated 2 years ago
- Common VBA Library: Contains functions that are missing in the VBA language. Mainly for use with Excel.☆61Updated 5 years ago
- Power Query Cheat Sheet☆30Updated 7 years ago
- A heavily object oriented solution that wraps the core functionality of the MS ActiveX Data Objects Library. This is a highly modified ve…☆14Updated 3 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆77Updated last month
- SublimeText language files for the Power Query formula language (M)☆21Updated 2 years ago
- [VBA] Collection of Utilities Frequently Used☆44Updated 11 years ago
- SAP BO Analysis Excel addin automation using VBA☆17Updated 7 years ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆94Updated 6 years ago