100% Practical JOB ORIENTED Industrial Training

HR / Marketing / Finance

For BBA/ MBA Students

BBA / MBA Practical Training Syllabus

 

RECRUITMENT & SELECTION

  • Job posting
  • Work with Online job portals
  • Conduction Of Mock Interviews
  • Conduction Of Group Discussion
  • Preparation Of Resume ( Bio Data, CV, Resume )
  • Attendance Policy
  • Leave Policy
  • Drafting Of Offer Letter
  • Drafting Of Appointment Letter
  • Drafting Letters Regarding Performance Appraisal
  • Drafting Letters Regarding Demotion, Layoff, Retrenchment, Dismissal of an Employee.
  • Designing Of Job Description And Job Specification
  • Employee MOU & Bond
  • Activities

BUSINESS / OFFICE HANDLING & MANAGEMENT

  • Agenda Of Meeting
  • Minutes Of Meeting
  • Circulars
  • Mail Writing /Drafting
  • Business Reports
  • Press Release
  • Business Correspondence/ Business Letters
  • Bank Correspondence
  • Quotations Inviting
  • Tenders 

SALES MANAGEMENT

  • Personal Selling
  • Cold Calling
  • Telesales
  • Digital Marketing
  • Internet Marketing/Selling
  • Activity 

 PAYROLL ADMINISTRATION

  • Maintain Attendance Sheet
  • Introduction about Salary Components (Basic/HRA/CA Etc.)
  • Deduction Of PF, ESI &Tax Etc.
  • Calculation Of Gross Salary ,CTC & Take Home Salary
  • Preparation Of Salary Sheet In Excel
  • Processing Basic  Payroll In Tally.ERP 9
  • Creation Of Employee Master
  • Creation Of Payroll Units
  • Creation Of Payroll Heads
  • Attendance / Production Types
  • Defining Salary Details Of An Employee
  • Salary Processing
  • Payroll Reports
  • Generating Pay slips
  • Generating Attendance Sheet
  • Generating Payroll Statutory Summary

  

ADVANCED EXCEL:

Work with Multiple Worksheets  Multiple Sheets

  • Renaming Sheets
  • Using the Clipboard Group
  • Insert and Delete Sheets
  • Copy and Move Sheets
  • Worksheet Groups
  • Applying formulas across sheets

Prepare and produce a spreadsheet  Name ranges

  • Working with named ranges
  • Deleting a named range
  • Creating names from a selection
  • Using Paste Special
  • Working with Links
  • Editing Links
  • Worksheet Protection

Data commands

  • Sorting and filtering data
  • Validation
  • Subtotals
  • Grouping and Outlining
  • Using the Consolidate command
  • Working with Advanced Filters
  • Working with External Data
  • Importing data from a text file
  • Converting Text to Columns
  • Working with a data form

Advanced Functions

  • Database Functions
  • Lookup Functions
  • Logical Functions
  • Text Functions

Customizing Microsoft Excel

  • Setting Excel Options
  • Excel Add-ins
  • Customizing the Quick Access toolbar

Working with charts

  • Why do we use charts/graphs?
  • Chart terminology
  • Creating a chart
  • Creating a chart using Insert
  • Setting or changing the chart type
  • Chart Titles
  • Chart Location
  • Moving, Resizing and Deleting charts as Objects
  • Formatting a chart
  • Printing charts
  • Working with Spark lines
  • Using the Drawing Tools and Pictures

PivotTables  Working with Excel

  • Tables
  • Understanding a Pivot Table
  • Data for a Pivot table
  • Creating a Pivot table
  • Add, copy, rearrange, and remove fields
  • Add a calculated field
  • Using the Pivot table filters
  • Changing Pivot table filters
  • Modifying the Pivot Table placement
  • Change Active Field settings
  • Pivot Table options
  • Change the Pivot Table layout
  • Change the Pivot Table design
  • Change the Pivot Table Tools design style options
  • Crating Pivot Charts
  • Insert Slicers
  • Deleting a Pivot table report or chart

Macros

  • Understanding Macros
  • Developer Tab
  • Macro Security levels
  • Trusted locations
  • Recording a macro
  • Running Macros
  • Assigning Macros to Objects

BOOK YOUR FREE DEMO CLASS