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☆118Updated 2 years ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆94Updated 6 years ago
- This is an Excel addin, which extends Excel's default functionaility by more than 50 tools.☆38Updated 3 years ago
- A fundamental library of Excel functions written in Excel formula language by LAMBDA function for spreadsheet automation☆59Updated 10 months ago
- ☆27Updated 11 months ago
- A collection of functions written in Power Query (M)☆16Updated 4 years ago
- A Rosetta Stone for VBA developers to get into Python☆14Updated 2 years ago
- Useful Excel VBA Macros - Power user shortcuts to make Excelling more efficient!☆29Updated 6 years ago
- A curated collection of learning resources to help deepen your understanding of the Microsoft Power Automate service. Updated regularly. …☆94Updated 4 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
- VBA Utilities - 100% MAC & PC Compatible☆37Updated 8 months ago
- Excel, VBA, Power Query, Power Pivot / DAX utilities☆29Updated last year
- Visual Basic Script Refresher for Excel files with Power Query and PowerPivot model☆25Updated 8 years ago
- Visual Basic for Applications macros for using the PDFTables.com API; contributed by Dan Elgaard☆48Updated 2 years ago
- Functionalities in Excel translated to Python☆229Updated 4 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
- Excel add-in with helpers for charting, formatting, and general pain points☆17Updated 3 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆75Updated last month
- Awesome Power Query☆13Updated this week
- A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, c…☆185Updated 3 years ago
- This respository contains content related to Excel formula and VBA. I upload some utilities, macros, dashboards, reports etc to share wit…☆45Updated 4 years ago
- A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.☆38Updated 2 years ago
- This VSTO Add-In creates a custom "Favorites" ribbon. Key distinctive attributes include dedicated buttons for changing the visibility/s…☆68Updated last year
- A collection of functions for use in Excel Power Query☆31Updated 8 years ago
- Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA☆75Updated 3 years ago
- VBA snippets and code library☆48Updated 2 years ago
- Excel and Power Query projects☆26Updated 5 years ago
- A useful class to import into Google Apps Script projects when working with Google Sheets.☆51Updated 3 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆88Updated last year
- Common VBA Library: Contains functions that are missing in the VBA language. Mainly for use with Excel.☆60Updated 5 years ago