charl-potgieter / SpreadsheetBI
Excel, VBA, Power Query, Power Pivot / DAX utilities
☆28Updated 7 months ago
Alternatives and similar repositories for SpreadsheetBI:
Users that are interested in SpreadsheetBI are comparing it to the libraries listed below
- 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
- Visual Basic Applications (VBA) modules written by myself (or credited to others in-comment) to increase the speed and accuracy of data c…☆12Updated 4 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆83Updated 9 months ago
- Excel tools and VBA snippets for focused business tasks☆16Updated 4 months ago
- VBA snippets and code library☆45Updated last year
- Collection of useful Excel functions and subs written in VBA☆19Updated 7 months ago
- 🎮 Style guideline for writing clean and maintainable VBA.☆26Updated 3 years ago
- [VBA] Collection of Utilities Frequently Used☆45Updated 10 years ago
- Set of Functions for Power Query☆24Updated 9 months ago
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆24Updated 8 years ago
- A collection of functions for use in Excel Power Query by Tycho Grouwstra☆13Updated 4 years ago
- Code I've written in the Power Query language (M)☆22Updated last month
- Complex, Re-Usable, Performance-Optimised VBA Functions (2017 - 2019).☆27Updated 4 years ago
- A collection of M code to get various formats from Excel sheets in Power Query☆50Updated 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…☆68Updated 4 years ago
- A collection of basic auxiliary classes and modules to complement VBA.☆14Updated 2 years ago
- Personal Productivity AddIn for Excel and collection of useful snippets/tools.☆22Updated 8 years ago
- A collection of functions for use in Excel Power Query☆9Updated 7 years ago
- My collection of macros VBA Excel☆16Updated 5 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
- Power Query Cheat Sheet☆30Updated 7 years ago
- Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.☆75Updated 8 months ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆72Updated last week
- An easy to use VBA userform for visualizing macro progress.☆12Updated 4 years ago
- ☆25Updated 5 months ago
- My Excel VBA projects☆14Updated 9 years ago
- Common VBA Library: Contains functions that are missing in the VBA language. Mainly for use with Excel.☆61Updated 4 years ago
- Two Class modules that are used to format a VBA Userform using the material design☆41Updated 4 years ago
- A repository of various modules and classes for interacting with Excel and doing other... things.☆58Updated last month