MS WORD
1. Introduction to Microsoft word
- Overview of the interface: Ribbon, Tabs, Group, and commands
- Creating, saving and Opening Documents.
- Understanding file types and Compatibility (docx., pdf.)
2. Basic Document Creation
- Typing and editing text.
- Using the undo and redo functions.
- Selecting, copying, and pasting content.
- Basic text formatting: fonts, sizes, colors, and alignment.
3. Advanced Text Formatting
- Applying styles and themes.
- Using bullet points and numbered lists.
- Line spacing, indentation, and paragraph formatting.
- Working with tabs and rulers.
4. Page Layout and Design
- Setting margins and page orientation.
- Adding headers, footers, and page numbers.
- Customizing page backgrounds and borders.
5. Working with Tables and Images
- Creating and formatting tables.
- Inserting images, SmartArt, and charts.
- Using text boxes and WordArt.
6. Document Proofreading and Review
- Checking spelling and grammar.
- Adding comments and using track changes.
- Comparing and merging documents.
7. Advanced Features
- Using Mail Merge (e.g., creating labels and letters).
- Customizing templates and styles.
- Creating and protecting forms.
8. Document Sharing and Printing
- Saving documents as PDFs.
- Using print preview and printing options.
- Sharing documents and password protection.
- Study Duration and Assessment
Duration: 4 to 6 weeks.
Assessment: Project-based assignments and practical examinations.
MS EXCEL
1. Introduction to Microsoft Excel
- Overview of the interface: Ribbon, Tabs, Groups, and
Commands. - Workbook and worksheet basics.
- Creating, saving, and opening workbooks.
- Understanding file types (.xlsx, .xls, .csv, .pdf).
2. Basic Spreadsheet Operations
- Entering and editing data.
- Selecting, copying, and pasting data.
- Using undo, redo, and find/replace tools.
- Adjusting row height, column width, and cell alignment.
3. Formatting in Excel
- Formatting cells: fonts, colors, and borders.
- Number formats: currency, percentage, dates, and custom formats.
- Applying and modifying styles and themes.
- Using conditional formatting for data visualization.
4. Working with Formulas and Functions
- Understanding basic formulas (addition, subtraction, multiplication, division).
- Introduction to functions: SUM, AVERAGE, MIN, MAX.
- Logical functions: IF, AND, OR.
- Text functions: CONCATENATE, LEFT, RIGHT, TRIM.
- Date functions: TODAY, NOW, DATE, YEAR, MONTH.
5. Data Management
- Sorting and filtering data.
- Working with tables and structured references.
- Removing duplicates and handling blank cells.
- Splitting and merging data using Text to Columns.
6. Data Analysis Tools
- Introduction to PivotTables and PivotCharts.
- Using slicers and timelines in PivotTables.
- Data validation and drop-down lists.
- Goal Seek, Scenario Manager, and What-If Analysis.
7. Charts and Visualization
- Creating and formatting charts (bar, column, pie, line).
- Customizing chart elements: titles, legends, and axes.
- Using sparklines for mini visualizations.
- Adding and customizing data labels and trendlines.
8. Advanced Excel Features
- Using named ranges for calculations.
- Introduction to VLOOKUP, HLOOKUP, and XLOOKUP.
- Working with INDEX and MATCH for advanced lookups.
- Understanding and applying macros.
- Protecting worksheets and workbooks with passwords.
9. Data Import and Export
- Importing data from text files, CSV, and databases.
- Exporting workbooks as PDFs or CSV files.
- Linking and embedding data between Excel and other applications.
10. Collaboration and Printing
- Sharing workbooks and using co-authoring.
- Tracking changes and comments.
- Print setup: setting print area, scaling, and page layout options.
- Study Duration and Assessment
Duration: 4 to 6 weeks.
Assessment: Practical projects, quizzes, and case studies.
MS POWERPOINT
1. Introduction to Microsoft PowerPoint
- Overview of the interface: Ribbon, Tabs, Groups, and Commands.
- Creating, saving, and opening presentations.
- Understanding file types (.pptx, .ppt, .pdf).
- Navigating between slides and views (Normal, Slide Sorter, Reading, and
Presenter views).
2. Basics of Slide Creation
- Adding, duplicating, and deleting slides.
- Using slide layouts and placeholders.
- Typing and formatting text.
- Adjusting alignment, indentation, and spacing.
3. Formatting Slides
- Applying themes and variants.
- Using slide backgrounds: colors, gradients, patterns, and images.
- Working with the Slide Master to create consistent layouts.
- Customizing fonts, colors, and effects.
4. Working with Multimedia
- Inserting images, audio, and video.
- Editing and formatting multimedia elements.
- Using SmartArt for diagrams and visual representations.
- Adding charts and tables from Excel.
5. Animations and Transitions
- Applying transitions between slides.
- Using animation effects for text, images, and objects.
- Customizing animation timing and sequences.
- Creating motion paths for advanced animations.
6. Designing and Customizing Presentations
- Working with shapes, icons, and WordArt.
- Grouping, aligning, and layering objects.
- Creating hyperlinks and action buttons.
- Adding headers, footers, and slide numbers.
7. Collaboration and Review Tools
- Sharing presentations for collaboration.
- Adding and managing comments.
- Using version history to track changes.
- Co-authoring presentations in real time.
8. Preparing for Presentations
- Setting up slide timings and rehearsing with Presenter view.
- Creating custom slide shows for different audiences.
- Exporting presentations as PDFs, videos, or images.
- Printing handouts and speaker notes.
9. Advanced Features
- Designing infographics and custom templates.
- Using add-ins and PowerPoint integrations.
- Embedding live links and interactive elements.
- Understanding accessibility features for presentations.
- Study Duration and Assessment
Duration: 4 to 6 weeks.
Assessment: Practical projects, quizzes, and final presentations.
