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

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

Attitude

     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

Creativity

     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

Speaking

     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

Reading

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

Writing

     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

Listening

     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.

MS OFICE

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

Tables

• 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

Printing 

• Page Setup, Setting margins
• Print Preview, Print 

MS EXCEL

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

MS POWERPOINT

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

Journal

     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

     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
8. FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, RANDARRAY, XMATCH, and XLOOKUP.
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