Course Overview
Attendance Register Using Excel VBA:
Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features.
The training will help you learn about
- Introduction of Ms-Excel VBA Tools
- Start Designing of “Student Attendance Register” using Excel VBA Tools
- Designing of Project Interface with User Forms and Label
- Generate the Student Serial Number, Student Name and Course Using VBA Code
- Assign “Present”, “Absent”, “Sick”,”Late”,”Authorized” Option using Combo Box
- Use of Command Button to apply the “selected” option in all other student combo box
- How To Create the Save Button to Save the mark information in Student Attendance Register
- How To Clear the All Information and Reset the Student Attendance Register
- How To Use Frame & Image Tool to Add the Image in the Project
- Display Total Number of Absent and Present Student using label
- Check the Output of Final Project
Target Customers
- Students
- Working Professionals
- Analysts
Pre-Requisites
- Basic computer knowledge
- Familiarity with the Microsoft Office work environment