Excel Articles

Top Excel articles

Convert your Excel range to BBCode
4.75 star(s) 4 ratings
Downloads
917
Updated
Using Excel's new dynamic array formulas, we can easily Split text cell into columns of words.
0.00 star(s) 0 ratings
Updated
0.00 star(s) 0 ratings
Updated
Using Excel's new dynamic array formulas, we can easily generate a calendar based on a date
0.00 star(s) 0 ratings
Updated
This post shows how to add movement to a workbook with code.
0.00 star(s) 0 ratings
Updated
0.00 star(s) 0 ratings
Updated
This code shows how to animate two charts simultaneously.
5.00 star(s) 1 ratings
Updated
Using a new statsitic, we can rank performance by using cascading tiebreakers
0.00 star(s) 0 ratings
Updated
This project shows how to create and modify shapes with code.
0.00 star(s) 0 ratings
Updated
This code lists all page addresses on a given worksheet.
0.00 star(s) 0 ratings
Updated
Implements a shortest path algorithm for a 3D problem.
0.00 star(s) 0 ratings
Updated
shows how to create complex donut charts and format them with VBA
0.00 star(s) 0 ratings
Updated
Using Excel's new dynamic array forumlas, we can easily generate a loan amortisation schedule.
0.00 star(s) 0 ratings
Updated
Using Excel's new dynamic array forumlas, we can easily generate all permutations of three variables
0.00 star(s) 0 ratings
Updated
18 point Waterfall Chart with Dynamic Ranges and Automatic Chart Update
0.00 star(s) 0 ratings
Updated
Want to document some cool Excel technique? Write it up here.
5.00 star(s) 1 ratings
Updated
The four steps to make sure someone on the Excel team reads your feedback
0.00 star(s) 0 ratings
Updated
How to generate the last 52 Monday dates in a column
0.00 star(s) 0 ratings
Updated
As faster way than clicking 204 times in Text to Columns
0.00 star(s) 0 ratings
Updated

Some videos you may like

This Week's Hot Topics

Top