•   Needs to know basic computer operation.

• Office Manager
• Executive Assistant
• Administrative Assistant
• IT Support Technician
• SharePoint Specialist
• Database Specialist
• Workbook Developer
• Research Analyst
• Project Coordinator

Today, Microsoft Excel may very well be the most used business software on the market. It has broad applications, from simple data entry to complex problem solving, that are used to make important business decisions. Thus the trademark green “X” for Excel is synonymous with money, and in fact most of the data being shuffled around an Excel spreadsheet really just boils down to dollars and cents in profit. Microsoft estimates that 5 – 10% of Excel users are using the more complex features of the application to create business insights, and these formula and function gurus can be considered programmers of sorts. It’s no surprise these “Excel programmers” are earning more than their colleagues. So if you like problem solving, data analysis, and the idea of making some big bucks, you may want to study up and become an Excel power user.

MS WORD

• Creating a Basic Document
• Explore the User Interface
• Open and View a Document
• Customize the Word Environment
• Obtain Help
• Enter Text
• Save a Document
• Preview and Print a Document
• Editing a Document
• Navigate and Select Text in a Document
• Insert, Delete, or Rearrange Text
• Undo Changes
• Search and Replace Text
• Formatting Text
• Change Font Appearance
• Highlight Text
• Formatting Paragraphs
• Set Tabs to Align Text
• Control Paragraph Layout
• Add Borders and Shading
• Apply Styles
• Create Lists

MANAGE FORMATTING

• Adding Tables
• Create a Table
• Modify the Table Structure
• Format a Table
• Convert Text to a Table or Tables to Text
• Inserting Graphic Objects
• Add Visual Effects Using Symbols and Special Characters
• Insert Illustrations
• Controlling Page Appearance
• Control Page Layout
• Apply a Page Border and Color
• Add Watermarks
• Add Headers and Footers
• Proofing a Document
• Check Spelling, Grammar and Word Count
• Enhance Textual Meaning Using the Thesaurus
• Customize AutoCorrect Options

MS EXCEL - EXCEL BASICS

• An overview of the screen, navigation and basic spreadsheet concepts
• Understand Excel terminology workbooks, worksheets, rows, columns, cells
• Various selection techniques
• Understanding the various mouse cursors
• Working with Ribbon Tabs, Groups and Dialog Boxes
• Standard and Contextual ribbons
• Use the task pane
• Understand and use the File Tab
• Saving, File types, File compatibility (earlier versions)
• Useful keyboard commands
• Quick Access Toolbar & Mini Toolbar
• Get Help!

ENTERING DATA

• Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
• Use Auto List feature
• Date and Time are storage in Excel
• Enter Dates and Times
• Date/time formatting
• Methods to Move and Copy data
• Use the Fill Handle to copy data and create simple lists
• Create series of information
• Insert, Delete and Hiding Rows & Columns
• Insert, Delete and Move Cells
• Insert, Delete, Move and Copy Sheets
• Various navigation techniques
• Creating & Editing Formula & Functions
• Define Formula
• Create & Edit Formula
• BODMAS : Mathematical Order
• Copy & Move Formula
• Use Basic Functions - Sum, Average, Max, Min, Count, Counta
• Use Autosum tool

FORMATTING AND PROOFING

• Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
• Quick formats and themes
• Sheet tab formatting and Renaming
• Copy and Clear Formats
• Merging cells
• Spell Check, Find & Replace and AutoCorrect

PRINTING AND PAGE SETUP

• Page Orientation
• Add Headers and Footers
• Print a selection
• Set a print area
• Clear a print area
• Multiple File & Large Workbook Tools
• Split screen tool
• Freeze panes
• Arrange workbook windows
• Zooming tools
• GoTo tool

MS POWERPOINT

• PowerPoint Overview
• User interface overview Ribbons, Tri Pane View (Normal)
• File Tab and usage
• Navigation Pane
• The PowerPoint views and how to access them
• Using Help
• PowerPoint Views
• The Normal View
• The Slide Sorter View
• The Notes Pages View
• The Reading view
• The Slide Show View
• The View in Black and White
• Viewing the Slide Miniature
• Accessing Print Preview
• How to access Outline View
• Creating a New Presentation
• Creating A New Presentation and Saving
• Create a presentation from inbuilt templates
• Placeholders
• Adding New Slides - entering & editing Text (slide view)
• Understanding Slide Layouts and changing / reapplying a layout
• Understanding the text levels
• Entering bulleted text
• Adding Freeform Text (text Boxes)
• Creating Blank Slides
• Formatting Text
• Text Selection

FORMATTING TEXT

• Formatting Backgrounds (Slide and Placeholder)
• Formatting Numbered and Bulleted Lists
• Format Painter
• Entering text in Outline
• Changing text levels
• Shortcut keys for navigating in outline

DRAWING TOOLS

• The Insert Ribbon
• The design & format ribbons
• Drawing basic shapes freehand
• Creating regular shapes
• Formatting Shapes including 3D, Shadows and Fill Effects
• Enter and format Smart Art
• Set Shape Options
• Connect shapes
• Graphics and Clipart
• Insert Clip Art
• Moving and Resizing
• Format Ribbon and Clip Art
• Grouping and Ungrouping Clip Art
• Tables and Charts
• Create and use a table
• Add text
• Insert columns and rows
• Format a Table
• Create a chart
• Edit the Chart Type
• Edit the Chart Options
• Format a chart
• Create an organisation Chart (Smart Art)
• Create an organisation Chart (Shapes)
• Edit and Format an Organisation Chart
• Saving presentations
• Saving as a presentation
• Saving as a slideshow
• Saving as a video
• Publish to web / SharePoint
• Save to other formats
• Printing Presentations
• Print Preview
• Printing Slides
• Printing Hand-outs
• Printing Notes Pages
• Printing Outline View

• Basics of computer
• Microsoft Word
• Microsoft Excel
• Microsoft Power Point
• Microsoft Access
• Microsoft Outlook
• Internet Concepts

ANAND  V.R - Consultant - Training 

• He is currently asscoiated with CPRO IT SERVICES PVT LTD as Technical Consultant
• He is a consultant and Training Solution architect.
• He has completed his M.Phil. on Mass Communication and performed various roles like Consultant, Training Solution on IT, Mass Communication and Documentation.
• As a Corporate trainer, he has conducted different Corporate Training Programs since 2009.
• Expert level knowledge in the following :
• Big Data: Hadoop 1x and 2x - (PIG, HIVE, Sqoop, flume etc.) and Cloudera 5x
• Oracle University Sub- Accreditation DATABASE and Business Tool Teaching in Private and University Programs
• Corporate Training on Media Tools, Documentation, Web Design, ITIL, Six sigma, Science Communication
• Other Technology: Microsoft-SQL, HTML, PHP, Web Blog Maker (Yahoo & Google)
• Virtual Technology (OVM, VMWARE), Core Documentation,

CPRO IT SERVICES PVT LTD - CERTIFICATION

• CPRO provides the Certification - Microsoft Office.
• Signed by our Director.
• This can be utilised for gaining Credit  points during your academic
• This certificate is provided those who passed the final assessment conducted by CPRO
• Minimum pass for the internal assessment conducted by CPRO is 75%.