-
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:
Latest reviews
-
MoreQuery for MacThis is most useful article to me as a Mac Excel user. Detailed explanation is invaluable...
- nk24
We can get rid of things like punctuation from a textstring in a cell.
This article shows how to list parents and children that form the structure of Web pages.
This article shows six different ways to draw a flag.
A simple method of taking a PNG or full-page PDF snapshot of a webpage
Getting the right security with Stock Data Types is frustrating
VBA: Enhance and speed up random numbers and sorting, using spill functions
Speed up searching in long list data validation & easy to set various specific behaviors
VBA Macro to create Word & Phrase Frequency
Creating a SPLIT function in Excel using lambdas
Using Excel's stock data types, we can calculate the cross currency rates from a few currencies.
Copying Lambdas between workbooks and keeping them updated
How to translate text to multiple languages.
Column title formula for cells extracted from the field selector
A new Rolling Calendar Control as a Date & Time Picker
This article shows how to load different pictures to a user form control.
This code shows how to transfer an image to worksheet cells. Each pixel will correspond to a cell.
Using Excel's UNICHAR function, we can create a grid of nearly all the characters in Excel
How to make more effective basic API calls in Power Query
