Tag: office

OK, today we are talking about tracking projects in Excel for financial purposes.

Accounting software and ERP software is usually time-consuming to implement and costs a lot. For small operations, using Excel can be enough, as long as your country’s transaction documentation legislation allows that. What I mean is that most countries would require you to use a database that wouldn’t allow for the direct deletion of data. And spreadsheets allow that. But anyway, if it’s a small operation or just an internal project we’re tracking, let’s see how we are gonna approach it.Continue reading...

Today I want to share some Excel magic with you. If you are anything like me you probably want to optimize your workflow a lot. One way to do that is using Excel macros. But these require some VBA programming knowledge. I’ve been using macros to save time for quite some time now and want to share my favorite one with you.

Today we are making a macro that assembles many files into one. But what’s more interesting, I am going to show you a way to put this macro as an Excel function, in its own ribbon tab. We are also going to be creating a simple macro to delete empty rows, to make our own ribbon tab look better.Continue reading...