Training on Excel VBA & Applications
This course was designed in its simplified and practical terms to explain the basics of VBA(Visual Basic for Applications) in Microsoft Excel to the advanced level.
This course consists of 66 practical training videos covering a duration of about 11 hours, divided into 2 segments;
- Excel VBA Fundamentals
- Excel VBA Applications.
Excel VBA Fundamentals deals with the basics of Excel VBA that helps an absolute beginner grasp the dynamics of the VBA environment and coding procedures. Simplified enough that all a beginner needs, are to copy, paste and customize lines of codes to get a task done with a further guide to a higher level of expertise.
You will also be learning how to work with DataBases in Excel VBA.
In addition, every lesson is matched with practical application that helps your day-to-day jobs be done faster and better.
Excel VBA Applications deals with the applications of excel VBA and basic excel skills to design beautiful models like Automated attendance registers and others.
At the end of this course you will be able to not only gain confidence and mastery of excel VBA but also among other benefits:
Master the art of using VBA to perform complex routine tasks in splits of seconds
You will master the art of using VBA to perform complex routine tasks in a split of seconds.
You will be able to design dynamic user forms as per your requirements.
You will be able to design an automated time attendance register for schools/offices.
You will be able to analyze, grade and auto-comment data (results).
You will be able to design amazing clocks and timers(count up and count down).
You will be able to design automated bill sheets for sales and for clients.
You will be able to design a dynamic student report sheet(Card: termly and cumulative) with an attached passport with an attached electronic signature.
You will be able to build a dynamic Staff/Student database system and many more.
FREQUENTLY ASKED QUESTIONS
Are the videos downloadable?
The videos are highly compressed and downloadable.
What are the course requirements?
Access to a laptop or computer and a basic understanding of Microsoft Excel.
Will the certificate be issued?
Yes, a certificate of completion will be issued at the end of the course at No charge.
How will I get access to the Course videos and Materials?
Once payment is completed. The course lessons and materials will be available to you instantly.
Enjoy VBA in its best simplified practical approach with access to ALL lines of codes and materials used!!!
- Lectures 70
- Quizzes 0
- Duration 11 hours
- Skill level All levels
- Language English
- Students 90
- Certificate Yes
- Assessments Yes
Excel VBA Fundamentals
Section 1: Introduction
Section 2. Writing a Macro
- Excel VBA Copy and Paste
- Excel VBA Font
- Excel VBA Font Color
- Excel VBA Background Color
- Excel VBA Delete Cells
- Excel VBA Borders
- Excel VBA Insert Row & Column
- Excel VBA Delete Row & Column
- Excel VBA Hide & Unhide Column
- Excel VBA Hide and Unhide Rows
- Excel VBA Merge and Unmerge
- Excel VBA Hide and Unhide Sheet
- Excel VBA Protect and Unprotect Sheet
Section 3: Building Block
Section 4: Loops
Section 5: Conditional Statement
Section 6: User Form
Section 7: Time Series VBA Applications
Section 8: Forms Applications
Section 9: Files Collator & Result Analysis
Section 10: Built Models