Iiasm Consultants Nirman Vihar, Delhi

IIASM Consultants is HR Outsourced Company.We are dealing in Training,Development and Consultancy Business.We provide good quality based services to our clients from past over 6 years experience.We create professionals for future. We work with working professional also who has having experience above 7-12 Years’ experience. They are providing crash course/practical training in different domain like; Advanced Excel & MIS Training, Excel VBA & Access Training, HR Practical Training and Finance and Accounts training, IT & Web Designing, Communication Training. We provide class timing according to student time convenience. We are offering this service on worldwide by online virtual classroom platform with the help of experienced professional expert. We provide assistance on IT projects also.

MODULE 1. BASIC AND ADVANCED EXCEL What is excel? Workbook, Worksheet, Range, Cell, tab, ribbon, quick access, cell formatting, custom formatting, columns, rows Cell referencing (Relative, Absolute, Mixed), Paste special, Go to special, Table, Print Title & Print Area, Wild Card * and, ï�¶ Basic and Advanced Function ï�¼ Sum, product, Sumproduct, average, max, min, large, small, count, counta, countblank, upper, lower, proper, left, right, mid, len, find, search, randbetween, replace, substitute, abs, concatenate etc. Ï�¶ Logical Function ï�¼ If, Nestedif, and, or, iferror, , countifs, sumifs, iserror, isnumber, istext etc. Ï�¶ Lookkup Function ï�¼ Vlookukp, Hlookup, 2dVlookup, 2dHlookup, Index, Match, Reverselookup, Indrect, Offset etc. Ï�¶ Date Function ï�¼ Date, Day, Month, Year, Edate, EOmonth, Day360, Networkdays, datedif, weekdays, workdays etc. Ï�¶ Data Summarization ï�¼ Pivotable , Data Sorting, Custom Sorting, Filter and Advanced Filter, Text to Column, Remove Duplicated, Group, Ungroup and Subtotal Split and Freeze Panes. Ï�¶ What if Analysis ï�¼ Scenario Manager, Data Table, Goal Seek ï�¶ Data Validation ï�¼ Input Message, Error Alert, Circle Invalid Data, Clear Validation Circle ï�¶ Conditional Formatting ï�¼ New Rules, Clear Rule and Manage Rule ï�¶ Charts ï�¼ Column, Line, Pie, Dougnut etc ï�¶ How to make Excel Dashboard ï�¼ Dashboard Using Pivotable, Slicer, Timeline, From Controls, ChartsHow to Prepare MIS Report ï�¼` IIASM Consultants 10 A, 1ST Floor, Veer Savarkar Block, Sikka M K House, Shakarpur, Near Nirman Vihar Metro Station Gate No-2, Delhi-110092 Phone no: 9212189653 Website: www.iiasmconsultants.com Daily, Weekly and Monthly Bases Reports What is Macro? Types of Macro Relative and Absolute macro. Additional Benefit Mail Merge, Table of Content, Speaking text, Date picker content control What will you get with this course? Assignment, Shortcut commands excel, E-book of Excel and Videos. MODULE 2. VBA ï�¼ Introduction of VBA, Programming in Excel VBA, Macro in VBA Basic, Visual Basic Editor, Project Explore, Immediate Window. Ï�¼ How to write programs in VBA, How to think program in VBA, How to create logic etc. Ï�¼ How to Run program, how to debug program, where apply break points. Ï�¼ Variable, Constants, Array and Data type. Implicit declaration and Explicit declaration. Ï�¼ What is Module? , Procedure, Difference between Function and Subroutine. Scope of Function. Ï�¼ Program`ming Basics: Decisions and Looping ï�¼ For-Next, For-Each, while, do while, until, do until. Ï�¼ Condition and Statement ï�¼ If, Nested-if, Cases, And, Or ï�¼ Strings and Functions and Message Boxes and Input Boxes ï�¼ Errors and the Error Function ï�¼ What is operator and types of operator? ï�¼ The Excel Object Model, Properties and Methods Explained ï�¼ Using Excel to Interact with Other Office Programs and Selecting the Microsoft Word Object Library. Ï�¼ Selecting the Object Library file for Microsoft Outlook, Selecting the Excel Library file ï�¼ Working with Databases, ODBC Link, Using ADO ï�¼ Class Modules, Inserting a Class Module, Creating an Object ï�¼ Outlook Connectivity with VBA ï�¼ How send the mail from outlook to multiple id with VBA ï�¼ Access connectivity with VBA ï�¼ Data fetch, data save, data fetch with query from the Access. Ï�¼ UserForm control. Ï�¼ Access Connectivity with UserForm What will you get with is course Assignment and E-book of Excel. MODULE 3 ACCESS Introduction to Microsoft Access Concept of MS Access How to Start Access Quick Access Toolbar` IIASM Consultants 10 A, 1ST Floor, Veer Savarkar Block, Sikka M K House, Shakarpur, Near Nirman Vihar Metro Station Gate No-2, Delhi-110092 Phone no: 9212189653 Website: www.iiasmconsultants.com Type of Data Type Text Long Number Date & time Currency Auto number Yesno Hyperlink Attachment Calculated Lookup wizard Creating Database and Tables Working with fields and records a. Modify Table b. Find and Replace c. Sorting and filter General Properties Field size Format Input Mask Caption Default Value Validation rule Validation text Required Allow zero length Index Lookup Text Box Combo Box List Box Relational Database Techniques ï�� Types of Relationship 1. One to one 2. One to many 3. Many to many Referential Integrity Cast Cade Update Cast Cade Delete Joins Working with Queries Select Query Make Table Append Query Update Query Cross tab Query Delete Query Working with Forms a. Overview b. Form Wizard c. From Scratch d. Form design e. Sub Forms f. Form Commands g. Sorting and filter h. Switch-board Working with Reports a. Report Wizard b. Report Design c. Report Calculations d. Report Format e. Report Summary f. Report labels g. Report Printing Sharing Data with Word and Excel a. Importing d. Export Working with Charts Working with Pivot-Charts` IIASM Consultants 10 A, 1ST Floor, Veer Savarkar Block, Sikka M K House, Shakarpur, Near Nirman Vihar Metro Station Gate No-2, Delhi-110092 Phone no: 9212189653 Website: www.iiasmconsultants.com MODULE 4 PAY ROLL PROCESSING ï�¶ How to prepare Salary Structure for New Joining. Ï�¶ Defining & Calculating Salary Heads (Basic, HRA, MA, TA, SA etc.) ï�¶ Designing & Calculating CTC. Ï�¶ Calculations Tax Deducted by Source (TDS). Ï�¶ Defining & Calculating Gross Net Salary. Ï�¶ Education Cess ï�¶ Discussion on Compensation & Benefits. Ï�¶ Calculating Statutory Compliances: PF, ESI, Gratuity and Bonus as part of CTC. 4.1 PAYROLL REPORTING ï�¶ PF report in Excel Sheet ï�¶ ESI report in Excel Sheet ï�¶ Professional Tax Report Please find the course and fee details. Classes & Course can be designedcustomize as per request. Fee According to Module:- Module 1 to 4 â�� Course Duration is 100-120 Hours Rs. 16,500- Module 1 to 3 â�� Course Duration is 70-80 Hours Rs. 12,500- Module 1 to 2 â�� Course Duration is 40-50 Hours Rs. 10,500- Module 1, 2 & 4 â�� Course Duration is 40-50 Hours Rs. 12,500- Note:- 1. Classes will be provided as per student requirement. 2. Arrange Extra Doubt Classes as per student requirement after training. Add On Benefits:- Free Trial Class by Professional MIS Expert Free Study Material Free All Training Classes Videos 100% Job Guarantee

Module 1 statutory compliances 1a) esi act-1948 ï�· brief intro about act. Ï�· eligibility criteria for esi & pf according to govt. Rule. Ï�· contribution of employee & employer. Ï�· filing (monthly & half yearly) ï�· calculations ï�· filling the forms ï�· keep the track that each and every new joinee covered under esic act, should receive the esic cards. Ï�· benefits ï�· recent amendments 1b) gratuity act-1972 ï�· brief intro about act. Ï�· benefits to employee. Ï�· coverage & eligibility criteria for gratuity according to govt. Rule. Ï�· calculations ï�· tax exemptions limit. Ï�· recent amendments 1c) bonus act-1965 ï�· coverage & eligibility ï�· calculations. Ï�· bonus limit. Ï�· recent amendments 1d) provident fund act-1952 ï�· coverage & eligibility ï�· calculation of pf deduction amount for both employee & employer. Ï�· providing pf reports ï�· remittance of challanâ��s ï�· preparation & filing of monthly returns ï�· transfers, withdrawals and annual returns ï�· maintain 3a, 12a register ï�· monthly pf statement & register ï�· monthly pf returns i.e. 510 a ï�· 12 a annual returns & pf slip module 2 compensation & benefits 2a) payroll processing ï�· how to prepare salary structure for new joining. Ï�· defining & calculating salary heads (basic, hra, ma,ta, sa etc.) ï�· designing & calculating ctc. Ï�· calculations tax deducted by source (tds). Ï�· defining & calculating gross net salary. Ï�· education cess ï�· discussion on compensation & benefits. Ï�· calculating statutory compliances: pf, esi, gratuity and bonus as part of ctc. Module 3 legal compliances & labour laws factory act â· factory act provision â· procedure â· registration & license â· forms contract labour act â· introduction â· applicability â· registration& licensing â· wage considerations â· whole procedure trade unions act, 1926 â· applicability â· trade unions â· how do we register a trade union â· what is the proof of registration of a trade union minimum wages act â· introduction â· implications â· documentations module 4 hr core areas 4a) employee on boarding ï�· welcome an employee ï�· how to handle employee orientation process 4b) hr activities - induction & exit interviews ï�· appropriate induction program for new member ï�· how to arrange exit interviews for employee leaving organizations for assessing reasons to make corrective actions. Ï�· introduction with organizations background along with current turning & future business planning. Ï�· handle all documentation of personnel during joining & relieving along with full & final settlement. Ï�· checking major documents with concerned hired company responsible for employer verification. 4c) hr policies & system implementation ï�· initiate various hr policies, its designing (under guidance of hr head) and implementation as per need of business objectives .strict adherence of all the policies. Ï�· standard operating procedures for smooth and error free system. 4d) hr executive ï�· handled industry dispute ï�· handling employee grievances & employee relationship ï�· employee engagement activities ï�· maintain muster roll ï�· attrition : employee calculation & new joining calculation ï�· effective retention policies ï�· manpower planning ï�· negotiation skills module 5 training and development ï�· introduction about business, mapping, skills required ï�· objectives & goals ï�· types of training ï�· theories & principal of training ï�· process of training & development ï�· modes & techniques of training ï�· how to prepare training calendar? ï�· post training evaluation 4 module 6 performance management systems ï�· why measure pms? ï�· self-assessment , annual appraisal, evaluation techniques, salary survey ï�· kick off appraisal process on schedule, track progress, and manage timely completion of the process ï�· co-ordinate with the different department head about the appraisal cycle. Ï�· how to select kras. Ï�· define set targets & action plans for kras. Ï�· difference between pas & pms. Ï�· various components of pms ï�· how to design kpi, jd & sop module 7 staffing & recruitment ï�· preparation of mrf (manpower requisition form) ï�· how to coordinate with other department regarding job description. Ï�· prepare jd (job description) format according to job requirements. Ï�· practical hands on exposure of job portals naukri.com & timesjobs.com ï�· discussion on modern techniques of recruitment ï�· how to post your job for getting good talent. Ï�· how to conduct & take interviews. Ï�· how to validates resumes ï�· how to identify talents by using competency mapping, psychometric tests etc. Ï�· how to make recruitment policy keeping in view of the baseline of the organization and future need. Ï�· head hunting ï�· negotiation skills module 8 mis reporting (ms. Excel practical sessions) ï�· basic concept mis and excel ï�· pf report in excel ï�· esi report in excel ï�· hra report in excel ï�· vlookup, hlookup, pivot table, split & freeze. Ï�· data fetching in excel. Ï�· overview of macros ï�· how to prepare mis report. Ï�· tax calculation in excel and lot of mis report in excel. module 1 to 8 â�� course duration is 60-70 hrs rs. 12500-