Click Image to View Video.
This Application allows you to assign Criteria by which your Data should be tested! Wanted to buy products or parts 'only if' they satisfy certain criteria? Don't know if they all do, as there are too many stats to look at? We've done just that in this Application. It flags for Failures, counts them and allows you to change the Criteria.
Click Image to View Video.
A major need is when each week or each month you've been keeping data or exporting data into Excel spreadsheets, only to find that years have gone by and you'd like to consolidate them into ONE file, or Database. A major advantage of Automation is to go look in lots of folders for the files that are of interest to you, open them, gather relevant information, put them in a Master file, close them and move on to the next file in the folder. This can be done while you go and make a cup of tea. A process that is unthinkable to do manually when 1000's or even 100's of files are involved.This is one of the many services we offer to our clients.
Click Image to View Video.
One of the many services we offer at Excel-lentsolutions.com. Data Creation is an important aspect of keeping yours or your customer's data safe, but when testing needs to be done, or you need an application built for you and the data needs to be of the right format having data to give to a third-party can expedite your process. This can be as complex as having no longer than 8 Characters for your Serial number or Model number with the first one being a Letter, the next 2, numbers, and the remainder, either.
Click Image to View Video.
A regularly occurring event such as an Annual Tax Filing may require a year's worth of data to be analyzed and allocated, amalgamated together in category groups and presented in a form for the country's Tax body, such as HMRC, IRS, etc. This is an application of how quickly a large volume of data can be funneled through to the right 'Form' via Automation. This concept could easily be applied to process data, that is arriving regularly, for instance every 2 hours.
Click Image to View Video.
You wouldn't expect a Demo about an Excel Application that generates an SRT file to have anything but an SRT file in the Video Demo, right? If you're creating content online, such as Videos, you've no doubt come across the term SRT file which is for the Captions of your video. We created this Application to do just that - Create an SRT file which you can import back into your Video timeline in a matter of minutes, saving you much time in Title Card Creation. Watch the video to see how it's done.
Click Image to View Video.
The Sudoku Solver is a short demo showing an Application that solves Sudoku puzzles of different difficulty using the power of Excel Automation in a matter of Seconds.
Click Image to View Video.
If you're copying data from the web, you're probably familiar with the fact that it seldom arrives in the same format it is presented on the web page, and even if it does, it is rarely in a format that we might desire. Getting a piece of intelligent code that looks for your data, recognizes it and puts it in a correct format can not only save a lot of time, but the data can then be used in Excel to get valuable information from it, for instance through sorting, filtering, etc. But it doesn't have to be from the web even. When your supplier or vendor sends you information in a different format than your own Company's reporting, you want a quick way to compare like with like. And this is where Automation will serve you quickly. We can help you with that.
Click Image to View Video.
A secret message hidden in Excel, or a way for the program to track where your mouse is and help users with their user experience. Whichever way you look at it, there's much that we can achieve for you and your Company's needs through Automation that is totally bespoke.