www.computecindia.

in
B-117, Mohan Garden
(Pipal Wala road) Near pillar no.
753 Uttam Nagar

Office Executive Course Contents

Module 1: - Microsoft Word
I. Getting Started with Word VIII. Controlling Page Appearance
• Apply a Page Border and Color
• Navigate in Microsoft Word
• Add Headers and Footers
• Create and Save Word
Documents • Control Page Layout
• Manage Your Workspace • Add a Watermark
• Edit Documents • Set Page Orientation
(Portrait/Landscape)
• Preview and Print Documents
• Set Print Size of the Paper
II. Formatting Text and Paragraphs
• Split Text into Multiple Columns
• Apply Character Formatting
• Add Page Breaks
• Control Paragraph Layout
• Add Section Breaks
• Align Text Using Tabs
IX. Adding / Inserting Index
• Apply Borders and Shading
• Table of Content
III. Display Bullets
• Footnote, Endnote
• Symbol Bullet
• Insert Caption
• Numbering Bullet
• Insert Citation
• Picture Bullet
• Bibliography
• Multilevel List
• Cross Reference
IV. Working More Efficiently
X. Advanced Mail Merge
• Make Repetitive Edits
• Beginning a Mail Merge
• Apply Repetitive Formatting
• Mail Merge Data
• Use Styles to Streamline
• Previewing Merge Letters
Repetitive Formatting Tasks
• Selective Merge Records
V. Managing Lists
• Filtering
• Sort a List
• Mail Merge to Email
• Format a List
XI. Preparing to Publish a Document
VI. Adding Tables
• Check Spelling, Grammar, and
• Insert a Table
Readability
• Modify a Table
• Use Research Tools
• Format a Table
• Check Accessibility
• Convert Text to a Table
• Save a Document to Other
VII. Inserting Graphic Objects Formats
• Insert Symbols and Special XII. Views
Characters • Reading Mode
• Add Images to a Document • Print Layout
• Smart Art • Outline
• Shapes • Draft
• Pictures • Page Width
• Charts • Multiple Pages
 XIII. The Macro Recorder • Working with Datasheets
• Recording Macros • Applying a Chart Type, Style and
• Testing Macros Layout
• Running Macros • Displaying Chart Analysis
• Picture Charts
MODULE 2: - Microsoft PowerPoint • Formatting Chart Background
VI. Templates, Themes & Layouts
I. Creating Presentation • Creating a Custom Layout
• Blank & Sample Templates • Applying a Theme
• Adding Text Boxes • Applying a Background Style
• Edit, Copy, Cut & Move Text • Saving a Custom Theme
• Format Text Boxes • Arranging and Printing Section
• Add Slides & Change Layouts VII. Custom Design Templates
• Import or Reuse Slides • Slide Master
• Arranging Slides • Background Graphics
• Themes & Backgrounds • Custom Slide Layouts
• Slide Navigation • Advanced Custom Themes
• Presentation Views • Add Headers & Footers
• Formatting Text • Modify Notes Master
• Formatting Text • Edit Handout Master
• Formatting Paragraphs • Create Custom Template
• Bullet & Numbered Lists VIII. Editing Slide Masters
II. Adding Graphics • Slide Master, Title Master
• Capture Images & Insert Pictures • Formatting the Masters
• Photo Album • Adding Header and Footer
• Drawing Shapes Information
• Advanced Shapes • Notes and Handout Masters
• Merge Shapes IX. Animations and Transitions
• WordArt • Animation Schemes
• SmartArt Graphics • Animating Text and Objects
III. Modify Objects • Custom Animations and timing
• Crop, Resize & Style Objects • Inserting Sounds and Video
• Formatting Objects • Editing Media Clips
• Grouping Objects
• Object Ordering & Layering
• Gridlines & Guides
IV. Tables
• Insert & Formatting Tables
• Insert Table from Word
• Manipulating PowerPoint Tables
• Inserting a Word Table
• Inserting an Excel Spreadsheet
• Adjusting Rows, Columns, Cells
• Table Styles and Borders
V. Create & Modify Charts
• Inserting a Chart
MODULE 3: - Professional Excel VI. Apply Custom Data Formats and
Validation
I. Create Worksheets and Workbooks
• Create custom number formats
• Create a workbook • Populate cells by using advanced
• Import data from a delimited text Fill Series options
file • Configure data validation
• Add a worksheet to an existing
VII. Apply Advanced Conditional
workbook
Formatting and Filtering
• Copy and move a worksheet
• Create custom conditional
II. Navigate in Worksheets and
formatting rules
Workbooks • Create conditional formatting
• Search for data within a rules that use formulas
workbook • Manage conditional formatting
• Navigate to a named cell, range, rules
or workbook element
VIII. Create and Modify Custom
• Insert and remove hyperlinks
Workbook Elements
III. Format Worksheets and Workbooks
• Create and modify simple macros
• Change worksheet tab color
• Insert and configure form
• Rename a worksheet controls
• Change worksheet order
IX. Create and Manage Tables
• Insert and delete columns or
• Create an Excel table from a cell
rows
range
• Change workbook themes
• Convert a table to a cell range
• Adjust row height and column
• Add or remove table rows and
width
columns
• Insert headers and footers
X. Manage Table Styles and Options
IV. Customize Options and Views for
• Apply styles to tables
Worksheets and Workbooks • Configure table style options
• Hide or unhide worksheets • Insert total rows
• Hide or unhide columns and rows
XI. Filter and Sort a Table
• Customize the Quick Access
• Filter records
toolbar
• Sort data by multiple columns
• Modify document properties
• Change sort order
• Display formulas
• Remove duplicate records
V. Configure Worksheets and
XII. Summarize Data by using Functions
Workbooks for Distribution
• Insert references
• Inspect a workbook for hidden
• Perform calculations by using the
properties or personal
SUM function
information
• Perform calculations by using
• Inspect a workbook for
MIN and MAX functions
accessibility issues
• Perform calculations by using the
• Inspect a workbook for
COUNT function
compatibility issues
• Perform calculations by using the
AVERAGE function
• Perform Conditional Operations
by using Functions
 • Perform logical operations by • Perform by using Minimum
using the IF function function
• Perform logical operations by • Perform by using Mode function
using the SUMIF function • Perform by using Median
• Perform logical operations by function
using the AVERAGEIF function • Perform by using Log function
• Perform statistical operations by • Perform by using Dollar function
using the COUNTIF function • Perform by using Average
XIII. Format and Modify Text by using function
Functions • Perform by using Mina function
• Format text by using RIGHT, LEFT, • Perform by using Maxa function
and MID functions • Perform by using large function
• Format text by using UPPER, • Perform by using Sqrt function
LOWER, and PROPER functions • Perform by using Mod function
• Format text by using the • Perform by using Roman function
CONCATENATE function • Perform by using Rank function
• Format text by using the Exact • Perform by using Rank Average
function function
• Format text by using the Len • Perform by using Rand function
function • Perform by using Rand Between
• Format text by using the Trim function
function XV. Date & Time Function’s
• Format text by using the
• Perform by using Days360
Substitute function
function
• Format text by using the Search
• Perform by using Date function
function
• Perform by using Network days
• Format text by using the Find
function
function
• Perform by using Now function
XIV. Mathematical & Statical Function’s
• Perform by using Today function
• Perform by using Sum function
• Perform by using Weekday
• Perform by using Product
function
function
• Perform by using Effect function
• Perform by using Average
• Perform by using Eomonth
function
function
• Perform by using Ceiling function
• Perform by using Edate function
• Perform by using Floor function
• Perform by using Workdays
• Perform by using round function
function
• Perform by using Round Up
• Perform by using Datedif function
function
XVI. Lookup &Reference
• Perform by using Round Down
Function’s
function
• Perform by using Power function • Index function
• Perform by using Count function • Match function
• Perform by using Counta function • Lookup function
• Perform by using Maximum • Choose function
function • Offset function
• Offset with Match function
 • Lookup function XIX. What –If Data Analysis
• Transpose function • Using Goal Seek
• Hlookup For Single Worksheet • Using Data Table
• Vlookup For Single Worksheet • Creating & Displaying Scenarios
• Hlookup & Vlookup for Multiple XX. Customizing Macro By Action
Sheet Button
• Match And Find Record by
• Creating a Macro with Condition
Vlookup and Hlookup
• Running a Macro, Editing a Macro
• Approximate Match with Vlookup
• Adding a menu to the Menu Bar
• Exact Match with Vlookup
• Adding a Commands to a Menu
• Nesting Lookup Function
• Adding Buttons to a Toolbar
• Show Formula
• Choose Function with Vlookup XXI. Working with Pivot Table &
• Index with Match function Pivot Chart
• Vlookup with Trim function • Creating a Pivot Table
• Indirect function • Rearranging a Pivot Table
XVII. Financial Function’s • Filtering Pivot Table Data
• Pmt Function • Creating a Pivot Chart
• Rate Function XXII. Reporting With Payroll
• Ppmt Function Statement
• Ipmt Function • MIS Report
• Fv Function • Profit & Loss a/c statement
• Pv Function • Balance sheet
• Coupdays Function • Worker contribution statement
• Coupnum Function • Cash flow statement
• Ispmt Function • Debtor’s & Creditors statement
• Inventory statement
• Sln Function • BRS Statement
• Cumprinc Function • Fixed Assets & fund statement
• Cumipmt Function • Payroll Report
• Ddb Function • P.F & E.S.I Report
• Db Function
• Received Function
XXIII. Create Different Charts
XVIII. Database Function’s
• Create a new chart
• Daverage Function
• Add additional data series
• Dproduct Function
• Switch between rows and columns in
• Dmin Function
source data
• Dmax Function
• Analyse data by using Quick Analysis
• Dcount Function
• Format Charts
• Dcounta Function
• Resize charts
• Dsum Function
• Add and modify chart elements
• Dget Function
• Apply chart layouts and styles
• Move charts to a chart sheet
XXIV. Protecting Excel Workbook &
Sheet
• Locking/Unlocking Cells in a
worksheet
• Protecting a Worksheet
• Protecting a Workbook
• Creating a Shared Workbook
• Tracking Changes to a Workbook
• Accepting & Rejecting Changes to a
Workbook
• Password Protecting a Workbook
• Merging Workbooks

9000/-
Duration : 2.5 Months Duration : 5 Weeks Duration : 3 Weeks
Class Timing : 1 Hrs. Daily Class Timing : 2 Hrs. Daily Class Timing : 3 Hrs. Daily
Days : Tue. - Sat Days : Tue. - Sat Days : Tue. - Sat