charl-potgieter / SpreadsheetBILinks
Excel, VBA, Power Query, Power Pivot / DAX utilities
☆29Updated 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
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆84Updated last year
- A collection of M code to get various formats from Excel sheets in Power Query☆51Updated 7 years ago
- Modules that extend the functionality of Power BI/Power Query☆130Updated 6 years ago
- A collection of functions for use in Excel Power Query☆9Updated 8 years ago
- Code I've written in the Power Query language (M)☆21Updated 4 months 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
- Collection of useful Excel functions and subs written in VBA☆20Updated 10 months ago
- Excel tools and VBA snippets for focused business tasks☆20Updated 3 months ago
- Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)☆83Updated last year
- ☆28Updated 8 months ago
- A collection of functions for use in Excel Power Query by Tycho Grouwstra☆13Updated 5 years ago
- Library with VBA, used in multiple projects.☆155Updated last year
- VBA snippets and code library☆49Updated last year
- Various M Queries that you can use to make life easy-peasy☆73Updated 7 years ago
- Power Query Cheat Sheet☆30Updated 7 years ago
- Power Query utility library with a functional twist☆48Updated 7 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆76Updated 2 weeks ago
- SAP BO Analysis Excel addin automation using VBA☆17Updated 7 years ago
- Common VBA Library: Contains functions that are missing in the VBA language. Mainly for use with Excel.☆61Updated 5 years ago
- A collection of functions for use in Excel Power Query☆237Updated 4 years ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆89Updated 6 years ago
- A collection a useful tools for building Microsoft Power BI queries☆80Updated 7 years ago
- Complex, Re-Usable, Performance-Optimised VBA Functions (2017 - 2019).☆28Updated 4 years ago
- A repository of various modules and classes for interacting with Excel and doing other... things.☆59Updated 4 months ago
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆25Updated 8 years ago
- A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.☆37Updated 2 years ago
- [VBA] Collection of Utilities Frequently Used☆44Updated 10 years ago
- An array class for VBA providing features found in more modern languages☆123Updated last year