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

Get The Best Advice For Designing Pro Forma On MS Excel (IME461E)

Presented by: Mike Thomas
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

MS Excel Expert Mike Thomas Teaches On How To Design Pro Forma On Excel

Have you ever thought that you can use Excel - an application that you have right there on your computer - to create forms? Why go out and buy expensive dedicated programs when you can create your own forms with software you already own and use?

Join this live webinar with expert speaker, Mike Thomas, who will teach you how to execute tasks like, booking forms, sales order forms, invoices, loan agreement forms and surveys; some examples of forms that can be created using Excel. By following real-world examples, you will learn how to build professional, eye-catching form-driven applications and spreadsheets. By adding a splash of colour, 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. The example worksheets will be made available to all attendees.

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. Excel forms will take that pain away!

Session Highlights:

Amongst the topics that will be covered in this session are:

  • Assigning names to cells to make formulas easier to understand
  • Using drop-down menus and checkboxes to make data entry easy
  • Applying data validation and protection to a form to reduce the risk of data-entry errors
  • Applying formatting to make your forms inviting to use
  • Using formulas and functions such as VLOOKUP in your forms
  • Creating a simple automated data entry form

Who should attend?

Any user of Excel who wants to learn how to create form-driven applications and spreadsheets. Attendees should have an introductory level knowledge of Excel. The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel Personal / Executive Assistants

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:
    Event Title: Get The Best Advice For Designing Pro Forma On MS Excel
    Presenter(s): Mike Thomas

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team