Creating a Simple Accounting System with Excel and Power Query - Part 4

Published at October 19, 2019 ·  6 min read

Creating a Simple Accounting System with Excel & Power Query - Part 4 This is the Part 4 of the series Creating a Simple Accounting System with Excel & Power Query. If you missed previous tutorials, you could view them on the following links Creating a Simple Accounting System with Excel & Power Query - Part 1 Creating a Simple Accounting System with Excel & Power Query - Part 2 Creating a Simple Accounting System with Excel & Power Query - Part 3...

Power Query Syntax Highlighter in Sublime Text

Published at October 13, 2019 ·  2 min read

Power Query Syntax Highlighter in Sublime Text Power Query Advanced Editor is a great tool for writing Power Query M code. If you want to dive into the code generated by GUI, you could do it by opening this tool. For Office 365 versions of Excel, the editor also provides intellisense to write your code. However, sometimes I still use my favorite text editor when dealing with M code especially the features like the multiple cursors, syntax higlighting, etc....

Creating a Simple Accounting System with Excel and Power Query - Part 3

Published at October 5, 2019 ·  4 min read

Creating a Simple Accounting System with Excel & Power Query - Part 3 This is the Part 3 of the series Creating a Simple Accounting System with Excel & Power Query. If you missed previous tutorials, you could view them on the following links Creating a Simple Accounting System with Excel & Power Query - Part 1 Creating a Simple Accounting System with Excel & Power Query - Part 2...

Creating a Simple Accounting System with Excel and Power Query - Part 2

Published at September 28, 2019 ·  5 min read

Creating a Simple Accounting System with Excel & Power Query - Part 2 This is the Part 2 of the series Creating a Simple Accounting System with Excel & Power Query. If you missed the Part 1, you can read it here Recap of our Accounting System In the previous post, we have created the meat of our accounting system using tables, name ranges, and data validation. It basically has the following components:...