Advanced Excel Applications

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Joseph Chirilov writes an Excel blog for the MSDN website. He often gets Excel writers to contribute.

Today I want to highlight two recent articles from Joseph’s site.

The first written by Mark Gillis is How to Create a Perpetual Yearly Calendar in Excel. The information about dates in here is very useful even if you don’t need to create a calendar. I recommend reading this if you have ever had problems managing dates in Excel.

The second one is a great example of building a complex application. Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles.

Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 1/2

Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 2/2

Enjoy.