Excel VBA Learning With Project
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
265 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA Learning With Project to your Wishlist.

Add to Wishlist

Excel VBA Learning With Project

Designing of Simple Attendance Register Using MS-Excel VBA
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
265 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $75 Discount: 87% off
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will able to create project using Excel VBA
View Curriculum
Requirements
  • Basic Knowledge of Microsoft Excel
  • You Should Be Able to Lean Microsoft Excel VBA From Begining
Description

Learn Microsoft Excel VBA with Project
• Macro Enabled Workbook
• Designing of Attendance Register Project
The course is designed for individuals and office professionals who need to master the capabilities of the Microsoft Excel VBA. Through the video lectures you'll learn the usage of Ms-Excel VBA Step by step and also design one small project with the help of VBA tools.
Become an Ms-Excel VBA user. We start at the very beginning progressing with more than helpful videos.
All you need for work Excel VBA User Forms, Frame, Combo box, and other tools feel confident with every aspect of Excel VBA
• Designed to help beginners get started
• Lessons start right at the very beginning
• Progresses slowly with more than 20 helpful videos
• A big 2 hours 39 Minutes of expert instruction
• Learn How to Work in Ms-Excel VBA
• Master the most common uses of Ms-Excel VBA
• Learn How to create project in Excel VBA
• Use the full palette of functions
• Experienced users can fill in gaps in knowledge
• Work faster with better results and greater confidence
• Discover how to create Simple Attendance Register With Help of Excel VBA
Now you can learn Ms-Excel VBA from the very beginning. Beautifully designed for beginners to get a great start while helping more experienced users fill in any gaps in their knowledge. You enjoy expert tutorial videos that clearly show you how to accomplish every aspect of Ms-Excel VBA.
This course is just what you want for being confident with Excel VBA in the workplace. Also gives you everything you need to know for personal use.
The self-learning video format lets you study on your own schedule. Watch videos as you have time, then come back to learn more later.
Now you can become a master at using one of the world's most popular computer applications – Microsoft Excel VBA.
Who is the target audience?
• Anyone new to Microsoft Excel or having basic working knowledge of Ms-Excel

Who is the target audience?
  • Freshers
  • Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
03:04:02
+
Introduction
23 Lectures 03:04:02


Project Session-2 How To Create Macro Enabled Work Book
09:00

Project Session-3 Project Start Session
02:40

Project Session-4 How to Create Project Interface Userform
11:27

Project Session-5 How to Design Project Interface Part-2
10:41

Project Session-6 How to Design Project Interface Part-3
08:02

Project Session-7 How to Generate Serial Number in Attendance Register
06:29

Project Session-8 How to generate Student id in Attendance Register
07:17

Project Session-9 How to generate Student Name in Attendance Register
05:24

Project Session-10 How to generate Course Detail in Attendance Register
03:57

Project Session-11 How to Assign Attendance Value using Combobox
11:11

Project Session-12 How to Create Attendance Mark Button in Attendance Register
11:21

Project Session-13 How to Create Attendance Save Button in Attendance Register
14:32

Project Session-14 How to Create Attendance Clear Button in Attendance Register
07:36

Project Session-15 How to Add Image in Attendance Register
02:33

Project Session-16 How to Count Present Students in Attendance Register
10:47

Project Session-17 How to Absent Students in Attendance Register
06:56

Project Session-18 How to Sick Students in Attendance Register
04:29

Project Session-19 How to Count Late Students in Attendance Register
05:59

Project Session-20 How to Display Total Enroll Students in Attendance Register
05:20

Project Session-21 How to Display Date in Attendance Register
08:06

Session:22 How to Save Mark Attendance in Excel Worksheet
16:51
About the Instructor
Project Manager Pardeep Sharma
4.7 Average rating
3 Reviews
879 Students
3 Courses
10 Years Experience in IT Training & Development

10 Years’ experience leading and Implementation the Large & Small scale IT and E-Governance  Projects, Training Implementation, Administration & Operations with a strong performance background in Project Coordination, Project Planning, Project Budgeting, Milestone Payment Process, Revenue Collection, Risk Management, Staff Recruitment & Selection, Resource allocation, Reporting, Filing of EOI, Project RFP Filing, and Proposal Writing, Project Documentation filing And Submission, Scheduling of Project Pre-Bid Conference, Negotiation, Procurement, Manpower recruitment, Team Building, implementation of E-Governance trainings and having experience in other project implementation areas like sales and marketing, student engagement, event management, Team Handling, Team Management, Branch Handling Functions, Time Management, Staff Engagement, System Support and solution-based on  Education & Software services.