My Shopping Cart
There are no items in your shopping cart.

Excel - How to Build Powerful Form-Based Applications (IME183H)

Presented by: Mike Thomas
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, March 7, 2018
Event Description
See the sneak peek before you buy!
1.0 CPE

Use Excel to Create Forms That Will Make Data Entry Simple and Error-Free

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 organisations, 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.

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 checkboxes: 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
  • Simple automation

Who Should Attend

  • 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
About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel - How to Build Powerful Form-Based Applications
    Presenter(s): Mike Thomas

Our Accreditation Partners Protection Status