ASAP Kerala Affiliated Office Administration Courses in Kollam with 100% Job Assistance.

Office 365

Microsoft Word

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 

Introduction to Accounting

Key Accounting Terminologies | Understanding Accounting: Event and Transaction | Bookkeeping vs. Accounting | Role of Stakeholders in Business | Important Business Terminologies

Types of Business Entities

Sole Proprietorship | Partnership | Company | Formalities and Procedures for Establishing Each Entity

Accounting Principles and Concepts

Capital and Revenue Transactions | Generally Accepted Accounting Principles (GAAP) | Capital and Revenue Expenditure | Deferred Revenue Expenditure | Capital and Revenue Receipt | Accounting Concepts and Conventions | Double Entry System of Bookkeeping

Classification and Rules of Accounts

Account Definition | Classification of Accounts: Assets, Liabilities, Equity, Revenue, and Expenses | Debit and Credit: Traditional and Modern Rules

Journal and Ledger

Understanding the Journal: Purpose and Preparation | Ledger: Posting and Balancing | Trial Balance: Purpose and Preparation

Cash Book and its Types

Types of Cash Books: Simple, Two-column, Three-column | Understanding Discounts in Cash Book | Day Book Preparation Using Google Sheets

Depreciation and Its Impact

Definition of Depreciation and Its Causes | The Necessity of Charging Depreciation | Factors Considered for Depreciation Calculation | Methods of Depreciation (Straight-line, Diminishing Balance, etc.) | Provisions and Reserves

Trial Balance Preparation

Importance of Trial Balance | Steps for Preparing a Trial Balance

Trading and Profit & Loss Account

Trading Account: Definition and Preparation | Profit and Loss Account: Definition and Preparation

Year-End Adjustments

Adjustments in Final Accounts | Handling Prepaid and Outstanding Expenses | Treatment of Depreciation, Provisions, and Reserves

Balance Sheet Preparation

Structure and Format of a Balance Sheet | Preparation of Financial Statements Using Excel

Practical Journal Entry Practice Using JET Simulation

Advanced Excel

introduction to Advanced Excel | Excel sheet Creation, edit, save, Folder Creation | Project 1 [Introduction to Excel

Conditional Formatting & Data Validation

Cell reference, Conditional formatting| Data validation| Important functions in Excel, Remove duplicate values, Hyperlink| Filter, Unique, Sort, SortBY, Sequence, Randarray Functions|

Logical & Statistical functions

Logical functions | Sum & Count if functions| Graphics, Print area setup , Camera tool project| Statistical functions, mathematical functions , Date related functions,  Financial Functions| Dsum, subtotal functions, Text functions, Insert object| Data extraction| Averageif& Averageifs.

Advanced Pivot Table

Classic pivot table and chart| Slicers, timelines and calculated fields| Building hierarchies in pivot tables| Advanced Pivot table data analysis

Advanced Formula for Data Analysis

Custom view, Header and footer, Text to column function| Goal seek, Solver, Scenario manager| Lookup| Project| Match and index function, Consolidating data

Advanced Formula for Data Analysis

Sparkline chart, People graph, Data forecast, Import text file| Mail merge, Consolidating data| Form data, Auditing tool, Web data, Speak cell | Macro, Password protection

Data Preparation and Cleaning

Importing data from various sources. | Handling missing values and duplicates. | Using Text-to-Columns and Flash Fill. | Data validation and error checking for quality assurance.|

Date and Time Analysis

Working with DATE, TIME, NETWORKDAYS, and EOMONTH. | Automating rolling date ranges for dynamic reports. | Calculating time differences in hours, minutes, and seconds. | Custom formatting for date and time (e.g., “MMM-YYYY”). | Dynamic date ranges and custom date logic with WEEKNUM, WORKDAY.INTL

Power Query (Get & Transform)

Importing and cleaning data from various sources| Merging and appending queries| Advanced filtering and transforming data

Introduction to Dashboard Design

Understanding the importance of dashboards | Planning a dashboard project| Data visualization best practices| Advanced Charts

Dashboard 1: Payroll Management Dashboard

Importing employee payroll data. | Handling salary components (basic, allowances, deductions). | Net pay computation. | Overtime and bonus calculations. | Tax and statutory compliance computations.

Dashboard 2: Financial Analytics Dashboard

Importing financial statements and transaction data. | Profit and loss computations. | Cash flow analysis. | Revenue and expense visualizations. | Break-even analysis charts. | Scenario analysis using what-if parameters.

Dashboard 3: HR Management Dashboard

Importing employee data (demographics, performance metrics). | Employee turnover and retention rates. | Performance scoring and appraisal summaries. | Training needs assessment. | Workforce analytics visuals. | Interactive filters by department, role, or location. | Employee satisfaction and engagement indicators.

Dashboard 4: Inventory Management Dashboard

Importing inventory levels, sales orders, and purchase orders. | Stock levels and reorder points. | Inventory aging analysis. | Supplier performance metrics. | Real-time stock monitoring visuals. | Alerts for low stock and overstock situations. | Sales vs. inventory turnover graphs.

Dashboard 5: Project Management Dashboard

Importing project plans, task lists, and timelines. | Task progress tracking. | Resource allocation and workload analysis. | Budget vs. actual expenditure. | Milestone tracking visuals. | Risk assessment indicators.

Introduction to Power BI

Introduction to Power BI. | Power BI installation. | Main components of Power BI.

Data Import and Transformation

Data import and transformation. | Columns transformation. | Conditional formatting. | Data grouping. | Tooltip report page. | KPI visualization. | Map visualizations. | Card visual.

Power Query intro-User Interface

Power Query intro-User Interface| Data Consolidation in Power BI | Case Study -Payroll Data |

Advanced Visualizations and Data Consolidation

Advanced visualizations. | Data Modeling Intro-Start Schema| Case Study Sales Analysis| Snowflake Schema|

DAX Functions

Understanding DAX functions. | Adding new tables. | Logical functions. | Date and time functions.| Dax Syntax| Adding New Column| Adding New Measure| Adding New Table| Renaming Column &Measure| Arithmetic Operators

Statistical and Text Functions

Statistical functions (SUM, SUMX, MIN, MINX, AVERAGEX). | Text functions (LEN and others). | Hierarchy reports| Filter Functions|

Designing Interactive Dashboards

Designing interactive dashboards. | Matrix visualization. | Case Study: Sales Analytics Report (Project). | Case Study: HR Analytics Report (Project). | Publishing and sharing reports| Area Chart |Line  & Stacked Column Chart| Bookmark & Selection Pane| Data Grouping| Sorting|

KPI Visualization| Multi – Row Card| Formatting Visuals| Field settings| Tooltip Report Page| Table Visualization |Matrix Visualization|

Project

Top 10 Tricks in Power BI| Project 1, Project 2, Project 3

1. Orientation, Self-Assessment, and Personal Values
    Program Overview | Understanding Personal Values | Self-Reflection Techniques | Behavioral Interview Responses
2. Soft Skills Development
    Core Soft Skills | Applications of Soft Skills | Tools for Development | Interview and Online Professional Practices
3. CV Preparation
    CV Formats | Structuring and Refinement | ATS Optimization | Drafting and Reviewing
4. STAR Self-Introduction
    STAR Method Overview | Crafting STAR-Based Introductions | Practice and Feedback
5. Attitude Development
    Impact of Attitude on Behavior and Performance | Techniques for Positive Thinking and Self-Talk | Building Self-Esteem | Adaptability and Change Management
6. Goal Setting
    Importance of Goals | SMART Framework | Tools and Strategies for Achievement | Overcoming Challenges
7. Understanding Time Management
    Prioritization Techniques | Time Management Matrix | Four D’s Framework | Tackling Time Stealers
8. Emotional Intelligence
    Importance for Career Readiness | Goleman’s Framework | Stress and Crisis Management | Change Management in Careers
9. Leadership
    Core Leadership Qualities | Communication and Collaboration | Problem-Solving Techniques | Brainstorming and Cause-and-Effect Analysis
10. Social Consciousness
     Dimensions of Social Consciousness | Strategies to Improve Social Consciousness | Civic Responsibility | Sustainable Practices
11. Preparing for Employment
     Transition Strategies | Networking | Interview Skill Development | Crafting Cover Letters
12. Employability Skills
     Key Skills for Employability | Strategies to Improve Employability Quotient | Self-Assessment Techniques | Continuous Improvement
13. Communication at the Workplace
     Types and Direction of Communication | Non-Verbal Communication Strategies | Effective Verbal and Written Communication | Listening and Feedback
14. Presentation Skills
     Overcoming Fear of Public Speaking | Structuring Presentations | Delivery Techniques
15. Correspondence at Work
     Types of Workplace Correspondence | Attributes of Effective Correspondence | Professional Email Writing | The Seven Cs of Effective Communication
16. Teamwork
     Understanding Team Dynamics | Building Collaborative Skills | Healthy Communication in Teams | Conflict Management
17. Workplace Etiquette
     Cross-Cultural Communication | Grooming Standards | Professional Conduct | Culture and Gender Sensitivity
18. Problem-Solving and Decision-Making
     Frameworks and Tools | Real-World Applications
19. LinkedIn Profile Development
     Core Elements of Profiles | Optimizing Profiles | Networking Strategies | Creating Profiles

Final Project

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.