Free Excel Tools and Macros

Free Excel tools

As we create more free tools for you to enjoy we will list them here on this page.

Project Management Template

A template to help any project managers create better plans faster.

Project Management GANTT chart in Excel

Personal Finances Planner and Budget

Get your personal finances back under control with this free and easy tool for planning and tracking your monthly budget. It’s really simple to use and after using it you will find that you have a much greater understanding of where your money goes and how you could reduce your spending.

Dashboard showing information about your personal budget and finances

Excel – Art

A good spreadsheet can often feel like a piece of artwork but this tool really is…! You can load in your favourite images and turn them into Excel art, with the cells of the spreadsheet filled in the appropriate colours to make the picture.

Mona Lisa in Excel

A classic made even more beautiful in Microsoft Excel. She is definitely smiling now 🙂

Stock Market Day Trading Analysis

As analytical people we thought we could do well day trading the stock market. However it quickly became clear that we would lose a lot of money – so we stopped, but not before making a neat little tool to download and present stock data….

Stock chart with EMA SMA MACD indicators

Lottery number picker

We decided it was time to increase our chances of winning big on the lottery and thought we should share this with all the lovely people who visit our site. Remember a share a few bob if you win the jackpot 😉

Sudoku puzzle creator and solver

For those who love playing Sudoku here is a great game for you to play, with 6 different difficulty levels and lots of options for helping you solve the puzzles faster (if you need help!). Enjoy.

Screenprint of the Sudoku puzzle creator

Tool to help small businesses manage their invoicing

A great little tool for small to medium size businesses who want to manage their invoicing in a controlled manner without investing in expensive systems. The Excel file includes a custom ribbon with various functionalities such as creating PDFs, changing invoice status and recording payments. All the features are controlled by Excel macros and the workbook is protected to stop you editing invoices after they have been finalised.

Tool for recording and tracking employee vacations

A useful tool for recording how many days holidays your team members are entitled to and how many they have left. The tool includes macros for entering in the holiday information, and you can have any year period (eg. Jan – Dec, Apr – Mar). When you first open the file it asks you for the year start date so you can use it year after year. There are lots of other useful features too so give it a try for free!

 

 

  • Mike

    Holiday tracker tool is very useful. Thank you.

    • Philip Norton

      Pleased to hear it, thanks for the feedback Mike 🙂

  • Phillip Cole

    Holiday tracker is great. Could you consider adding a separate option for 1/2 day sick vs. 1/2 day vacation?

    • Philip Norton

      Hi Philip, I am working on a more flexible version of the tool which will allow you to specify half day allocations for different types of leave. Watch this space! Phil

      • Philip Norton

        Hi Philip, this feature is now available in the premium version of the holiday calendar sheet which you can find out more about here http://www.excel-macros.co.uk/staff-annual-leave-calendar-premium/

      • Gisela Gomes

        I recorded a half day leave on my tracker but it counted as a full day. And I think that I have the premium file because
        I bought it today, could you n kindly advise?

        • phil192

          Hi Gisela, when you recorded the leave, did you change the leave amount to 0.5? It is defaulted to 1 so it will record it as a full day unless you change it.

    • Philip Norton

      Hi Philip, this feature is now available in the premium version of the holiday tracker which you can find out more about here http://www.excel-macros.co.uk/staff-annual-leave-calendar-premium/

      • Phillip Cole

        Thank you. Much Appreciated.

  • c peng

    Hello please can we get a tool that monitors changes in category and salary of employees? the Holiday Tracker has been a great tool thanks for that.

    • Philip Norton

      Thanks for the suggestion. It is on the list 🙂

  • Cathy Keenaghan

    Hi, great tool, I want to name the sheet 2017 and start another one for 2018 but to unprotect it i need a password? is this possible?

    • Philip Norton

      Hi Cathy, please just download a new copy of the tool. When it opens you can select the year date for 2018.

  • Ken Power

    Hello Philip
    In the days taken, days left and sick days field, I have #Ref! and am unable to correct. Could you assist?
    Thanks, Ken

    • phil192

      Hi Ken, did we solve this on email?

      • Ken Power

        Hello Philip

        All sorted! Thank you.

        Ken

  • Steve Chase

    Hi, absolutely love your sheets, thank you so much indeed, with reference to the Holiday tracker, would it be possible to add another macro button for non certified sick days please basically an option to track sick days without medical certificate? thank you, Steve.

    • phil192

      Hi Steve. On the premium leave tracker all of the leave types are customisable so it is possible to use one of them to track non-certified sick days.

  • Gisela Gomes

    Hi
    Could w please get a training tracking tool? That records and tracks the training for the company.
    An appraisal followup spreadsheet would also be nice, where yo record the performance issues identified during the appraisal (good or bad) the necessary follow up actions, and the outcomes at the end of a given period

    • phil192

      Thanks for the suggestion Gisela 🙂