Excel Pro Logo
Free Resources
Simple String Builder

A simple and very fast string builder. Used to concatenate strings around 400 times faster than using an ampersand.


Advanced String Builder

An enhanced version of the Simple String Builder with many additional functions such as storing concatenated strings for later use.


Time and date functions

A collection of 22 easy to use time and date functions. No Excel experience required; just pop in your dates or times with the required interval to get the result.

    Days
  • Get the number of days between two dates
  • Get the number of whole work days (Mon - Fri) between two dates
  • Add or subtract a number of work days (Mon - Fri) from a given date
  • Get the day of the week for a given date
  • Get the date of the first day (Sunday) in the week from a week number
  • Get the date of the last day (Saturday) in the week from a week number
  • Get the first day (Sunday) of the week for a given date
  • Get the date of the last day (Saturday) in the week for a given date
    Weeks
  • Get the international standard week number for a given date
  • Get the ISO standard week number for a given date
  • Add or subtract weeks from a given date
    Months
  • Get the number of days in a month
  • Add or subtract months from a given date
  • Add or subtract months from a given date and return the last day of the calculated month
  • Add or subtract a number of months from a given date and return the month
    Quarters and years
  • Check if a year is a leap year
  • Add or subtract quarters from a given date
    Minutes and seconds
  • Add or subtract a number of seconds from a time
  • Get the difference in seconds between two times
  • Add or subtract a number of minutes from a time
  • Get the difference in minutes between two times
    Other
  • Add or subtract an arbitrary interval from a date

Full screen application

Excel doesn't have to look like Excel. Making a presentation look clean and professional helps to focus attention on your data and to better engage your audience. This workbook contains subroutines for hiding various elements of the user interface such as the ribbon, formula bar and cell grid to achive a look similar to a stand alone .exe application.


Highlightable image

A useful tool for presentations, logistics planning, medical diagrams or any other situation where users need to be able to mark up an image quickly without the fuss of adding a shape from the Insert menu. Simply click on the image to mark it. The image is replaceable and resizable, as are the markers used.

Comments on this article
Add a comment