Microsoft Office is an office suite of applications, servers and services developed by Microsoft. Each program serves a different purpose and is compatible with other programs included in the package. It is used for special purpose office work such as documentation, worksheet, presentation and database. Microsoft has developed multiple versions of Office that can be supported by different operating systems, including Windows, Linux, and macOS. The most common Office applications are Word, Excel, PowerPoint, and Outlook.
The course offers the following applications
- To make students understand the components of office automation
- To enable students to perform operations using MS Word, Excel, PowerPoint
Word Processing Package: MS-Word 2013- Introduction-Features- Word User Interface Elements-Creating New Documents- Basic Editing- Saving a Document- Printing a Document- Print Preview-Page Orientation- Viewing Documents- Setting Tabs-Page Margins- Indents- Ruler- Formatting Techniques- Font Formatting- Paragraph Formatting- Page Setup- Headers &Footers-Bullets and Numbered List-
Borders and Shading- Find and Replace-Page Break Page Numbers-Mail Merging-Spelling and Grammar- Checking- Thesaurus- Macros- Tables- Side-By-Side and Nested Tables- Formatting Tables- Drawing- Word art- Paint Brush Document Templates – Email Editor.
Desktop Publishing- PageMaker 7.0 – Introduction to Desktop Publishing as a Process- PageMaker Tools and Palettes- Working With Objects -Type Styling Options – Working With Text – Formatting Options-Leading, Margins and Indents – Scaling Text-Paragraph Formatting Options -Working With Grids – Creating Frames – Layers.
Spreadsheet Package: MS -Excel 2013-Introduction-Excel User Interface- Working With Cell and Cell Addresses- Selecting a Range, Moving, Cutting, Copying With Paste-Inserting and Deleting Cells- Freezing Cells- Adding, Deleting and Copying Worksheet Within a Workbook- Renaming a Worksheet-Cell Formatting Options- Formatting Fonts- Aligning-Wrapping and Rotating Text- Using Borders- Boxes and Colors- Centering a Heading, Changing Row/Column Height / Width-Formatting a Worksheet Automatically- Insert Comments- Clear Contents in a Cell- Using Print Preview- Preparing Worksheet for the Printer- Selecting Print Area-Margin and Orientation- Centering a Worksheet- Using Header and Footer- Inserting Page Breaks- Sorting Data.
Advanced Features of Excel: All Functions in Excel- Using Logical Functions-Statistical Functions-Mathematical Functions – Linking Data between Worksheet- Elements of Excel Charts-Categories- Create a Chart- Choosing Chart Type- Edit Chart Axis – Titles, Labels, Data Series and Legend- Adding a Text Box- Rotate Text in a Chart- Converting a Chart on a Web Page- Saving a Chart- Designing of Templates in Excel.
Presentation Package: Ms-Power Point 2013-Advantages of Presentation- Screen Layout- Creating Presentation- Inserting Slides-Adding Sounds and Videos-Formatting Slides -Slide Layout Views in Presentation – Colour Scheme- Background Action Buttons- Slide Transition- Custom Animation- Creating Master Slides- Managing Slide Shows – Using Pen Setting Slide Intervals.