CCROM (Certificate in Customer Relationship and Office Management)

ASAP Kerala Affiliated Office Management course with 100% Job assurance.

This comprehensive course will answer your search “How to get an office job?” and equip you with all the essential skills you need to secure an office job in India and abroad.

  • Affiliated with ASAP, Kerala
  • Acquire industry-oriented skills and knowledge.
  • Syllabus has been finalized under the supervision of subject experts from ASAP Kerala.


Degree Pass or failed


Normal Track: 8 Months ,Fast Track: 4 Months


ASAP (Govt. of Kerala)

What will you learn in CCROM (Certificate in Customer Relationship and Office Management) ?

Self Analysis

     Introduction to module | Ice breaking | Who am I- Make a note | SA: questionnaires | SWOT analysis | Detailed Self-introspection | Johari window – Self-awareness | self-confidence


     Factors influencing attitude | Influence of attitude on behaviour | KSA – Knowledge skills and attitude | Personal social and professional etiquette.

Interpersonal skills

     Need for interpersonal skills | Gratitude | Being thankful | Understanding anger and ways to deal with it | Secret of happiness | Morals | Values and Ethics | Integrity | Work Ethics | Civic Virtue | Respect for Others | Living Peacefully | Caring | Sharing | Honesty | Courage | Valuing Time| Cooperation| Commitment | Empathy |Team Work | Networking | Importance of teamwork | Teamwork activity | Leadership qualities | Importance of decision making | Weighing positives and negatives | Process and practical way of decision making.

Stress Management and Motivation

     Stress Management: Stress | Reasons and effects | Identifying stress | Stress diaries | The four A’s of stress management | Techniques | Approaches: action-oriented | Emotion-oriented | Acceptance oriented | Resilience | Gratitude Training | Coping with emotions: Identifying and managing emotions | Harmful ways of dealing with emotions | Relaxation techniques | Self-Motivation | Factors | Self-motivation methods and activities | Tapping and tuning inner voice


     Need for Creativity in the 21st century | Thinking out of the box | Creative and Lateral Thinking | Torrance test of creative thinking | Creative challenges and activities.

Goal setting

     Wish list | SMART goals | Short | long | lifetime goals | Blueprint for success | 5W1H | Time management | Value of time | Test your Time management skill Weekly planner | TODO list | Prioritizing work | Time management matrix | Psychometric tests


     Rate my language-I | Common speaking issues and tips | Verbal and Non-Verbal Communications | Effective use of body language | Let us start Speaking | Tips for the beginners | Tests | Activity 1 – Group discussion | GD Assessment | Activity 2 – Talk for 2 min | Assessment | Activity 3 – Online/Offline face-to-face Speaking skills | Assessment


     Importance of reading | reading practice I | Assessment | Reading Practice II | Assessment | Reading Practice III | Assessment


     Rate my skill – I | Beginner’s activity | Rate my skill – I | Beginner’s activity | Technical Writing: Differences between technical and literary style | Elements of style; Common Errors | Letter Writing: Formal | Informal and demi-official letters; business letters | Job Application: Cover letter | Differences between biodata | CV and Resume | Rate my skill- II


     Importance of Listening | Listening practice I | Assessment | Listening practice II | Assessment | Listening practice III | Assessment

Preplacement Training

     Summing up life skills qualities | Email- Business Communication | Professional profiles in digital platforms | Grooming | What is a Structured Interview? Preliminary Preparation | Do’s & Don’ts of an Interview | Discussion of frequently asked questions in the interview | Real-world interviews examples | Personal Interview Assessment with constructive feedback

Daily half-hour language lesson is combined with continuous reading, writing, listening, and speaking modules.


Text Basics

  • Typing the text, Alignment of text
  • Editing Text: Cut, Copy, Paste, Select All, Clear
  • Find & Replace

Text Formatting and saving file

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Change the Text Case
  • Line spacing, Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings – To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Header & Footers 

  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Add a section break to a document

Working with bullets and numbered lists

  • Multilevel numbering and Bulleting
  • Creating List
  • Customizing List style
  • Page bordering
  • Page background


  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option

Styles and Content 

  • Using Build- in Styles, Modifying Styles
  • Creating Styles, Creating a list style
  • Table of contents and references
  • Adding internal references
  • Adding a Footnote
  • Adding Endnote 

Merging Documents 

  • Typing new address list
  • Importing address list from Excel file
  • Write and insert the field
  • Merging with outlook contact
  • Preview Result
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges
  • Finish & Merge options

Sharing and Maintaining Document

  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks 

Proofing the document 

  • Check Spelling as You Type.
  • Mark Grammar Errors as You Type
  • Setting AutoCorrect Options


  • Page Setup, Setting margins
  • Print Preview, Print 


Introduction to Excel

  • Introduction to Excel interface
  • Understanding rows and columns, Naming Cells
  • Working with excel workbook and sheets

 Formatting Excel workbook:

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells

Perform Calculations with Functions 

  • Creating Simple Formulas
  • Setting up your formula
  • Date and Time Functions, Financial Functions
  • Logical Functions, Lookup and Reference
  • Functions Mathematical Functions
  • Statistical Functions, Text Functions

Sort and Filter Data with Excel

  • Sort and filter data
  • Using a number filter, Text filter
  • Custom filtering
  • Removing filters from columns’ conditional formatting

Create Effective Charts to Present Data Visually

  • Inserting Column, Pie chart etc.
  • Create an effective chart with Chart Tool
  • Design, Format, and Layout options
  • Adding chart title
  • Changing layouts
  • Chart styles
  • Editing chart data range
  • Editing data series
  • Changing chart

Analyze Data Using PivotTables and Pivot Charts

  • Understand PivotTables, Create a PivotTable
  • Framework Using the PivotTable and PivotChart
  • Create Pivot Chart from the pivot Table.
  • Inserting slicer
  • Creating Calculated fields

Protecting and sharing the workbook

  • Protecting a workbook with a password
  • Allow users to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Documents and PowerPoint Presentation.

Use Macros to Automate Tasks

  • Creating and Recording Macros
  • Assigning Macros to the worksheets
  • Saving Macro enabled workbook

Proofing and Printing

  • Page setup, setting print area, Print titles
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, setting margins, Print Preview, Print
  • Enable background error checking
  • Setting AutoCorrect Options



Setting Up PowerPoint Environment:

  • New, Open, Close, Save, Save As
  • Typing the text, Alignment of text
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Cut, Copy, Paste, and Select All, Clear text
  • Find & Replace
  • Working with Tabs and Indents

Creating slides and applying themes

  • Inserting new slide
  • Changing the layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Slide background
  • Formatting slide background
  • Using slide views

Working with bullets and numbering

  • Multilevel numbering and Bulleting
  • Creating List
  • Page bordering
  • Page background
  • Aligning text
  • Text directions
  • Columns option

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Change the Order of Objects
  • Inserting slide header and footer
  • Inserting Text boxes
  • Inserting shapes, using quick styles
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Hyperlinks and Action Buttons

  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes

Working With Movies and Sounds

  • Inserting Movie from a Computer File
  • Inserting Audio file
  • Audio Video playback and format options
  • Video options, Adjust options
  • Reshaping and bordering Video

Using SmartArt and Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option
  • Converting text to smart art

Animation and Slide Transition

  • Default Animation, Custom Animation
  • Modify a Default or Custom Animation
  • Reorder Animation Using Transitions
  • Apply a Slide Transition, Modifying a
  • Transition, Advancing to the Next Slide

Using slide master

  • Using slide master
  • Inserting layout option
  • Creating custom layout
  • Inserting place holders
  • Formatting place holders

Slide show option

  • Start slide show
  • Start show from the current slide
  • Rehearse timing
  • Creating a custom slide show

 Proofing and Printing

  • Check Spelling as You Type
  • Setting AutoCorrect Options
  • Save as Video
  • Save as JPEG files
  • Save as PowerPoint Show file
  • Print Preview, Print

Introduction | Accounting terms

     Accounting | Event and transaction | Bookkeeping and accounting | Stakeholders in business | Important business terms

Capital and revenue transactions | Accounting principles

     Capital and revenue expenditure | Capital and revenue receipt | Accounting concepts and conventions | Double entry system of bookkeeping

Account | Traditional and modern rules

     Account | Classification of account | Debit and credit | Traditional and modern rules relating to accounts


     What is journal | Journal preparation

Ledger | Trail balance

     What is ledger | Ledger posting | Ledger balancing

Cash book and its types

    Types of cash book and discount

Bank reconciliation statement


     Depreciation and its causes | Needs for charging depreciation | Factors considered for depreciation | depreciation methods.

Inventory valuation

     FIFO | LIFO

Trail balance

     Trail balance preparation

Trading and profit and loss account

     Trading account and its preparation | Profit and loss account and its preparation

Yearend adjustment entries

     Adjustments regarding final accounts

Balance sheet

     Preparation of balance sheet | Problems with final accounts

  1. Introduction to Excel 365
  2. Editing sheet | Formatting | Project1
  3. Worksheet view
  4. Viewing worksheet | Filling series | Flash fill
  5. Conditional formatting | Data validation
  6. Conditional formatting- new rule | Data validation
  7. Lookup and cell reference
  9. Important functions in Excel
  10. Remove duplicate values | Hyperlink | Important functions in excel
  11. Logical operations | sum and count functions
  12. Logical functions | sum | sumif | sumifs | count | countif | countifs
  13. Working with formulas
  14. Statistical functions and mathematical functions | Date related functions
  15. Text functions
  16. Text functions in excel | Match and index functions
  17. Database functions and subtotal functions
  18. Dsum | dcount | Subtotal functions
  19. Classic pivot table and chart
  20. Chart element | Pivot table and pivot chart
  21. Data extraction
  22. Filter and advanced filter
  23. Graphics and insert object function
  24. Custom view | Graphics | Insert object
  25. Print area setup
  26. Header and footer | Print area setup | Text to column function
  27. Important tools in excel
  28. Form data | Auditing tool | Web data
  29. Goal seak | Solver | Scenario manager
  30. Speak cell | Camera tool | Sparkline chart
  31. People graph | Data forecast | Import text file
  32. Mail merge | Consolidating data
  33. Macro | Password protection
  • Introduction
  • Data Visualization
  • Data Modeling
  • DAX
  • Report Design
  • Data Sharing and Collaboration
Accordion Content

Interested to join?

Please furnish your details below. Then, one of our course advisors will contact you for enrollment.

Choose preferred study centre

Career opportunities for CCROM (Certificate in Customer Relationship and Office Management)

  • Administrative associate
  • Office manager HR/Admin
  • Office Administrator Assistant
  • Office administrator
  • Back Office Assistant
  • Office Administration Cum Accountant
  • Office Operations Coordinator
  • Accounts and Office Administrator
  • Manager – Office Administration
  • Executive Assistant
  • Senior Office Administrator
  • Jr Executive
  • CRM Manager
  • CRM Executive
  • Executive/ Senior Executive – CRM
  • Accounts cum front office executive
  • Office Staff Cum Accountant
  • Accountant Cum Manager
  • Academic Coordinator
  • Guest Relation coordinator
  • Hr Admin Executive
  • Operations Executive
  • Sales Manager
  • Executive Secretary
  • Customer Relation Executive
  • Front Office Executive/Student Academic Counsellor
  • Executive/Assistant in Finance & Accounts
  • Education Counsellor
  • Admission Counsellor
  • Admission executives and counsellors

Frequently Asked Questions (FAQ)

Office management course

Customer Relationship and Office Management course- for passionate individuals !

Best Customer Relationship and Office Management  INSTITUTE in Kerala with accreditation from Capt– Skillspark The Finishing School offering job-oriented Customer Relationship and Office Management course. Customer Relationship and Office Management are the most job promising areas and this courses designed by experts for candidates who are passionate for a fulfilling career in the field of Customer Relationship, counselling, Administration, Marketing etc.

In today’s world digitization grows in rapid pace. Most of the companies prefer Multiskilled professionals in Administration as well as marketing. In such Scenario there is immense career opportunities for candidates in Office management and administration field with skill sets in various field.

We have designed this course to deliver such skillful professionals to the Customer relationship industries as well as creating eminent Employees with better interpersonal skills. This course also covers Allied skills such as Data Management, Office accounting, Data Analysis tools etc. The curriculum is designed for students from any background and based on rising Technologies and trends in current industry.