What’s Included
1 project file
11 chapter quizzes
Access on tablet and phone
Certificate of completion
Course Description
Learn the basics of Java programming language, including syntax, data types, variables, operators, and control flow statements.Understand key OOP concepts such as classes, objects, inheritance, polymorphism, and encapsulation, essential for building robust and modular Java applications.Explore the Java Standard Library (Java API) and its core packages for performing common tasks such as input/output (I/O), string manipulation, collections, and exception handling.
 Covers the basics and importance of C programming, including its history and widespread .
 Covers the basics and importance of C programming, including its history and widespread .
 Covers the basics and importance of C programming, including its history and widespread .
 Covers the basics and importance of C programming, including its history and widespread .
Curriculum
Module 1: Start VBA & Security
- Â Introduction to VBA
- Â Security concepts in Excel 2003, 2007, & 2010
- Â Using Visual Basic Editor (VBE)
- Â Excel Macro Recorder
Module 2: Excel Objects
- Â Introduction to Object, Properties & Methods
- Â Using Input box & Message box
- Â Sheets, Ranges & Offset
- Â Excel VBA Variables
Module 3: Conditions & Loops
- Â Using IF Statement in VBA
- Â Using SELECT CASE Statement
- Â Using Do While Loop & FOR NEXT Loop in Excel
Module 4: Functions And Subroutine
- Â Working with User Defined Functions (UDF)
- Â Theory on Variables, Scoping etc.
- Â Working With Dates
- Â Error Handling Methodologies
Advance VBA (Macros)
Module 1: Forms
- Â Introduction To Excel VBA User forms
- Â User forms order of Events Procedures
Module 2: Controls
- Â Filling User form Controls
- Â Filling a Listbox and Combobox using Loops
- Â User form Multipage Control
Module 3: Validations
- Â Validating user input into a user form
- Â Textbox and spinbuttons user form controls
- Â Passing user form control values back to a spreadsheet
- Â Passing user form control values back to a spreadsheet
Module 4: Array
- Â Method of storing multiple data in Array
- Â Defining holding capacity of an Array
- Â Storing Tabular data in Array
Module 5: Chart
- Â Creating Chart in Excel using VBA
- Â Customizing the chart
- Â Pivot Tables & VBA
- Â Generating Multiple Pivot Table Reports using VBA
Module 6: Database
- Â Definition and Purpose of Structures
- Â Importance in Organizing Data
- Â Basic Syntax and Declaration
- Â C Structure Definition
- Â Access Structure Members
- Â Initialize Structure Members