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

Excel Tips and Tricks: Every Employers Need to Know (IMEO61V)

Presented by: Mike Thomas
This conference is no longer available
But don't worry, our customer care representatives will help you find an event that meets your needs!
Call on (800) 223-8720
Event Description
1.0 CPE

Learn How to Make Data Entry Easy by Using Checkboxes and Drop-Down Menus in Excel

Data collection and data storage. As an HR Professional you no doubt have to collect and store vast amounts of data. Employee surveys, goals and objectives, training records, absence and vacation records to name but a few examples.

Smaller organizations, with limited budgets simply can’t afford to buy expensive dedicated software to manage the inputting and storage of this type 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”.

This webinar by expert speaker Mike Thomas is all about saving you money. Excel, an application that you have right there on your computer, can be used to create the forms you need for managing data input. So why go out and buy expensive dedicated programs when you can create your own forms with software you already own and use?

You can develop user-friendly forms by adding a bit of color, some drop-down lists, cell protection and simple validation which will make data entry error free and simple for your clients, colleagues and yourself. If you recollect ever having to enter and edit data into an Excel table, you might have mostly found that to be repetitive, frustrating and long-winded experience – Excel forms will make it easy for you. This session will also provide you with sample forms to make the learning easier and practical.

Session Highlights:

  • Making formulas easier to understand by assigning names to cells
  • Make data entry easy by using checkboxes and drop-down menus
  • Reducing the risk of data-entry errors by applying data validation and protection to a form
  • Make your forms inviting to use by applying formatting
  • Use of functions and formulas like VLOOKUP in your forms
  • Developing an easy automated data entry form
  • Learn how to build professional, eye-catching form-driven applications and spreadsheets with real-world examples.

Who Should Attend

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals
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 Tips and Tricks: Every Employers Need to Know
    Presenter(s): Mike Thomas

Our Accreditation Partners Protection Status