|
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! Loan agreement forms, surveys, invoices, sales order forms, booking forms etc. are some of the few examples of forms that can be created with the help of Excel. By adding a splash of color, some drop-down lists, cell protection and simple validation, you can generate user-friendly forms that would make your data entry error free and simple for your clients and colleagues. Why go and buy those expensive dedicated programs when you can create forms with the software that
you already use and own? Join this session by expert speaker Mike Thomas and he will show you how. The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel on both Windows and Mac.
Key Learning Objectives- You will be able to define a number of useful functions such as VLOOKUP that can help in form creation
- You will be able to describe how to apply data validation and protection to reduce data entry errors
- You will be able to discuss how to use formatting to make your forms inviting to use
- You will be able to explain how naming cells will make your formulas easier to understand
| |
|
|
|
 | Mike Thomas
Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support to users. He is a subject matter expert in a range of Microsoft technologies including Microsoft Office, Lync/Skype for Business and SharePoint. | |
View More |
| |
|
