Smart Tally Essential With Gst Volume ( 1 To 3 )
March 12, 2022Advanced Diploma In Computer Applications (ADCA) Volumes ( 1 To 4 )
March 14, 2022Advance Excel
₹450.00
Pages 129
Category: Uncategorized
Description
Content : –
Table of Content |
Module-I |
Extend Your Insight Office Excel |
Benefits of office open XML |
Finding Formulas |
The Choose Function |
Column Chart |
Pivot Tables |
VLookup Function |
Excel Scenario Manager |
Formulas |
Conditional Functions |
The Functions IF & OR |
Percentage Formulas |
Assignments |
Module-II |
Building macrosin Excel |
Visual Basic Editor (VBE) in Excel |
Creating Macro |
Practice a Simple VBA Program |
Programming Structure in Excel VBA |
The Concept of Variables |
Numeric data types |
Message Boxes (MsgBox) in VBA for Excel |
Creating & Managing Array Declaring |
Manage Dynamic Array |
Create Multi-Dimensional Array |
Loop Structures |
Font & Background Color |
Excel VBA Procedures – Functions |
Examples |
Objects & Collections |
Project Assignment |
Excel VBA Controls’ Properties and VBA Code |
Advance Excel |
Creating and Using Form |
Tab order |
Managing Controls |
List Boxes |
Combo Boxes |
Option Button, Check Boxes and Frames |
Image Control |
Event Handling |
Debugging and Dealing with Errors |
VBA Macros Security and Protection in Excel |
Formatting Controls |
Project Assignments |
Store Policies
Inquiries
General Inquiries
There are no inquiries yet.