Diploma In MS Office

by CATS Computer Education Claim Listing

 Unleash the power of MS Office with  hands on practical and project work. Real time classes with industrial  experts with windows based. Basic to advanced  level courses with fast and affordable prizes.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

CATS Computer Education Logo

img Duration

Please Enquire

Course Details

 Unleash the power of MS Office with  hands on practical and project work. Real time classes with industrial  experts with windows based. Basic to advanced  level courses with fast and affordable prizes. We are providing courses in 3 different level, Basic, Advanced and Full  Course (Basic to Advanced + Project Work).

 

Modules:

  • MS-WORD

  • Module 1: Text Basics   

  • · Typing the text, Alignment of text  

  • · Editing Text: Cut, Copy, Paste, Select All, Clear 

  • · Find & Replace  

  • Module 2: 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 

  •  Module 3: 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 

  • Module 4: Header & Footers  

  • ·  Inserting custom Header and Footer 

  • · Inserting objects in the header and footer 

  • · Add section break to a document   

  • Module 5: Working with bullets and  numbered lists

  • · Multilevel numbering and Bulleting 

  • · Creating List 

  • · Customizing List style 

  • · Page bordering 

  • · Page background 

  • Module 6: Tables

  • · Working with Tables, Table Formatting 

  • · Table Styles 

  • · Alignment option 

  • · Merge and split option 

  • Module 7: 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 

  • Module 8: Merging Documents

  • · Typing new address list 

  • · Importing address list from Excel file 

  • · Write and insert field 

  • · Merging with outlook contact 

  • · Preview Result 

  • · Merging to envelopes 

  • · Merging to label 

  • · Setting rules for merges 

  • · Finish & Merge options

  • Module 9: 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 

  • Module 10: Proofing the document

  • · Check Spelling As You Type. 

  • · Mark Grammar Errors As You Type. 

  • · Setting AutoCorrect Options 

  •  Module 11: Printing  

  • · Page Setup, Setting margins 

  • · Print Preview, Print 

  • MS-EXCEL

  • Module 12: Introduction to Excel  

  • · Introduction to Excel interface 

  • · Understanding rows and columns, Naming Cells 

  • · Working with excel workbook and sheets  

  • Module 13:Formatting excel work book:

  • · 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   

  • Module 14: 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. 

  •   Module 15: Sort and Filter Data with Excel  

  • · Sort and filtering data 

  • · Using number filter, Text filter 

  • · Custom filtering 

  • · Removing filters from columns 

  • · Conditional formatting 

  • Module 16: 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  

  •  Module 17: 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 slicer 

  • · Creating Calculated fields 

  •  Module 18: Protecting and Sharing the  work book

  • · 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. 

  •  Module 19: Use Macros to Automate Tasks

  • · Creating and Recording Macros 

  • · Assigning Macros to the work sheets 

  • · Saving Macro enabled workbook 

  •  Module 20: 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 back ground error checking 

  • · Setting AutoCorrect Options

  • MS-POWERPOINT

  • Module 21: 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 

  • Module 22: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   

  • Module 23: Working with bullets and numbering  

  • · Multilevel numbering and Bulleting 

  • · Creating List 

  • · Page bordering 

  • · Page background 

  • · Aligning text 

  • · Text directions 

  • · Columns option 

  • Module 24: 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 

  • Module 25: Hyperlinks and Action Buttons  

  • · Inserting Hyperlinks and Action Buttons 

  • · Edit Hyperlinks and Action Button 

  • · Word Art and Shapes 

  • Module 26: 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  

  • Module 27: Using SmartArt and Tables

  • · Working with Tables, Table Formatting 

  • · Table Styles 

  • · Alignment option 

  • · Merge and split option Converting text to smart art

  • Module 28: 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   

  • Module 29: Using slide Master  

  • · Using slide master 

  • · Inserting layout option 

  • · Creating custom layout 

  • · Inserting place holders 

  • · Formatting place holders   

  • Module 30: Slide show option  

  • · Start slide show 

  • · Start show from the current slide 

  • · Rehearse timing 

  • · Creating custom slide show   

  • Module 31: 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      INTERNET & E-MAIL    

  • · 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   

 

  • Krishnagiri Branch

    385/153, Bangalore Rd, near Old EB Office, Krishnagiri

Check out more Microsoft 365 (Office) courses in India

IT Computer Mission Logo

Advanced Excel

Advanced Excel is a part of Microsoft Excel that allows the users to build a complex, large, and nested formula with the combination of different functions.

by IT Computer Mission [Claim Listing ]
Cyberoism Logo

Advanced Excel

Advanced Excel course is offered by Cyberoism. We provide wide range of Training Programs to improve the skills and competency of Employees, Individuals, Organizations etc.

by Cyberoism [Claim Listing ]
Computers Management and Information Logo

Microsoft Outlook

Microsoft Outlook course is offered by Computers Management and Information for all skill level. Our core strength is our team of Expert Trainers / Faculties / Instructors consisting of MCAs/ Engineers / Graduate’s in Computer Science having strong domain knowledge.

by Computers Management and Information [Claim Listing ]
  • Price
  • Start Date
  • Duration
CWC (Computer World Classroom) Logo

Certificate In Office Automation

Certificate in Office Automation course is offered by CWC (Computer World Classroom). At our computer institute, we take pride in providing high-quality education and training to students seeking to enhance their skills in the ever-evolving field of technology.

by CWC (Computer World Classroom) [Claim Listing ]
DigitalAlig Logo

Excel Advance

There are functions and advanced excel formula’s that can be used for complex calculations. The functions are designed for easy query and organizing of an enormous pool of information, whereas the advanced excel formula is executed to get new data from a given specific set of information.

by DigitalAlig [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy