Excel vlookup

Learn Ms office like a pro. Ms excel(vlookup, hlookup, pivot table etc.)

fundamental to intermediate Excel users, those who are ever trying to manage, manipulate & analyse Microsoft  HYPERLINK "https://technovids.com/course/"excel online training is designed for data using Excel. Microsoft Excel has been an evergreen tool For Data Analysis & Data Management. Excel is the highest used tool for Data management & Business Analytics field. Technovids Microsoft  HYPERLINK "https://technovids.com/course/"excel training program & excel classroom training includes Excel from basic to advanced, whereas in advanced, we cover most of the crucial functions like vlookup, hlookup, power pivot, conditional formatting, etc. Also, we cover Data table, Pivot tables, Pivot Chart, Working with the Web and External Data, vlookup, hlookup, working with Macros (Only intro). Who we are: Technovids always focuses on the quality of excel HYPERLINK "https://technovids.com/course/" online training. We have the group of experienced excel trainer who have got 10+ years of real-time work experience in the main, also they have got enough exposure to provide the Advanced Excel training up to expert level. Technovids team keeps its content up to date as per real-time changing industrial need. Content is always customizable as per client’s requirement (Specifically for the MS Excel Corporate Training).   Some of the benefits of joining the Best excel training organized by Technovids   •        Training conducted by real time working professionals •        You get the session recording for the future reference •        No hassle of travelling, attend the session from anywhere •        Basic requirement (PC/Mobile with the respective software installed which you want to learn) •        Real time support in case of any escalations •        Post training mail support (for limited time)   Page link: http://course/advanced-excel-training-institute-https://technovids.com/bangalore/

Microsoft  HYPERLINK "https://technovids.com/course/"excel online training is designed for fundamental to intermediate Excel users, those who are ever trying to manage, manipulate & analyse data using Excel. Microsoft Excel has been an evergreen tool For Data Analysis & Data Management. Excel is the highest used tool for Data management & Business Analytics field. Technovids Microsoft  HYPERLINK "https://technovids.com/course/"excel training program & excel classroom training includes Excel from basic to advanced, whereas in advanced, we cover most of the crucial functions like vlookup, hlookup, power pivot, conditional formatting, etc. Also, we cover Data table, Pivot tables, Pivot Chart, Working with the Web and External Data, vlookup, hlookup, working with Macros (Only intro). Who we are: Technovids always focuses on the quality of excel HYPERLINK "https://technovids.com/course/" online training. We have the group of experienced excel trainer who have got 10+ years of real-time work experience in the main, also they have got enough exposure to provide the Advanced Excel training up to expert level. Technovids team keeps its content up to date as per real-time changing industrial need. Content is always customizable as per client’s requirement (Specifically for the MS Excel Corporate Training).   Some of the benefits of joining the Best excel training organized by Technovids   •        Training conducted by real time working professionals •        You get the session recording for the future reference •        No hassle of travelling, attend the session from anywhere •        Basic requirement (PC/Mobile with the respective software installed which you want to learn) •        Real time support in case of any escalations •        Post training mail support (for limited time)   Page link: http://course/advanced-excel-training-institute-https://technovids.com/bangalore/

inter-ideograph;line-height:107%">fundamental to intermediate Excel users, those who are ever trying to manage, manipulate & analyse mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">Microsoft  HYPERLINK "https://technovids.com/course/"excel online training mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:black"> is designed for data using Excel. mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">Microsoft Excel has been an evergreen tool For Data Analysis & Data Management. inter-ideograph;line-height:107%">Excel is the highest used tool for Data management & Business Analytics field. Technovids mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">Microsoft  HYPERLINK "https://technovids.com/course/"excel training program mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:black"> & mso-fareast-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family: Calibri;color:#0563C1">excel classroom training mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:black"> includes Excel from basic to advanced, whereas in advanced, we cover most of the crucial functions like vlookup, hlookup, power pivot, conditional formatting, etc. Also, we cover Data table, Pivot tables, Pivot Chart, Working with the Web and External Data, vlookup, hlookup, working with Macros (Only intro). inter-ideograph;line-height:107%"> Who we are: Technovids always focuses on the quality of mso-fareast-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family: Calibri;color:#0563C1">excel HYPERLINK "https://technovids.com/course/" online training. We have the group of experienced mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">excel trainer Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:black"> who have got 10+ years of real-time work experience in the main, also they have got enough exposure to provide the mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">Advanced Excel training up to expert level. margin-left:0in;line-height:normal"> 11.0pt;mso-ascii-font-family:Calibri;mso-fareast-font-family:Calibri; mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri">Technovids team keeps its content up to date as per real-time changing industrial need. Content is always customizable as per client’s requirement (Specifically for the MS Excel  mso-fareast-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family: Calibri;color:blue">Corporate Training mso-bidi-font-size:11.0pt;mso-ascii-font-family:Calibri;mso-fareast-font-family: Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri">). inter-ideograph;line-height:107%">   margin-left:.5in;text-align:justify;text-justify:inter-ideograph;line-height: 107%">Some of the benefits of joining the mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">Best excel training organized by Technovids margin-left:.5in;text-align:justify;text-justify:inter-ideograph;line-height: 107%">   margin-left:.5in;text-align:justify;text-justify:inter-ideograph;text-indent: -.25in;line-height:107%;mso-list:l0 level1 lfo1">•         Training conducted by real time working professionals margin-left:.5in;text-align:justify;text-justify:inter-ideograph;text-indent: -.25in;line-height:107%;mso-list:l0 level1 lfo1">•         You get the session recording for the future reference margin-left:.5in;text-align:justify;text-justify:inter-ideograph;text-indent: -.25in;line-height:107%;mso-list:l0 level1 lfo1">•         No hassle of travelling, attend the session from anywhere margin-left:.5in;text-align:justify;text-justify:inter-ideograph;text-indent: -.25in;line-height:107%;mso-list:l0 level1 lfo1">•         Basic requirement (PC/Mobile with the respective software installed which you want to learn) margin-left:.5in;text-align:justify;text-justify:inter-ideograph;text-indent: -.25in;line-height:107%;mso-list:l0 level1 lfo1">•         Real time support in case of any escalations margin-left:.5in;text-align:justify;text-justify:inter-ideograph;text-indent: -.25in;line-height:107%;mso-list:l0 level1 lfo1">•         Post training mail support (for limited time)   Page link: mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:#0563C1">http://course/advanced-excel-training-institute-https://technovids.com/bangalore/

MS EXCEL A Workshop on ADVANCE EXCEL TRAINING FOR MIS AND VBA MACRO LEARNING Hello = 99'87'29'38'11 = Day I Introduction to Excel with hands-on Excel tricks while handling corporate huge data Excel shortcuts Practical Example of Some Important Functions Such As: Countif Sumif Averageif Countifs Sumifs Quick Charts Find Search Len Mid Left Right Vlookup Hlookup Lookup Relative Referencing Absolute Referencing Mixed Referencing Match_Index Match_Vlookup Floor Indirect Validation Dynamic Validation Conditional formatting for cell Name Manager Condition formatting with changing conditions More than 50 Formula = Day II WHAT IS EXCEL MACRO WHAT IS DEVELOPER TAB HOW TO MAKE DEVELOPER TAB VISIBLE IN EXCEL RIBBON STEPS TO ADD DEVELOPER TAB IN YOUR EXCEL RIBBON WHERE TO WRITE THE VBA CODE IN EXCEL HOW TO RECORD MACRO IN EXCEL HOW TO RUN MACRO IN EXCEL 5 to 10 Different example of simple Macro with Excel Shortcuts which includes Do – loop For – Next Select – Case Add-ins Input box Message Box Warning Box Drop down Label Text bar User Forms Multiple Module using in one macro Making macros for Fun & Game

Advanced excel - vlookup hookup if conditions conditional formatting data validation pivot table with excellent real time scenario based teaching All keyboard short cuts not only mentioned topics I give assurance that u ll become an excel expert

Microsoft Excel or : Advanced Course Description Learn the expert features and functions in Microsoft Excel or , to help you get you beyond the basics and have advanced-level proficiency within the Excel or suite Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including: IF statements VLOOKUP and HLOOKUP Sparklines Pivot Tables and Charts Macro Operations The Ability to Master Excel By the completion of this Excel coaching for Microsoft Excel or , you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process. Content and Overview Suitable for beginners with Microsoft Excel but also for those who wish to cover the advanced topics in Excel. Through this Coaching program content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment. What are the requirements? Microsoft Excel or , Windows 8, 7, Vista or XP What am I going to get from this course? Over 24 hours of content! To take your basic Excel skills to the next level To gain a solid understanding of the more powerful features and functions in Excel To be able to use Microsoft Excel in a commercial environment What is the target audience? Users with a basic knowledge of Excel Users who have completed our Beginners / Intermediate Excel title What you get with this 24 Hours Excel Coaching? •Important Basic Feature of Excel – 2 Hours •Functions – 12 Hours oMathematical – Basic & Advance oIF oLOOKUP and DATA Functions oSparklines oText Functions oOther Day to Day Useful Functions oFormula Auditing •Pivot Tables – 5 Hours •Charts – 3 Hours •Macros – 2 Hours All with partial Examples and workouts For more details or book Demo Class Contact mycoach[at]outlook.in or call 91-

Program Name: Basic Excel 2010 Duration: 8 hrs Training Content:. Creating a Basic Worksheet · Customize the Quick Access Toolbar · Enter Data and Save a Workbook · Explore the User Interface and the Ribbon · Navigate and Select in Excel · Obtain Help Performing Calculations · Calculate with Functions · Copy Formulas and Functions · Create Basic Formulas Modifying a Worksheet · Insert and Delete Cells, Columns, and Rows · Manipulate Data · Search for Data in a Worksheet · Spell Check a Worksheet Formatting a Worksheet · Add Borders and Color to Cells · Apply Cell Styles · Apply Number Formats · Change Column Width and Row Height · Modify Fonts · Position Cell Contents Printing Workbook Contents · Print Workbook Contents Using Default Print Options · Set Page Breaks · Set Print Options Managing Large Workbooks · Format Worksheet Tabs · Manage Worksheets in a Workbook Training Name: HB Certified Programme in Intermediate Excel 2010 Duration: 16 hrs Training Content: Creating and Editing Formulae • Concept of Formulae • Creating Formulae, Editing Formulae • Mathematical Order • Copying Formulae • Using Functions - Sum, Average, Max, Min, Count, Counta • Applying Absolute (Fixed) Referencing Formatting and Proofing • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formatting • Copying and Clearing Formats • Working with Styles • Spell Check, Find & Replace and AutoCorrect Range Names • Naming individual or range cells • Deleting and amending named ranges • Using named cells/ranges in formulae Conditional Functions & Formats and Date Calculations • Benefits and purpose • If Statements, Nested If • And, Or, Not • Combining If, And, Or, Not • Sumif, Countif • Conditional Formatting • Entering Dates and Times • Different date/time formats • How dates are stored • Calculating working days • Using the DAY(),MONTH(),YEAR() functions Formulae Auditing • Formula Auditing Tools • Revealing Formulae • Tracing Precedents/Dependents • Goto Special Worksheet Management & Linking • Linking sheets in the same file • Linking different Excel files • Using Edit, Links • Viewing different files at once • Saving a workspace • Viewing different sheets at once • Window Split • Data consolidation Basic List Management • Sorting Data • Adding Subtotals • Autofilter • Freeze Panes • Group and Outline • Data Form Excel Charts / Graphs • Using the Chart Wizard • Editing and Formatting charts • Saving custom chart types • Setting a default chart type Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsValue, IsDate, IsNull, IsErr, Is Error, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Protecting file • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Introduction to Macros • Purpose of Macros • Recording macros • Where to save macros • Running macros: • Custom buttons, menu items, keyboard shortcuts Visual Basic for Applications Environment • Visual Basic Editor and its options • Component Management • Shortcuts Connecting to Database/Outlook • Connect to MS Access • Access Database & Retrieve Data from MS Access • Create Table & Query Data Filter DB using Query • Update and Modify DB • Retrieve the Information through Excel from Outlook using VBA Advanced Excel 2010 Training Name: HB Certified Programme in Advanced Excel 2010 Duration: 24 hrs Training Content: Getting started with Macros · Recording and Modifying Macros · Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment · Visual Basic Editor and its options · Component Management · Shortcuts Introduction to Procedural Programming · Procedures: Functions and Sub-routines · Data Types Control Flow · If...Then....Elseif....Else....Endif · Case · Do...Loop, While · For... Next · Exit · VBA and Sheet Data Exchange (Cells, Range Methods) · Getting and Printing Data from Users (InputBox, MsgBox) · how to link with Ms Access and SQL Call/Whatsapp 8939693655

Job Oriented Advance Excel & VBA Training Training Module – MS-Excel 1 Introduction and Excel Basic Functions a What is Excel b Paste Special Feature c Conditional Formatting d References • Relative References • Absolute References • Mixed References e Hyperlinks f Naming Range g Viewing Worksheet Formulas h Adding and modifying comments i Excel Counting Formulas • COUNT • COUNTA • COUNTBLANK • COUNTIF • COUNTIFS j Conditional Sum and other Formulas • SUM • SUMIF • SUMIFS • SUMPRODUCT • SUMSQ • SUM2PY2 k Text Formulas • EXACT • LOWER • UPPER • PROPER • LEFT • RIGHT • MID • FIND • REPLACE • SUBSTITUTE • SEARCH 2 Logical and Lookup Functions a Logical Functions • IF • AND • OR • NOT b Lookup Functions • LOOKUP • VLOOKUP • HLOOKUP • MATCH • INDEX • CHOOSE c Adding password to workbook d Useful shortcut keys e Common Excel Errors • ####### • #NAME • #VALUE • #DIV/0 • #N/A 3 Creating Charts Pivot table and adding Validation a Creating Charts i Bar Chart ii Pie Chart iii Line Chart iv Other Charts b Pivot table i Creating a PivotTable ii Refreshing data iii Creating PivotChart c Adding Validation i Creating a drop-down ii Creating a Drop-Down List iii Prevent Duplicates With Data Validation iv Limit the Total v No Leading or Trailing Spaces vi No Spaces in Text vii Restrict Date Range Prohibit Weekend Dates 4 VBA a Creating a Macro b Workbook and Worksheet Objects c Range Objects d Variables If Then Statement and Loops e String Manipulation f Date and Time g Events h Array i Function and Sub j ActiveX Object s and User form

About The Event There's a lot in excel that most of us are not aware. Though you work day in and out on Excel, but is that the only way? We have combined all the possible scenarios excel can be used for in day-2-day life of a data analyst. Learn all the amazing features of excel in a 2 day fast track course. Upskill Technologies provides 2 day workshop for Advanced Excel and Dashboards. We have over 10 years of experience in providing corporate training on MS-Excel in Hyderabad. Having trained more than 1000 students we have a great flavor for teaching with practical and real time examples. Content is as follows: Creating Templates, Formatting, Creating Tables, Changing Default Options, Writing Formulas, If Conditions, Conditional Formatting, Using Formulas in conditions, Sum-IF, Count-If, Vlookup, Pivot Table Subtotals, Data Validation, Protecting Sheet and Workbook. Batch will start on 29 April -2017 @ 9 AM. Please visit Upskill Weekend Workshop Details for any further details.

Organizing data and communicating the data in an easy to understand & compelling way is one of the most in-demand skills that employers are looking for in their employees. At LearnVern we offer a comprehensive free MS Excel tutorial in Hindi and other vernacular languages to help you turn large data sets into helpful charts and graphics.  Whether you are a beginner or a professional in MS Excel, we can help you analyze the data better and introduce you to advance MS Excel functions such as the Pivot table, Vlookup, and others.  Get started with your free MS Excel training today by calling us at 8849004643 or write to us at info@learnvern.com to send us your inquiries. You can also visit us at https://www.learnvern.com/course/ms-excel-tutorial to learn more about our MS Excel course!

Myself Rahul Yadav Iam an working professional. I work on MIS reports and all report required for Top Management in Excel Iam Having 10 Years of Experience. In my Course I will be teaching all the advance excel features which is not shown in norm Ms office classes. Like Pivot Table,Vlookup,Using Macros, Useful Short cuts etc. This is for working professional and beginner also who is working in excel and want to make there day to day work easy. Any formatting and any Job work in excel is also accepted. Batches will be on timing which is suitable to you.

Microsoft certified Excel Training institute in Hyderabad, Our Course covers advanced Excel Functions like Vlookup, Nested Ifs, Pivot Tables, Dashboards, Data Validation, Charts, Protection etc, Batch starts on Aug-

Upskill Technologies provides 2 day workshop for Advanced Excel and Dashboards.Mohd Arsalan has over 7 years of experience in providing corporate training MS-Excel in Hyderabad. Having trained more than students he has a great flavor for teaching with practical and real time examples.Content will be Creating Templates, Formatting, Creating Tables, Changing Default Options, Writing Formulas, If Conditions, Conditional Formatting, Using Formulas in conditions, Sum-IF, Count-If, Vlookup, Pivot Table Subtotals, Data Validation, Protecting Sheet and Workbook. Batch will start on . Please visit our site. If you need any information Please Contact us. e-mail: Cont.No.

Advanced excel Training (Vlookup Hlookup if iferror sumif countif pivot table text function etc)

For Ms Excel & PPT Training pls contact me In formulas:- Vlookup Hlookup countif & Countifs sumif & Sumifs IF condition & nested IF Match & Index And some functional formulas (Left,Right,Upper,Lower,Proper,Date,Time, Duration) Data aliegnment:- Pivot table Conditional formatting Data validation Chart preparation Guidance to how to prepare dashboard for performance tracking, to maintain proper database

Payroll Training: 1) Training will be given for 1 month. If you are not perfect in any topic I can extent for more days if require. 2) I have around 4 years of experience. My experience as payroll was in Infosys Ltd, Samsung, and Wipro. Right now I am working in MNC. And I am also handling small SME’S as a payroll consultant. 3) Please Note: Training will not be given on Saturdays and Sundays. 4) Please Note: Training will not be given on working hours. Working Hours Include Mon to Fri (10 AM to 7 PM) where it is completely my office working hours. 5) Training might be in morning or evening according to your convenience. (6 AM to 9 AM) AND (7.30 to ) Complete practical training course. You will be give practical problems and solutions. 7) Material and free payroll software CD will be given to you. 8) At least 2 Payroll Software training. Practical problems on payroll software. 9) After training you will be able to do complete payroll process for minimum 150 employees. 10) All PF, PT and ESI forms will be given to you and forms will be filled by you. So that you get practical experience. Real time training is plus point for candidates. Small projects will be given to candidates and they have to work on it. Training Cost: RS /- Please Note: 1) No Discount on fees. As fees are too low compare to other Institutes there is no discount on it. 2) It is completely Individual training. It is not an Institute. 3) Demo will be given to interested candidates. After demo candidates should pay the amount. If anyone interested, please call to me. Name: Naveen. Phone No: zero nine double five zero double four one eight nine one. Topics to be covered in training: Module – Payroll / Statutory Compliances Management.(Compensation Management) • Preparing MIS Reports in Payroll • Pay Structure • Basic, DA, HRA, Conveyance, Medical allowances, Travel Allow. other allowances etc calculations. • Leave Management (CL, EL, and SL etc), Leave Register Online & Offline. • • PF,ESI,PT – Deductions, Statutory Acts, Rules, Procedures, Forms, Formats, Fillings, Assessment Procedures,Contributions, Calculations & Employee Benefits. Note: PF, ESI, and PT registration process also will be taught as course syllabus. • TDS (Form 16, ITR etc…), Forms Exemptions like 80D, 80DD, 80G, 80U, 80EE, 80CCA- Tax Calculation. Tax planning, Tax Slab rates, Exemptions. • Bonus, Gratuity. • Statutory Forms Filing • Calculation of Net & Gross Salary • CTC Designing, CTC break up as per offer letter. • Designing the pay slip with all statutory and other deductions. • Preparing payroll summary. • Details Required for Employee DATABASE • Preparation of Salary Break- Monthly and Annual. • Overtime Calculation • Pay slip in Excel • Payroll Software • Statutory Compliances – Contract Labor Act / Workman Compensation Act. / Factories Act. / Minimum Wages Act / Maternity Benefits / Bombay Shop Act. Etc…(Documentation /Procedure) • PF / ESI / PT Government Online Submission (ECR, Challan, Half yearly-Annual Returns. Reimbursements, Local conveyance, Relocation Leave Encashment. • All the above calculation on payroll software as well as Execl. • Advance Excel: VLookup, Pivot tables, Short cut Keys, Formulas,Auto and Advance Filters, Sorting, Splits and Freeze panes, Conditional Formatting. After the training candidate able to use all the above functions independently.

ADVANCE EXCEL TRAINING Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsNumber, IsDate, IsNull, IsErr, IsError, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Mail merge, Macros Etc

ADVANCE EXCEL TRAINING Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsNumber, IsDate, IsNull, IsErr, IsError, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Mail merge, Macros Etc and many more Special concession for school & college students

Totally Free training on 24 the October from 8 am (Saturday) on Ms Office, DTP, And Tally ERP-9 in my own residence at Shyambazar. Address Jaydip Dasgupta Pratima Bhavan 4C, Mohanlal Street, Shyambazar, Kolkata-. Near Deshbandhu Park And Shyambazar Law College. One Computer and one Candidate and 1 hour 30 minutes for each candidate. you can solve one or two topics such as Table, Mail-Merge, File Protection etc in Word, Vlookup, Hlookup in different sheet, Advance Filter, Pivot Table etc in Excel, Vat,Stock, Godown, Inventory Portion, Tds in Tally ERP 9, Photoshop and Corel Draw etc in DTP etc. This is only for new candidates. (for both Male and Female candidates but must have Basic Computer knowledge). Book your name and timing for free training.

Working with Formulas/Functions • Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc • Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc • Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc • Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc • Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc • Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc • Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc • Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc Conditional Formatting • Using Conditional Formatting • Using Conditional Formatting with Multiple Cell Rules • Using Color Scales and Icon Sets in Conditional Formatting • Creating New Rules and Managing Existing Rules Data Sorting and Filtering • Sorting Data A-Z and Z-A • Using Filters to Sort Data • Advance Filtering Options Pivot Tables • Creating Pivot Tables • Using Pivot Table Options • Changing and Updating Data Range • Formatting Pivot Table and Making Dynamic Pivot Tables Pivot Charts • Creating Pivot Charts • Types of Pivot Charts and Their Usage • Formatting Pivot Charts and Making Dynamic Pivot Charts VBA Macro • Introduction to VBA Macro • Recording Macro & Understanding Code Behind • Editing, Writing VBA Code and Saving as Macro or Add-In • Adding Add-Ins in Excel Advance VBA Macro Training Syllabus • Introduction of VBA Macros • Recordings Macro • Working with VBA Editor • VBA Programming Concept • VBA Syntax and Semantics • Variable Type and Declaration • Decisions Making with Operators • Repeating Actions with a Loops • Procedures and Events • Functions • User Forms and GUI • Sort and Filter, PivotTables and Pivot charts with VBA Macros • ODBC Connectivity to SQL Database and Query Handling • File Handling

1.STATUTORY COMPLIANCE, COMPENSATION AND BENEFITS PF, ESI & PT Statutory Acts, Rules, Procedures, Forms, Formats, Filings, Assessment Procedures, Calculations & Employee Benefits. Payment Challans, Monthly returns, Half yearly returns,Annual returns, Settlement Forms, Transfer forms etc. Due dates & filing all the forms linking to the payroll summary. Payroll Payroll processing supported by real time exposure to the payroll software. Designing CTC breakup as per the offer letter. Designing break up for gross salary in view of tax exemptions & other related acts. Designing the pay slip with all statutory & other deductions. Preparing payroll summary. Updating employee s database for new joinees & discussion on settlement process/ F & F. Discussion on some formats like offer letter, Appointment letter, Relieving letter, Experience letter & confirmation letter. Discussion on formats used during employee joining & exit Process. LEAVE CALCULATIONS Eligibility Criteria for EL, CL & SL, Leave policy, Calculations, deductions & reimbursement. LABOUR LAWS Bonus act, Gratuity act, Shops & establishment act, Contract Labour act & Payment of minimum wages act. INCOME TAX Tax planning for employees. Tax slab rates. Exemptions and allowances. Deduction on savings & Investments. TDS Deductions, Format & Procedure for TDS Calculations. Form 16 & ITR. TDS on Professional consultancy services & employee working as consultants You ll have in-depth knowledge on all the areas of PF, ESI, PT, Payroll structure, Calculations Forms, Formats & Due dates, etc., including Income Tax, TDS & Tax Planning for employees up to Form 16 & Form 16A. Frequently asked questions in all statutory, IT, Payroll & Labour Laws. Assignments and projects. 2.HR GENERALIST AREA MIS Reports Advanced Excel reports with shortcut keys & formulas, i.e. Pivot Table, Goal Seek, Auto & Advanced filters, vlookup which is used to prepare MIS Reports. Policy Implementation Reasons and benefits Tips to draft policy manual /Employee hand book Discussion on different types of policy. Performance Management System Complete system of appraisal evaluation 360 appraisal process reverse appraisals discussion on Balance score card Introduction to value chain analysis and Six sigma Reports and formats. Competency Mapping SWOT Analysis Employee Engagement / Employee relation Employee grievance handling rag analysis attitude building case study concepts etc., Retention Management Attrition Matrix Attrition Issues Rewards & Recognition Organization culture building Talent Engagement Employee life cycle etc., 3.CORE HR Man power planning Process and Responsibilities Recruitment (Hands on experience on Job Portal) Recruitment cycle Background verification Sourcing Methods (Recruitment Budget / Planner) Sourcing Methods Documentation Formats and Reports. Joining Formalities and settlement process Responsibility Exit Interviews Reports & formats. Induction / Training and Development HR Jargons Management games and ice breakers Group Discussions Role play FAQ / FUT / Mock interviews and Team presentations Discussion on Typical / logical interview Questions 4.SOFT SKILLS Motivation, Communication Skills, Time Management PROFESSIONAL BENEFIT (End to End Career Solutions) For all trainees CV revision will be done in a professional approach with placement support. After CV revision if you forward the revised CV to any company, it will be shortlisted on priority basis Post training support provided regarding any hr issues during working period. Training Duration:Regular Batch:- 30 classes Days. Weekend Batch:- 10 - 12 Sunday