Excel Solutions

How to Make a Free Invoice Generator with Excel

If you are tracking projects and payments in a simple excel sheet, follow this article and convert your Excel workbook into an automated invoice generating tool. With a single click, instantly prepare invoices for all your clients. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI We need 3 sheets. Sheet1 will carry the invoice...

Read more »

How to Easily Manage and Rename Image Files from Internet with Excel

As a web designer or a PowerPoint designer, you might be collecting lots of images from the internet for references. However, referring to these collected images during a project is a hectic task as the collected images are either saved with an improper name or with default names. Renaming these images with an appropriate name will help you to save time. In this article, we will show how to do that easily with Excel Download Now If you want to start to use the software as soon as possible,...

Read more »

How to Convert UTM Coordinates into Latitude and Longitude values via Excel VBA

With UTM converter you can easily convert UTM coordinates into Latitude and Longitude values. A Universal Transverse Mercator (UTM) coordinate is made up of a zone number, an easting, a northing and a hemisphere (N/S). Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI As shown in the image, leave top 4 rows of the excel sheet for...

Read more »