-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Articles
Categories
-
Power BI 1
Top Excel articles
-
-
-
Creating a SPLIT function in Excel using lambdasCreating a SPLIT function in Excel using lambdas- Dermot
- Updated:
-
You Are Invited to Post Your Articles at MrExcelWant to document some cool Excel technique? Write it up here.- MrExcel
- Updated:
-
Loan Amortisation ScheduleUsing Excel's new dynamic array forumlas, we can easily generate a loan amortisation schedule.- DRSteele
- Updated:
Use Visible Rows for dynamic row numbers, conditional formatting every other row.
This article shows a method to determine the convex hull for a set of points.
How to get date format as expected when converting text to date
Copy only the visible cells of a source range to only the visible cells of a destination range.
This is an implementation of the gift-wrapping algorithm.
This article shows techniques to manipulate TS functions and Excel shapes.
This article shows how to manipulate tables with TypeScript.
This version offers a user interface for fine tuning
Using the Merge feature to join queries.
A macro to copy-paste from visible cells to visible cells that is available on any open workbook
Template to create a URL for Power Query to make a API Call for Federal Reserve Economic Data (FRED)
Using the FRED Database API rather than using the Add-In makes life much easier!
get STOCKHISTORY to report ALL the data between two dates
Change Sensitivity Label Azure Company Policy VBA Macro
This version allows for pictures and two-colored boxes
This article calculates the path of a ricocheting object inside a closed 2D area.
Office 365, Reduce, Lambda
This article provides a way to add two colours together
This article provides code to generate a kind of chart that Excel does not offer
