Office automation notes

 Office automation notes (word, excel, powerpoint)

                         

                        Basic Com.

1. Introduction to MS Word

• - Overview of Microsoft Word and its purpose.

2. Opening Screen in MS Word

• - Description of the various components of the MS Word interface, including:
• - Title Bar 
• -File Tab
• - Quick Access Toolbar
• - Ribbon
• - Rulers
• - Help
• - Zoom Control
• - View Button
• - Document Area
• - Scroll Bar
• - Status Bar
• - Dialog Box Launcher

3. Paragraph Tab

• - Formatting options for paragraphs including:
• - Bullet and Numbered Lists
• - Multi-Level Lists
• - Indentation
• - Sorting
• - Paragraph Alignment
• - Line and Paragraph Spacing
• - Shading and Borders

4. Styles Tab

• - Utilizing styles for formatting text and paragraphs.

5. Editing in Word

• - Instructions for inserting, deleting, selecting, copying, and cutting text.

6. Headers and Footers

• - How to add and customize headers and footers in a document.

7. Mail Merge-

• - steps to complete mail merges for creating multiple documents.

8. Printing in MS Word

• - Instructions for printing documents and adjusting print settings.

9. Creating Index in MS Word 

• How to create an index for documents.

            MS WORD 

1. Introduction to MS-Excel

• Definition: MS-Excel is part of Microsoft Office suite used for organizing data through rows and columns (worksheets).
• Structure: 1,048,576 rows and 16,384 columns; cells defined by their address (e.g., A1).
• Basic Components:
• Microsoft Office Button: Access to basic file operations (New, Open, Save).
• Quick Access Toolbar: Provides quick access to frequently used commands.
• Title Bar: Displays the workbook name currently in use.
• Ribbon: Contains several tabs:
• Home Tab: Basic formatting operations.
• Insert Tab: Insert images, tables, charts, etc.
• Page Layout: Adjustments for print layout.
• Formulas Tab: Access to built-in functions.
• Data Tab: Data analysis tools.
• Review Tab: Text checking and sharing options.
• View Tab: Viewing options for worksheets.
• Key Elements:
• Cells: Where data/formulas are entered.
• Formula Bar: Displays cell content and address.
• Status Bar: Shows quick info (count, sum, average).
• Microsoft Excel Features
• Interface: User-friendly and advanced.
• Storage Space: Increased capacity.
• Sorting and Filtering: Organizes large datasets.
• Charts and Tables: Visual data representation.
• Low File Size: More efficient file management.
• Functions: Supports various mathematical/logical operations.
• File Conversion: Can convert to XML, PDF, etc.
• Advanced Formatting: Customize cell appearances based on content.
• Microsoft Excel Advantages
• Ease of Data Entry: Intuitive interface for operations.
• Accurate Analysis: Advanced tools for data sorting/filtering.
• Graphical Representation: Bar charts, pie charts, etc.
• Compatibility: Works with many business applications.
• Ready to Use Formulas: Efficient calculations.

2. Formatting Cells in Excel

• Formatting Steps:
• Select Cells: Highlight the desired cells.
• Open Format Cells: Adjust preferences (Number, Alignment, Font, etc.).
• Format Types:
• Number Formats: General, Currency, Date, Percentage, etc.
• Alignment Options: Horizontal/vertical alignment, text control.
• Font Customizations: Change font style, size, color.
• Borders and Fill: Customizable border styles and background colors.
• Protection: Lock cells or hide formulas.

3. Formatting Columns and Rows

• Column Width: Set specific or auto-fit widths.
• Row Height: Adjust to fit content.
• Merging Cells: Combine multiple cells into one.

4. Working with Formulas and Functions

• Formula: Expression starting with =; can contain up to 255 characters.
• Function: Predefined formulas in Excel; accepts arguments. Basic types include:
• String Functions: CHAR(), CONCATENATE(), LEN(), etc.
• Mathematical Functions: SUM(), AVERAGE(), COUNT(), etc.
• Logical Functions: IF(), AND(), OR().
• Date and Time Functions: DATE(), TIME(), NOW(), etc.

5. Goal Seek and Data Validation

• Goal Seek: Determine input value for desired output. Steps to access in the Data menu.
• Data Validation: Controls what data users can input, offers validation criteria like number ranges or lists.

6. Conditional Formatting

• Functionality: Change cell formats based on criteria.
• Steps to Apply: Select the cells, go to Conditional Formatting in the Home tab, choose the condition and format.

     MS EXCEL 

1. Opening Screen of MS PowerPoint

• Overview of PowerPoint
• Definition: Microsoft PowerPoint, part of Microsoft Office, is a tool for creating professional presentations using slides.
• Key Features: Supports text, charts, graphics, and multimedia.
• Main Interface Components
• File Tab: Access Backstage View for file management (create, save, open).
• Ribbon: Organized into tabs (e.g., Home, Insert) with groups of related commands.
• Title Bar: Displays file name and program name.
• Slide Area: Where slides are edited and created.
• Help Icon: Provides access to help topics.
• Zoom Options: Adjusts slide view (up to 400%).
• Slide Views:
• Normal Layout: Individual slide editing and thumbnail arrangement.
• Slide Sorter: Matrix view for slide arrangement, no editing.
• Reading View: Slideshow-like view with taskbar access.
• Notes Section: For presenter references—hidden from audience.
• Quick Access Toolbar: Customizable tool access for frequently used commands.
• Slide Tab: View and manage slides in Normal view.

2. Creating a New Presentation

• Process:
• Access File tab → Backstage view.
• Select New to choose between blank or template presentations.
• Review and create a presentation based on selected template.

3. Design of Templates and Blank Presentations

• Creating Custom Templates:
• Start with a blank presentation.
• Download a background image and apply in Slide Master view.
• Customize content and title areas for aesthetics.
• Save as .potx for future reuse. 

4. Slide Transitions

• Purpose: Visual effects when transitioning between slides.
• Steps:
• Select slide and access Transitions ribbon.
• Preview and apply desired transition effects.
• Use “Apply to All” to implement the same transition across slides.
• Categories:
• Subtle, Exciting, Dynamic Content.

5. Custom Animation Effects

• Functionality: Enhance presentations by animating text and objects.
• Steps:
• Use Animation ribbon to display the Animation Pane.
• Add and customize animations for each object.
• Types of animations: Entrance, Emphasis, Exit, Motion Paths.

6. Slide Show

• Running a Slideshow:
• Start from the beginning or current slide via the Slide Show tab.
• Use click or spacebar to advance; ESC to exit.
• Features: Custom slideshow options, rehearsal timing, and Presenter View.

7. Adding Multimedia

• Inserting Audio/Video:
• From the Insert ribbon, select Media group to add audio or video.
• Set playback options for audio (volume, start, etc.) and video (play full screen, loop, etc.)

     MS POWERPOINT 

---------------------END------------------------