Ms Excel
Designing a Form in Excel
Data entry forms, printable form design, and form controls
2 CPD credits on completion
Enrol Now
Certificate on completion
Downloadable resources
Self-paced learning
About This Course
Course Information
This course covers all aspects of how to design a form in Excel, and how to use this skill in your role.
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 2 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 2 units.
Course Sections
This Course is made up of the following sections:
- Designing a Form in Excel – Part 1(Video and Quiz)
- Designing a Form in Excel – Part 2 (Video and Quiz)
- Additional Reading Materials
What You Will Learn
- Apply Excel's built-in data entry form to record, search, and scroll through database records
- Describe how combo boxes, check boxes, and other form controls work in the Developer tab
- Explain how to design a printable form with aligned fields, consistent fonts, and clear input areas
- Identify the keyboard shortcut Ctrl+T for converting data into a table before using data forms
- Distinguish between form controls for data entry and form controls for printable document design
Who This Course Is For
- Accountants and administrators who maintain databases in Excel and want faster data entry
- Office professionals who need to create fillable forms that users can print and complete
- Excel users who want to learn about Developer tab features like combo boxes and form controls
Prerequisites
- Basic Excel skills including entering data, formatting cells, and navigating worksheets
- No prior experience with Excel forms or the Developer tab is needed
Frequently Asked Questions
Course Details
CPD Credits2
CertificateYes
Pricing
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
CPD certificate on completion
Downloadable resources
Self-paced learning
Expert-led content
24/7 access
Mobile friendly
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now