•     marker--v2 302, B - Wing, 3rd Floor, Pinnacle Corporate Park, Bandra Kurla Complex, Bandra East, Mumbai - 400051

Key Highlights

Complete MS Office Suite Training
Complete MS Office Suite Training
Learn Word, Excel, PowerPoint, and Outlook from basics to advanced functions tailored for workplace needs.
AI Tools Integration
AI Tools Integration
Boost productivity and content quality with AI-powered tools like ChatGPT, Grammarly, QuillBot, and more.
Practical Learning Approach
Practical Learning Approach
Hands-on labs, real-world examples, and mini-projects ensure learning by doing rather than just theory.
Smart Data Handling with Excel & AI
Smart Data Handling with Excel & AI
Clean, analyze, and visualize data using Excel functions, PivotTables, and AI assistants like Sheet AI and OpenRefine.
Smart Presentations & Reports
Smart Presentations & Reports
Design impactful presentations using Beautiful.ai, MagicSlides, and Canva AI; automate document formatting with DocuBot.
Career-Ready Skills in 3 Months
Career-Ready Skills in 3 Months
Gain essential digital literacy, automation expertise, and professional communication skills valued in every modern office.

About the Course

Microsoft Word
Microsoft Word

Learn advanced formatting, document design, mail merge, and use of AI tools for proofreading and content enhancement.

Microsoft Excel
Microsoft Excel

Master formulas, charts, PivotTables, and macros with support from AI tools to simplify calculations and automate analysis.

Microsoft PowerPoint
Microsoft PowerPoint

Create visually engaging presentations with themes, animations, and AI-generated slide content and voiceovers.

Microsoft Outlook
Microsoft Outlook

Manage emails, calendars, meetings, and contacts efficiently with automation using rules, filters, and integration tools.

AI Writing & Editing Tools
AI Writing & Editing Tools

Explore Grammarly, Wordtune, QuillBot, ChatGPT, and more for grammar correction, paraphrasing, and content generation.

Internet & Digital Productivity
Internet & Digital Productivity

Navigate email platforms, search engines, online collaboration tools, and blogging platforms confidently.s

Content

The course is open to all learners, regardless of background or skill level. Basic computer literacy is helpful but not mandatory.

  • Computer Basic, Creating Folder, Paint
  • Directories, input units, Output unit
  • Central Processing Units,
  • What is hardware, what is Software?
  • Windows short cut keys

    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 Underline 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 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
  • Merge and split 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 field
  • Merging with outlook contact
  • Preview Result
  • Merging envelopes
  • Merging to label
  • Setting rules for mergers
  • 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

    AI Tools

  • Grammarly – Real-time grammar, spelling, and tone correction
  • Hemingway Editor – Simplify complex sentences and improve readability
  • Quill Bot – Paraphrasing and summarization of content
  • Word Tune – Alternative sentence suggestions to improve tone and style
  • ChatGPT – Content generation for reports, letters, or proposals
  • DocuBot – Auto-formatting documents with structured headings and consistent design

    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 Underline
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells

    Perform Calculations with Functions

  • Creating Simple Formulas
  • Setting up your own 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 filtering data
  • Using 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 pivot Table.
  • Inserting slicers
  • Creating Calculated fields

    Protecting and sharing the workbook

  • Protecting a workbook with a password
  • Allow user to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Document and Power point Presentation.

    Use Macros to Automate Tasks

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

    AI Tools

  • ChatGPT (for Excel) – Generate formulas, explain functions, and automate logic
  • Sheet AI (Google Sheets) – Summarize and analyse data patterns with AI
  • Open Refine – Clean large, messy datasets quickly and accurately
  • Excel Built-in AI – Use “Analyse Data” for insights, trends, and predictive suggestions

    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 Underline
  • Cut, Copy, Paste, Select All, Clear text
  • Find & Replace
  • Working with Tabs and Indents

    Creating slides and applying themes

  • Inserting new slide
  • Changing 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 bordering
  • 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
  • Modifying a Default or Custom Animation
  • Reorder Animation Using Transitions
  • Applying 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 slide show
  • Rehearse timing
  • Creating 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

    AI Tools

  • Beautiful.ai – Auto-design slides with smart layouts
  • Magic Slides – Generate complete presentations from text input
  • Tome – Create AI-generated decks with content and visuals
  • Canva AI – Use AI templates for visually rich designs
  • Synthesis AI – Generate AI voiceovers from slide text
  • Pictory AI – Convert text or blogs into explainer videos for presentations

  • Managing emails, contacts, calendars, and tasks
  • Creating rules, filters, and auto-replies
  • Organizing meetings with scheduling assistant
  • Integrating with MS Teams and OneDrive

    AI Tools

  • Flowrite – AI-powered email composition
  • ChatGPT – Generate, summarize, and rephrase email content
  • Rytr – Draft persuasive email content or replies
  • Grammarly – Enhance clarity, tone, and correctness
  • Zapier – Automate email-based workflows (e.g., form submission triggers email alerts)

  • What is Internet? Receiving Incoming Messages
  • Sending Outgoing Messages, Email addressing
  • Email attachments, Browsing, Search engines
  • Text chatting, Job Searching
  • Downloading video and Music
  • Uploading Video or Music, Voice chatting, Webcam Chatting etc.
  • Introduction to Blogging, Facebook

Learners Outcome

G-Tec Jain Education Learners Outcome
  • Create and format professional documents using MS Word.
  • Analyze, visualize, and automate data workflows with Excel.
  • Build impactful presentations with smart design and multimedia integration.
  • Efficiently manage communication and schedules with MS Outlook.
  • Enhance writing, presentation, and data tasks using AI tools.
  • Become job-ready with digital and AI-integrated office skills.

Career Path

  • Office Executive / Administrative Assistant
  • Office Executive / Administrative Assistant
  • Content Creator / AI Content Assistant
  • Digital Marketing Support Staff
  • Presentation Designer
  • Virtual Assistant / Freelance Support Professional
G-Tec Jain Education Learners Outcome

Certificate

    • GJK:The C-OAG course is a comprehensive 4-month program, meeting current IT industry needs. It equips students with office automation, graphic design (CorelDRAW & Photoshop), and basic financial accounting (Tally Prime 2019) skills. MS Office 2019 proficiency covers document creation, data management, email, and presentations. Graduates are prepared for diverse roles in Office Admin, Graphic Design, and Data Entry.
    G-Tec Jain Education GJK
    • JAIN:The Certificate Office Automation and Graphics (C-OAG) course is a comprehensive 4-month program designed to cater to the present needs of the Information Technology industry. It equips students with essential skills in modern office automation, graphic designing using CorelDRAW & Photoshop, and basic financial accounting tasks using Tally Prime 2019. Participants gain proficiency in MS Office 2019 for efficient document creation, data management, email communication, and presentation design. With basic Tally Prime 2019
    G-Tec Jain Education JAIN

Course Overview

Video Bg Image


Our Affiliations & Associations

We believe people are at the centre of every solution, leading us to the right solution just waiting to be delivered.



G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education
G-Tec Jain Education


TESTIMONIALS OF THE ESSENTIAL COURSE

Frequently Asked Questions

  • No. The course is beginner-friendly and open to all. Basic familiarity with using a computer is helpful but not required.
  • You’ll work with tools like ChatGPT, Grammarly, QuillBot, Beautiful.ai, Sheet AI, and more. Many offer free versions or trials during training.
  • Yes. You will receive a recognized certificate titled “Certificate Course in Office Tools with AI Tools” upon successful completion.


keerti Learner Support

Throughout the course, learners will have access to dedicated support from instructors and course mentors. They can ask questions, seek clarification, and receive guidance to enhance their learning experience.
Additionally, the course provides a collaborative learning environment where students can interact with peers, share insights, and learn from each other's experiences.

For more details connect with us:

G-Tec Jain Education Phone Number
Phone Number
G-Tec Jain Education Email
Email
[email protected]

Interested In Course

Download the Brochure by filling the form below