Toggle navigation
Home
About
Courses
GDCA & CHM Training
Adv. Certificate in CHSM & Administration
Certificate Course in CHSM
Certificate Courses in Society Manager
Certificate Course in Society Compliances
Other Courses
Housing Soc. Accounts - TALLY 9.0 WITH ERP
Society Based Management Information System (MIS)
Communication Skills for Housing Society Alliance
Digital Media for Society Management
Advanced Excel Course
Services
Society Services
Other Services
Student Zone
GDC&A Examinations
Admission Process
GDC&A Admission Form
Certificate Admission Form
Payment
Recognitions
Gallery
Career
Testimonials
Contacts
Short Term Courses
Advanced Excel Course
Formulas & Macros Formulas:
Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
Nested functions , Name cells /ranges /constants
Relative, Absolute, Mixed cell references
Logical functions using IF, AND, OR, NOT
The LOOKUP function , Date and time functions , Annotating formulas
DATA Analysis:
Sub Total Reports, Auto Filter
Password Protecting Worksheets
Linking Multiple Sheets
Sheet Referencing
Linking Between Word/Excel/Ppt
Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
What-if-analysis, GOAL SEEK
PIVOT Tables, NESTED IF
Reporting
Character Functions
Date Functions
Age Calculations
Consolidation of Data
Data Validation
MACRO’S
Macros:
Definition and use , Record a macro
Assign a macro , Run a macro
Store a macro, Introduction to VBA Prog
Develop the Worksheet:
Plan a worksheet , Row and Column labels
Split worksheet /box /bar, Copy data and formulas
Display /move toolbars , Enhance worksheet Appearance
Special Operations:
Use multiple windows : Copy/ paste between Worksheets
Link worksheets , Consolidate worksheets
Import and link from other Applications
Use AutoFormat : Create, use and modify styles and templates
Print features : Create /edit an outline
Admission Process:
Eligibility: 12th Pass/Any graduate/ and Post Graduates Knowledge
Duration: 2 Months (Saturday / Sunday)
Training Mode: Online Live Session, Practical, and Assignment.
Online Examination & Evaluation: Objective (MCQ)
Certification By : AISMT