charl-potgieter / SpreadsheetBI
Excel, VBA, Power Query, Power Pivot / DAX utilities
☆28Updated 8 months ago
Alternatives and similar repositories for SpreadsheetBI:
Users that are interested in SpreadsheetBI are comparing it to the libraries listed below
- This repository contains all projects, coding standards, boilerplate, and best practices. This is intended to share my experience and exp…☆12Updated 7 years ago
- Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA☆75Updated 3 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆83Updated 10 months ago
- Collection of useful Excel functions and subs written in VBA☆19Updated 8 months ago
- VBA snippets and code library☆47Updated last year
- Excel tools and VBA snippets for focused business tasks☆18Updated 3 weeks ago
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆25Updated 8 years ago
- A collection of M code to get various formats from Excel sheets in Power Query☆51Updated 7 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
- A collection of functions for use in Excel Power Query☆9Updated 7 years ago
- Code I've written in the Power Query language (M)☆22Updated 2 months ago
- Power Query utility library with a functional twist☆48Updated 7 years ago
- Complex, Re-Usable, Performance-Optimised VBA Functions (2017 - 2019).☆28Updated 4 years ago
- Personal Productivity AddIn for Excel and collection of useful snippets/tools.☆22Updated 9 years ago
- ☆27Updated 5 months ago
- A collection of functions for use in Excel Power Query by Tycho Grouwstra☆13Updated 4 years ago
- A collection of data connectors for Power BI☆33Updated 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
- A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.☆37Updated 2 years ago
- Common VBA Library: Contains functions that are missing in the VBA language. Mainly for use with Excel.☆61Updated 4 years ago
- Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.☆78Updated 9 months ago
- Excel VBA Functions Package for Business Data Analysts. VBA has a reputation among some for being a "step child" programming language, ho…☆69Updated 4 years ago
- Two Class modules that are used to format a VBA Userform using the material design☆41Updated 4 years ago
- Some Excel macros☆37Updated 3 years ago
- A collection of basic auxiliary classes and modules to complement VBA.☆15Updated 2 years ago
- SAP BO Analysis Excel addin automation using VBA☆17Updated 6 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆73Updated last week
- A collection a useful tools for building Microsoft Power BI queries☆76Updated 7 years ago
- VBA Code Guidelines☆40Updated 6 years ago
- [VBA] Collection of Utilities Frequently Used☆45Updated 10 years ago