Building Powerful Form-Based Applications In Excel With Ease

MessageThis Webinar is over
Date Oct 3, 2018
Time 01:00 PM ET
Cost $149.00
Online
Use Excel To Create Forms That Will Make Data Entry Simple , easy and Error-Free
Presenter: Mike Thomas


Booking forms, sales order forms, invoices, loan agreement forms and surveys: these are just a few examples of forms that you need to create to run your business. Smaller organizations, with limited budgets simply can’t afford to buy expensive dedicated software to manage the inputting and storage of information, however even those companies with large budgets often find that their requirements can’t be met by what is “out in the marketplace”.
Have you ever thought that you can use Excel – an application that you have right there on your computer – to create forms? You can save both time and money! The list of examples of forms that can be created using Excel is endless. By adding a splash of color, cell protection and some drop-down lists and simple validation, you can create user-friendly forms that will make data entry simple and error-free for yourself, your colleagues and your clients. If you’ve ever had to enter and edit data into a table in Excel, you’ve probably found it to be a long-winded, repetitive and frustrating experience. Knowledge of excel forms will help to take that pain away!
Join this session with expert speaker Mike Thomas, who will discuss real-world examples to help you learn how to build professional, eye-catching form-driven applications and spreadsheets. There is no “Create a Form” command in Excel. Creating forms requires the use of a number of built-in Excel features.Mike will help you understand the different built-in features that you need to build forms, and how you can use them to make your work easier, less time-consuming, and free from errors.
The training will be delivered using the latest version of Excel for Windows although much of the functionality is available in earlier versions of Excel
Session Highlights
This session will cover Excel features that can be used to create forms, including:
  • Naming cells: To make formulas easier to understand
  • Drop-down menus and check boxes: To make data entry easy
  • Data validation and protection: To reduce the risk of data-entry errors
  • Formatting: To make your forms inviting to use
  • Formulas and functions such as VLOOKUP/HLOOKUP
  • Simple automation
Who Will Benefit
  • Any user of Excel who wants to learn how to create form-driven applications and spreadsheets
  • Those who have an introductory level knowledge of Excel
Ask a question at the Q&A session following the live event and get advice pertaining to your situation, straight from our expert speaker.

About Presenter:

Mike Thomas
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.
 
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

 


comments powered by Disqus
Create your own event
Turn your passion into a business.
Join our mailing list