mikeprivette / exceltricks
My commonly used Excel and Google Sheet formulas and tricks
☆115Updated 8 months ago
Alternatives and similar repositories for exceltricks:
Users that are interested in exceltricks are comparing it to the libraries listed below
- Excel, VBA, Power Query, Power Pivot / DAX utilities☆26Updated 5 months ago
- Create, edit, and reuse formulas in Excel☆115Updated 2 years ago
- Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA☆75Updated 2 years ago
- Exercise files for Visual Basic Application (VBA) for Excel Training☆19Updated 3 years ago
- This repository contains Office Scripts based automation solutions that helps end users achieve automation of daily tasks.☆116Updated 3 years ago
- A collection of functions written in Power Query (M)☆16Updated 4 years ago
- This is an Excel addin, which extends Excel's default functionaility by more than 50 tools.☆35Updated 3 years ago
- Power Query Cheat Sheet☆29Updated 7 years ago
- This repository is created to build a library of reusable VBA / Macro modules and functions for Microsoft Excel.☆82Updated 7 months ago
- Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file☆81Updated 5 years ago
- Excel Files, Notes, Tutorials etc.☆13Updated last year
- A fundamental library of Excel functions written in Excel formula language by LAMBDA function for spreadsheet automation☆53Updated last month
- Visual Basic script that returns table data from a website to excel sheet☆14Updated 2 years ago
- The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.☆71Updated last week
- Compare similar tasks in both Power Query and Python☆16Updated 6 years ago
- VBA Utilities - 100% MAC & PC Compatible☆36Updated last week
- Useful Excel VBA Macros - Power user shortcuts to make Excelling more efficient!☆25Updated 5 years ago
- Functions used for Excel and Access reports automation☆98Updated 8 years ago
- ☆25Updated 2 months 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…☆173Updated 3 years ago
- VBA Code for developing basic web scraping☆11Updated 8 years ago
- [VBA] Collection of Utilities Frequently Used☆44Updated 10 years ago
- A Rosetta Stone for VBA developers to get into Python☆14Updated last year
- Modules that extend the functionality of Power BI/Power Query☆129Updated 6 years ago
- Analyze in Excel for Power BI Desktop☆83Updated 2 years ago
- VBA snippets and code library☆44Updated last year
- Set of Functions for Power Query☆22Updated 6 months ago
- Macros I use in Outlook, Excel etc to make thigns a little speedier☆76Updated 11 years ago
- A collection of functions for use in Excel Power Query☆236Updated 3 years ago
- A curated collection of learning resources to help deepen your understanding of the Microsoft Power Automate service. Updated regularly. …☆84Updated 3 years ago