GtechJainx - Certificate Course in Office Tools with AI Tools

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

Office Executive / Administrative Assistant

Content Creator / AI Content Assistant

Digital Marketing Support Staff

Presentation Designer

Virtual Assistant / Freelance Support Professional

GJX: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) 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.

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. Participants gain proficiency in MS Office 2019 for efficient document creation, data management, email communication, and presentation design. With basic Tally Prime