Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price # Enroll Book free demo
Weekend
18 Hrs class +
42 Hrs projects
Weekend Morning-Batch USD 150
INR 9999
Enroll Now Book free demo class

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

CURRICULUM

Advance Excel and VBA

  • 1.1 Overview of Basic Excel SkillsM
  • 1.2 Protection Of Files
  • 1.3 Protection Of Cells & Range
  • 1.4 Time Saving Utilities
  • 1.5 Concept of Cell Referencing
  • 1.6 Important Functions in Excel
  • - And, OR, Not, Date, Datedif, Time, Now, Hour, Minute, Sec, Substitute, Convert, Find, Search, Left, Right, Mid, Combination Of Left, Right & Mid, Vlookup, Vlookup 2D, Vlookup 3D, Choose, Offset, Index, Match, Reverse Lookup, Average, Average IF, Sum, Sumif, Sumifs, Count, Countif, Countifs, Power, Len, Rand, Randbetween, Trim, Find, Advance Find, Text Formatting, Indirect, IF, Nested IF and More.
  • 1.7 Name Manager
  • 1.8 Conditional Formatting
  • 1.9 Data Validation
  • 1.10 Excel Table
  • 1.11 Charts in Excel
  • 1.12 Pivot Table
  • 1.13 Array Functions
  • 1.14 DATEDIF Function
  • 1.15 Data Filter
  • 1.16 Subtotal
  • 1.17 Data Consolidation
  • 1.18 What-If Analysis
  • 1.19 Sparklines
  • 1.20 Form Controls
  • 1.21 7 Quality Control Tools
  • 1.22 Expertising Microsoft Excel
  • 2.1 Introduction to Visual Basic
  • 2.2 OOP concepts and Illustration
  • 2.3 Excel Object Model
  • 2.4 VBA Data Types
  • 2.5 Operators
  • 2.6 Basic Excel Operations
  • 2.7 Dialogs in VBA screen
  • 2.8 Defining Constants
  • 2.9 Defining Variables
  • 2.10 Working with Functions
  • 2.11 Working with Subroutines
  • 2.12 Handling errors
  • 2.13 Working with Message Box
  • 2.14 Decision Statements
  • 2.15 Looping Statements
  • 2.16 Working with User Forms
  • 2.17 Developing Consolidation Tools
  • 2.18 Working with system Registry
  • 2.19 Database Connectivity using VBA
  • 2.20 Creating Excel based application
  • 2.21 Creating Time saving tools
  • 2.22 Creating Plug-Ins

Exam & Certification


Select Trainer for Demo


Disclaimer

**

* Money Back Guarantee till demo and 1st class of the course.

* All trademarks and logos appearing on this website are the property of their respective owners.


Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US