Generated by All in One SEO v5.0.0.1, this is an llms.txt file, used by LLMs to index the site.

# Witting Excel

## Sitemaps

- [XML Sitemap](http://www.wittingexcel.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Using Excel to Automate Business Tasks](http://www.wittingexcel.com/using-excel-to-automate-business-tasks/) - We all have to deal with them. They are hair pulling, mind numbing and time wasting. Some are inherited from the systems we work within but many turn out to be self-inflected. I’m referring to inefficient tasks, you know - those processes that all businesses have - mundane, repetitive overhead – costing real time and
- [Why Hire an Excel Consultant](http://www.wittingexcel.com/why-hire-an-excel-consultant/) - In previous articles, I’ve talked about the benefits of using Excel to Automate Business Tasks. I’ve also shared common areas were you may be able to use Excel Automation along with a few examples. Often, small and medium size businesses don’t have the skills or the time to spend automating these tasks. There is just
- [The Benefits of Business Automation](http://www.wittingexcel.com/the-benefits-of-business-automation/) - Every business has processes that can be automated. But is it worth it? Of course automating tasks does cost both time and money. But there are many benefits that must be taken into consideration, some of which are not easy to define or measure, but can have a real impact on any business. Here are
- [Identifying Good Candidate Tasks for Automation](http://www.wittingexcel.com/identifying-good-candidate-tasks-for-automation/) - There are several things to look at when trying to identify tasks and processes that might be well suited for business automation. Here are some things to consider. Look at the big picture Make sure you look at the big picture and examine your processes from start to end. This will help you to identify
- [Automation – Not Just for Factories](http://www.wittingexcel.com/automation-not-just-for-factories/) - Automation is known to increase productivity and improve quality while decreasing errors and wait times. When most people think about automation, they usually think of factories with robots or complex manufacturing equipment used to make millions of widgets. But the reality is automation surrounds us and we use it every day to improve our lives,
- [How to hire an Excel Consultant](http://www.wittingexcel.com/how-to-hire-an-excel-consultant/) - There are many Excel consultants and not all are equally qualified. It is important to do your homework when trying to find someone to help you with your project. Here are some things you should look for in a consultant… Proof of Experience Look for an Excel Consultant with experience. They should be able to

## Pages

- [Home](http://www.wittingexcel.com/) - Excel & Access Projects We can help with all your Excel or Access projects including VBA programming, spreadsheet templates, custom reports, dashboards and database integration. Business Automation We can improve and streamline any business process: integrate data, reduced errors and improved employee productivity. Custom Software We provide custom software consulting services including development of design
- [Testimonials](http://www.wittingexcel.com/testimonials/) - Testimonials "Witting Innovation is always there when I need them. Whether it is a large scale excel project or just a ten minute efficiency fixer, I know I can always rely on Brent to get the job done." - Max L. (March 2018) "Witting Innovation has quickly developed data report tools for us over the
- [Contact](http://www.wittingexcel.com/contact/) - We love to work with people to create tools and software to help streamline business work flow and processes. We offer free consultations and are happy to look at your project. Please fill out the form below and we will contact you back to discuss your project with you. You can also contact us directly:
- [Contact](http://www.wittingexcel.com/contact-2/) - We love to work with people to create tools and software to help streamline business work flow and processes. We offer free consultations and are happy to look at your project. Please fill out the form below and we will contact you back to discuss your project with you. You can also contact us directly:
- [Thankyou](http://www.wittingexcel.com/thankyou/) - Thanks for sending your project details over to us. We will review the details as soon as possible and then contact you to discuss your project.
- [Excel Programming](http://www.wittingexcel.com/excel-programming/) - EXCEL AND ACCESS PROJECTS Excel is a very powerful tool, capable of much more than most people realize. Through creative functions and VBA programming, Excel can be used to automate many mundane tasks, perform complex analysis, crunch large sets of data and generate custom reports. Witting Innovation has over 12 years of experience in Excel
- [Thankyou](http://www.wittingexcel.com/thankyou-2/) - Thanks for sending your project details over to us. We will review the details as soon as possible and then contact you to discuss your project.
- [Excel, Access, & VBA Consulting & Programming](http://www.wittingexcel.com/excel-software-services/) - COMMON TASKS MAY INCLUDE EXCEL AND ACCESS PROJECTS Excel is a very powerful tool, capable of much more than most people realize. Through creative functions and VBA programming, Excel can be used to automate many mundane tasks, perform complex analysis, crunch large sets of data and generate custom reports. Witting Innovation has over 12 years
- [Blog](http://www.wittingexcel.com/blog/)
- [Portfolio](http://www.wittingexcel.com/portfolio/)
- [Consultants](http://www.wittingexcel.com/consultants/) - Consultants Darryl Zitting Darryl has both a bachelors degree and masters degree in bioengineering from the University of Utah. Darryl has over 10yrs engineering experience including manufacturing engineering, automation and medical product design. Darryl has successfully developed a number of medical products from concept to completion including all aspects of the design process as well
- [About Us](http://www.wittingexcel.com/about-us/) - With over 15 years of experience, we have worked for a wide range of companies ranging from Ford Motor Company to small one man startups – we’ve seen it all. Our experience and background allow us to quickly determine the best solution for your needs and deliver it in a timely manner and effective cost.
- [Sample Page](http://www.wittingexcel.com/sample-page/)
- [Recent Site Activity](http://www.wittingexcel.com/recent-site-activity/)
- [Product Design & Engineering](http://www.wittingexcel.com/product-design-engineering/)

## Portfolios

- [User Defined Functions (UDFs) for common calculations](http://www.wittingexcel.com/portfolio/user-defined-functions-udfs-for-common-calculations/) - User Defined Functions (UDFs) are functions that can be inserted directly into formulas within cells just like SUM, AVG, VLOOKUP and the other built in functions. The difference is that the functions are custom made to your unique calculations. In this project, we developed a set of User Defined Functions (UDFs) for a client who
- [Data Manipulation and Automatic Report Generation](http://www.wittingexcel.com/portfolio/data-manipulation-and-automatic-report-generation/) - Here is an example of tool we did for a client to import and manipulate data from another system. A client was manually processing data files from a piece of lab equipment. This included adding various baseline adjusting calculations, adding second derivative calculations and creating multiple charts and graphs. In all, the client was spending
- [Database Integration](http://www.wittingexcel.com/portfolio/database-integration/) - Here is an example of integrating Excel with an external database and custom forms. Using a database has many advantages. Databases are great for handling large and interconnected sets of data. They also allow multiple people to use and update the data at the same time. In these kinds of projects, Excel basically becomes the
- [Financial Calculator](http://www.wittingexcel.com/portfolio/financial-calculator/) - Excel is great for creating financial models and calculators. These are some of our most frequently requested items. In this project, we had a client who wanted help creating loan repayment schedules and calculating effective interest rates for loans with one borrower and many different lenders. Because it is a blended loan, regular online calculators
- [VBA Automation - Custom Time Sheet](http://www.wittingexcel.com/portfolio/vba-automation-custom-time-sheet/) - We developed this workbook for a company that needed a cost effective way to keep track of and calculate workers time sheets. Their business is heavily regulated and has some interesting rules which required a custom solution instead of an off-the-shelf system.
- [Custom Dashboards and Report Cards](http://www.wittingexcel.com/portfolio/custom-dashboards-and-report-cards/) - Dashboards and Report Cards can be great tools to help manage a business. A great dashboard is one that shows key summary information in an easy to ready graphical manner. The data for dashboards generally comes from one or more internal systems such as accounting, production or sales systems and can be quickly and easily
- [VBA Automation - Custom Time Sheet](http://www.wittingexcel.com/portfolio/vba-automation-custom-time-sheet-2/) - One of our clients needed a custom scheduling application to help the plan their projects. Their company already had information in spreadsheets and just needed our help to streamline part of the process and to provide a nice graphical representation of their schedule in a Gantt Chart.
- [VBA Automation - Database Integration](http://www.wittingexcel.com/portfolio/vba-automation-database-integration/) - This workbook helps a client manage their entire Ebay store. The system tracks thousands of parts as they move through the companies processes. The workbook interfaces with a database on a server where all the information is actually stored, allowing multiple users to access the same information simultaneously. Tools have been developed that allow users
- [VBA Automation - Device Integration](http://www.wittingexcel.com/portfolio/vba-automation-device-integration/) - We put this spreadsheet together to provide an interface for communication with a device. The spreadsheet communicates serially with a device and can issue commands manually or automatically. It then logs all the responses from the device. This spreadsheet provided a quick and flexible way to integrate with lab equipment under development.

## Categories

- [Uncategorized](http://www.wittingexcel.com/category/uncategorized/)