mikeprivette / exceltricks
My commonly used Excel and Google Sheet formulas and tricks
☆115Updated 10 months ago
Alternatives and similar repositories for exceltricks:
Users that are interested in exceltricks are comparing it to the libraries listed below
- A curated collection of learning resources to help deepen your understanding of the Microsoft Power Automate service. Updated regularly. …☆88Updated 3 years ago
- Create, edit, and reuse formulas in Excel☆116Updated 2 years ago
- This repository contains Office Scripts based automation solutions that helps end users achieve automation of daily tasks.☆118Updated 3 years ago
- This is an Excel addin, which extends Excel's default functionaility by more than 50 tools.☆37Updated 3 years ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆85Updated 6 years ago
- A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, c…☆177Updated 3 years ago
- Useful Excel VBA Macros - Power user shortcuts to make Excelling more efficient!☆25Updated 5 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆83Updated 9 months ago
- A Rosetta Stone for VBA developers to get into Python☆14Updated last year
- Excel, VBA, Power Query, Power Pivot / DAX utilities☆27Updated 7 months ago
- Compare similar tasks in both Power Query and Python☆15Updated 6 years ago
- Power Query Cheat Sheet☆30Updated 7 years ago
- Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)☆80Updated last year
- Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA☆75Updated 2 years ago
- Excel Files, Notes, Tutorials etc.☆12Updated last year
- VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium☆61Updated 2 years ago
- A collection of functions for use in Excel Power Query☆31Updated 7 years ago
- VBA Code Guidelines☆40Updated 6 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆73Updated 2 weeks ago
- An array class for VBA providing features found in more modern languages☆119Updated last year
- Awesome Power Query☆11Updated last week
- Collection of cutom M functions for Power Query and Power BI☆314Updated last year
- A collection of functions written in Power Query (M)☆16Updated 4 years ago
- Library with VBA, used in multiple projects.☆154Updated last year
- Functions used for Excel and Access reports automation☆99Updated 8 years ago
- DAX Cookbook, Published by Packt☆84Updated 2 years ago
- Set of Functions for Power Query☆23Updated 8 months ago
- Repo for storing custom data connectors for Power BI☆76Updated 2 weeks ago
- Microsoft Hates Greg☆120Updated 2 months ago
- ☆25Updated 4 months ago