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
Housing Soc. Accounts - Advanced Excel
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
Housing Soc. Accounts - Advanced Excel
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