GitHub - evandwight/modernexcel

1 min read Original article ↗

ModernExcel - alpha

The typical Excel file is a mess. Modernize the files you inherit by automatically applying best practices. Inspired by you suck at excel.

ModernExcel aims to bring the modern programming standard of linting to excel.

No further development due to lack of interest

Getting started

  1. Install the plugin
  2. Click View > Show Task Pane (Modern Excel) > Analyze
  3. Apply the recommendations apply the recomendations
  4. Enjoy converting your formulas from the unintelligble = B1 * B2 to the understandable = TAX_RATE * SALARY

Available recommendations

  • Use names not references

Transform your formulas from:

= B1 * B2

To:

= TAX_RATE * SALARY

Coming soon recommendations

  • Use common styling for inputs and calculations
  • Use names for your columns
  • Use tables
  • Use match/index instead of vlookup
  • Use names for magic numbers

Installation

  1. Download setup.zip
  2. Right click setup.zip > properties > unblock
  3. Unzip and run setup.exe