Microsoft Excel: Automating Spreadsheets with Forms & Macros
This course is designed to build on your existing skills and knowledge of Microsoft Excel through introducing you to more advanced features.
You should have a working knowledge and understanding of Microsoft Excel and the basic concepts of spreadsheets.
This course is designed to give you a solid understanding of more advanced Microsoft Excel tools and features in order to increase your knowledge and productivity by using forms and macros to capture, enter and edit your data quickly and efficiently.
During the course you will study the following topics:
- Quick forms
- Forms with form controls
- Developer tab
- Basic controls
- Text box
- Option button
- Check box
- Drop-down lists
- Combo boxes
- Global macros
- Workbook macros.
There will be no assessments of exams during this course; you will receive a Bedford College course completion certificate.
Further study and career options
On successful completion of this course you could go on to study another of the short computing courses delivered by Bedford College to develop your skills further, such as Microsoft Excel: Intermediate, Microsoft Excel: Managing Data Using Pivot Tables, and Microsoft Excel: What If Analysis.
This course will be delivered using Microsoft Office 2010 and will also be suitable if you use Microsoft Office 2007. If you are using Microsoft Office 2003 or any other version, please contact us to discuss this further.