charl-potgieter / SpreadsheetBILinks
Excel, VBA, Power Query, Power Pivot / DAX utilities
☆30Updated 10 months ago
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☆51Updated 7 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆84Updated 11 months ago
- Code I've written in the Power Query language (M)☆21Updated 4 months ago
- VBA snippets and code library☆47Updated last year
- A collection of functions for use in Excel Power Query☆9Updated 8 years ago
- Collection of useful Excel functions and subs written in VBA☆19Updated 10 months ago
- Power Query utility library with a functional twist☆48Updated 7 years ago
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆25Updated 8 years ago
- Various M Queries that you can use to make life easy-peasy☆73Updated 7 years ago
- Excel tools and VBA snippets for focused business tasks☆19Updated 2 months ago
- A collection a useful tools for building Microsoft Power BI queries☆78Updated 7 years ago
- A collection of functions for use in Excel Power Query by Tycho Grouwstra☆13Updated 5 years ago
- Modules that extend the functionality of Power BI/Power Query☆129Updated 6 years ago
- Power Query Cheat Sheet☆30Updated 7 years ago
- Complex, Re-Usable, Performance-Optimised VBA Functions (2017 - 2019).☆28Updated 4 years ago
- ☆27Updated 7 months ago
- Excel Files, Notes, Tutorials etc.☆12Updated 2 years ago
- Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)☆83Updated last year
- A collection of data connectors for Power BI☆33Updated 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…☆71Updated 4 years ago
- Visual Basic Applications (VBA) modules written by myself (or credited to others in-comment) to increase the speed and accuracy of data c…☆13Updated 4 years ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆89Updated 6 years ago
- Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.☆81Updated 10 months ago
- A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.☆37Updated 2 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆75Updated last week
- 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
- Dictionary object that extends the Scripting.Dictionary☆21Updated last month
- ☆31Updated 10 months ago