mikeprivette / exceltricksLinks
My commonly used Excel and Google Sheet formulas and tricks
☆117Updated last year
Alternatives and similar repositories for exceltricks
Users that are interested in exceltricks are comparing it to the libraries listed below
Sorting:
- Create, edit, and reuse formulas in Excel☆116Updated 2 years ago
- A fundamental library of Excel functions written in Excel formula language by LAMBDA function for spreadsheet automation☆58Updated 9 months ago
- This is an Excel addin, which extends Excel's default functionaility by more than 50 tools.☆41Updated 3 years ago
- Functionalities in Excel translated to Python☆231Updated 4 years ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆91Updated 6 years ago
- Excel, VBA, Power Query, Power Pivot / DAX utilities☆29Updated last year
- File tagger and organizer☆48Updated this week
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆25Updated 8 years ago
- Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)☆85Updated 2 years ago
- A Rosetta Stone for VBA developers to get into Python☆14Updated last year
- A collection of functions written in Power Query (M)☆16Updated 4 years ago
- Excel and Power Query projects☆25Updated 5 years ago
- A collection of functions for use in Excel Power Query☆31Updated 7 years ago
- This respository contains content related to Excel formula and VBA. I upload some utilities, macros, dashboards, reports etc to share wit…☆44Updated 4 years ago
- VBA Utilities - 100% MAC & PC Compatible☆38Updated 7 months ago
- Power Query Cheat Sheet☆30Updated 7 years ago
- Regular Expression Functions Excel Add-In☆17Updated 5 years ago
- Exports saved posts and comments on Reddit to a csv file.☆76Updated last year
- A collection of functions for use in Excel Power Query☆241Updated 4 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆87Updated last year
- Reporting system for You Need A Budget☆40Updated 4 years ago
- Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA☆75Updated 3 years ago
- Awesome Power BI☆23Updated 6 years ago
- Visual Studio Code plugin to edit Power Query M code stored inside xlsx/xlsm file☆20Updated 2 years ago
- ☆28Updated 9 months ago
- In Jan 2021 I moved around 29k notes from Evernote to markdown. These are the scripts I used to clean-up, validate, maintain the markdown…☆36Updated 3 years ago
- A useful class to import into Google Apps Script projects when working with Google Sheets.☆52Updated 3 years ago
- ☆101Updated this week
- Collection of recipes for aperture-control☆23Updated 4 years ago
- ☆12Updated 3 years ago