Microsoft Office (Word, Powerpoint, Excel)

This program is designed to give you practical knowledge and understanding of Microsoft Office applications. You will gain the skills required to stand out in today's competitive marketing by maximizing the innovative features and functions of MS Office.

Topics:

1. Microsoft Word:

- Understanding Menus
- Format Font Dialog Box, Page Formatting, Paragraphs & Line Spacing, Find & Replace, Spelling & Grammar, Thesaurus and Autocorrect
- Page Setup, Typing, Selecting and Editing text, Tab Key
- Bullets & Numbering, Modifying and Setting Indents.
- Footnote, Endnote, Header, Footer and Symbols
- Inserting Text Box, Positioning, Formatting, Header and Footers and Page Number
- Columns, Changing the width of the column, Column Break and Drop Cap
- Tables, Merge cells, Calculation using Functions
- Table, Table Layout, Add Columns and Rows, Removing Gridlines, Borders
- Working with templates
- Inserting Shapes, Word Art, Lines, Arrows, Shadow, Shading, Flow chart Shapes
- Mail merging

2. Microsoft Excel:

- Introduction to Excel, Understanding Menus
- Relative and Absolute Reference
- Building Worksheet, Entering Data, Editing, Inserting and Deleting Rows and Columns, Increasing and Decreasing Row Height and Column Width, Auto Fill and Auto Sum
- Function Wizard- Average, Min, Max and Formatting cells
- IF condition, Count IF, Nested IF condition
- Paste special As- Values and Transpose
- Creating embedded charts using Chart Wizard and Layout
- Consolidation, PMT, Goal Seek
- Copying Ranges between Worksheets, Freeze Panes
- What If Data Table, One Input and Two Input

3. Microsoft PowerPoint:

- Creating Title and Bulleted List Style
- Working with Objects and Changing the Layout or Template
- Using Slide View, Outline View, Slide Master
- Working with Objects, Changing Design and Slide Sorting
- Inserting Graph, Table and Smart Art Graphics
- Selecting, Aligning and Changing the Appearance of Text
- Custom Animation, Pointer Options and PowerPoint Show
- Transition Effects