Coaching Classes #4327187

MODULE 1. BASIC AND ADVANCED EXCELWhat is excel?Workbook, Worksheet, Range, Cell, tab, ribbon, quick access, cell formatting, custom formatting, columns, rowsCell referencing (Relative, Absolute, Mixed), Paste special, Go to special, Table, Print Title & PrintArea, Wild Card * and, Basic and Advanced FunctionSum, 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 FunctionIf, Nestedif, and, or, iferror, , countifs, sumifs, iserror, isnumber, istext etc.Lookkup FunctionVlookukp, Hlookup, 2dVlookup, 2dHlookup, Index, Match, Reverselookup, Indrect, Offset etc.Date FunctionDate, Day, Month, Year, Edate, EOmonth, Day360, Networkdays, datedif, weekdays, workdays etc.Data SummarizationPivotable , Data Sorting, CustomSorting, Filter and Advanced Filter, Text to Column, RemoveDuplicated, Group, Ungroup andSubtotal Split and Freeze Panes.What if AnalysisScenario Manager, Data Table, GoalSeekData ValidationInput Message, Error Alert, CircleInvalid Data, Clear ValidationCircleConditional FormattingNew Rules, Clear Rule and ManageRuleChartsColumn, Line, Pie, Dougnut etcHow to make Excel DashboardDashboard Using Pivotable, Slicer, Timeline, From Controls, ChartsHow to Prepare MISReport`IIASM Consultants10 A, 1ST Floor, Veer Savarkar Block, Sikka M KHouse, Shakarpur, Near Nirman Vihar MetroStation Gate No-2, Delhi-110092Phone no: 9212189653Website: www.iiasmconsultants.comDaily, Weekly and Monthly Bases ReportsWhat is Macro?Types of MacroRelative and Absolute macro.Additional BenefitMail Merge, Table of Content, Speaking text, Date picker content controlWhat will you get with this course?Assignment, Shortcut commands excel, E-book of Excel and Videos.MODULE 2. VBAIntroduction of VBA, Programming in Excel VBA, Macro in VBA Basic, Visual Basic Editor, ProjectExplore, Immediate Window.How to write programs in VBA, How to thinkprogram 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. Implicitdeclaration and Explicit declaration.What is Module? , Procedure, Difference betweenFunction and Subroutine. Scope of Function.Program`ming Basics: Decisions and LoopingFor-Next, For-Each, while, do while, until, do until.Condition and StatementIf, Nested-if, Cases, And, OrStrings and Functions and Message Boxes andInput BoxesErrors and the Error FunctionWhat is operator and types of operator?The Excel Object Model, Properties and MethodsExplainedUsing Excel to Interact with Other Office Programsand Selecting the Microsoft Word Object Library.Selecting the Object Library file for MicrosoftOutlook, Selecting the Excel Library fileWorking with Databases, ODBC Link, Using ADOClass Modules, Inserting a Class Module, Creatingan ObjectOutlook Connectivity with VBAHow send the mail from outlook to multiple idwith VBAAccess connectivity with VBAData fetch, data save, data fetch with query fromthe Access.UserForm control.Access Connectivity with UserFormWhat will you get with is courseAssignment and E-book of Excel.MODULE 3 ACCESSIntroduction to Microsoft AccessConcept of MS AccessHow to Start AccessQuick Access Toolbar`IIASM Consultants10 A, 1ST Floor, Veer Savarkar Block, Sikka M KHouse, Shakarpur, Near Nirman Vihar MetroStation Gate No-2, Delhi-110092Phone no: 9212189653Website: www.iiasmconsultants.comType of Data TypeTextLongNumberDate & timeCurrencyAuto numberYesnoHyperlinkAttachmentCalculatedLookup wizardCreating Database and TablesWorking with fields and recordsa. Modify Tableb. Find and Replacec. Sorting and filterGeneral PropertiesField sizeFormatInput MaskCaptionDefault ValueValidation ruleValidation textRequiredAllow zero lengthIndexLookupText BoxCombo BoxList BoxRelational Database TechniquesTypes of Relationship1. One to one2. One to many3. Many to manyReferential IntegrityCast Cade UpdateCast Cade DeleteJoinsWorking with QueriesSelect QueryMake TableAppend QueryUpdate QueryCross tab QueryDelete QueryWorking with Formsa. Overviewb. Form Wizardc. From Scratchd. Form designe. Sub Formsf. Form Commandsg. Sorting and filterh. Switch-boardWorking with Reportsa. Report Wizardb. Report Designc. Report Calculationsd. Report Formate. Report Summaryf. Report labelsg. Report PrintingSharing Data with Word and Excela. Importingd. ExportWorking with ChartsWorking with Pivot-Charts`IIASM Consultants10 A, 1ST Floor, Veer Savarkar Block, Sikka M KHouse, Shakarpur, Near Nirman Vihar MetroStation Gate No-2, Delhi-110092Phone no: 9212189653Website: www.iiasmconsultants.comMODULE 4 PAY ROLL PROCESSINGHow 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 CessDiscussion on Compensation & Benefits.Calculating Statutory Compliances: PF, ESI, Gratuity and Bonus as part of CTC.4.1 PAYROLL REPORTINGPF report in Excel SheetESI report in Excel SheetProfessional Tax ReportPlease 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 MISExpertFree Study MaterialFree All Training Classes Videos100% Job Guarantee

Module 1 statutory compliances1a) esi act-1948brief intro about act.eligibility criteria for esi & pf according to govt. Rule.contribution of employee & employer.filing (monthly & half yearly)calculationsfilling the formskeep the track that each and every new joinee covered under esic act, should receive the esic cards.benefitsrecent amendments1b) gratuity act-1972brief intro about act.benefits to employee.coverage & eligibility criteria for gratuity according to govt. Rule.calculationstax exemptions limit.recent amendments1c) bonus act-1965coverage & eligibilitycalculations.bonus limit.recent amendments1d) provident fund act-1952coverage & eligibilitycalculation of pf deduction amount for both employee & employer.providing pf reportsremittance of challanspreparation & filing of monthly returnstransfers, withdrawals and annual returnsmaintain 3a, 12a registermonthly pf statement & registermonthly pf returns i.e. 510 a12 a annual returns & pf slip module 2 compensation & benefits2a) payroll processinghow 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 cessdiscussion on compensation & benefits.calculating statutory compliances: pf, esi, gratuity and bonus as part of ctc.Module 3 legal compliances & labour lawsfactory actfactory act provisionprocedureregistration & licenseformscontract labour actintroductionapplicabilityregistration& licensingwage considerationswhole proceduretrade unions act, 1926applicabilitytrade unionshow do we register a trade unionwhat is the proof of registration of a trade unionminimum wages actintroductionimplicationsdocumentationsmodule 4 hr core areas4a) employee on boardingwelcome an employeehow to handle employee orientation process4b) hr activities - induction & exit interviewsappropriate induction program for new memberhow to arrange exit interviews for employee leaving organizations for assessing reasons to makecorrective 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 implementationinitiate various hr policies, its designing (under guidance of hr head) and implementation as perneed of business objectives .strict adherence of all the policies.standard operating procedures for smooth and error free system.4d) hr executivehandled industry disputehandling employee grievances & employee relationshipemployee engagement activitiesmaintain muster rollattrition : employee calculation & new joining calculationeffective retention policiesmanpower planningnegotiation skillsmodule 5 training and developmentintroduction about business, mapping, skills requiredobjectives & goalstypes of trainingtheories & principal of trainingprocess of training & developmentmodes & techniques of traininghow to prepare training calendar?post training evaluation4module 6 performance management systemswhy measure pms?self-assessment , annual appraisal, evaluation techniques, salary surveykick off appraisal process on schedule, track progress, and manage timely completionof the processco-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 pmshow to design kpi, jd & sopmodule 7 staffing & recruitmentpreparation 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.comdiscussion on modern techniques of recruitmenthow to post your job for getting good talent.how to conduct & take interviews.how to validates resumeshow 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 huntingnegotiation skillsmodule 8 mis reporting (ms. Excel practical sessions)basic concept mis and excelpf report in excelesi report in excelhra report in excelvlookup, hlookup, pivot table, split & freeze.data fetching in excel.overview of macroshow 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-