2nd Semester | Office Automation
Word 2013
- Introduction
- Why Word Processor
- Word Processing Terminologies
- Starting
- Interface
- Ribbon & Quick Access Toolbar
- Writing & Editing of Text
- Selection
- Shortcuts
- Find Replace & Go To
- Cover Pages
- Tables
- Copy & Paste Formatting
- Bullet & Numbering
- Multilevel List
- Alignment & Text Borders
- Line Spacing
- Equations & Symbols
- Change Case Feature
- Text Effect and Typography
- Text Styles
- Illustration-Pictures and Shapes
- SmartArt Graphics
- Charts
- Screenshots
- Hyperlink & Bookmark
- Header & Footer
- Page Numbering
- Comments
- WordArt
- Signature Line & Date and Time
- Format Document with Watermark
- Page Size/Margin/Orientation/Color/Border/Shading
- Text with Multiple Columns
- Line Number & Hyphenating Document
- Indent & Spacing
- Arrange any Object
- Table of contents
- Footnotes & Endnotes
- Caption
- Mail Merge
- Spelling & Grammar Check
- Word count
- Track Changes
- Macro
- Document Protection with Password
- Document Printing & Exports
Excel 2013
- Introduction to Spreadsheet
- Basic Spreadsheet Concepts
- Features
- Advantages & Disadvantages of Spreadsheet
- Terminologies used in Excel
- Starting
- Interface
- Ribbon & Quick Access Toolbar
- Workbook & Worksheet
- Rows Columns & Cells
- Cell References
- Shortcuts
- Formula & Functions
- Automation Feature
- Auto Calculate
- Types of Data Entered in a Cell
- Entering Data Items in Worksheet
- Moving & Coping Data
- Deleting and Inserting Cells Rows & Columns
- Formatting Rows and Columns
- Adding Colors/Pattern and Borders
- Working with Formulas
- Date/Day/Month/Year/Today/Now/Days/Dyas360
- Addition/Minimum/Maximum/Integer
- Absolute/Square Root/Round
- Count/Counta/Countblank/Countif/Countifs etc.
- Text Function- Left/Right/Lower/Upper/Mid/Concatenate etc.
- Logical Function- If/And/Or/Not/True/False/Sumif/iferror etc.
- Financial Function- PMT/IPMT/PPMT/FV/PV/NPER/RATE etc.
- Reporting Features- Lookup/Vlookup/Hlookup etc.
- What-if-Analysis: Goal Seek/Scenario etc.
- Pivot Table & Pivot Chart
- Printing& Export
PowerPoint 2013
- Introduction
- Starting
- Interface
- Ribbon & Quick Access Toolbar
- Elements of PowerPoint
- Presentations
- Slides & Slides Layouts
- Slide Theme
- Slide Transitions
- Custom Animations
- Steps to create a Presentation
- Adding Slide Themes
- Adding Slide Transitions
- Adding Animation
- Adding Audio & Video
- Adding Charts & shapes
- Adding Tables
- Adding SmartArts
- Adding WordArt
- Adding Background
- Rehearsal Timing
- Customs Shows
- Slide Show
- Setup Show
- Presentation Views
- Printing & Export