• Home
  • Course
  • Computer fundamental
  • Microsoft Office Course

Microsoft Office Course

  • Fermentum iaculis eu non diam phasellus vestibulum. Porta non pulvinar neque laoreet suspendisse. Justo nec ultrices dui sapien proin sed libero
  • At consectetur lorem donec massa sapien. Pulvinar sapien et ligula ullamcorper malesuada proin
  • 3.5 (3k reviews)
₹ 4999
Get Course Get Course
  • Level Beginner
  • Duration 2 Month

Course Content

Course Content

  1. Overview of MS Word
    1. Understanding the MS Word interface (Ribbon, Quick Access Toolbar)
    2. Navigating the workspace (Document area, Ruler, Status bar)
  2. Basic Functions
    1. Creating, opening, saving, and closing documents
    2. File formats (DOCX, DOC, PDF, etc.)
    3. Understanding the Save As feature and file management
  3. Text Basics
    1. Typing, selecting, and editing text
    2. Undo and redo actions
    3. Using the Clipboard (Copy, Cut, Paste, Format Painter)
  4. Font and Text Formatting
    1. Modifying font (type, size, color, bold, italics, underline)
    2. Applying text effects (strikethrough, subscript, superscript)
    3. Changing text alignment (left, center, right, justify)
    4. Line spacing and paragraph formatting (indents, spacing before and after)
  5. Lists and Bullet Points
    1. Creating and formatting bulleted and numbered lists
    2. Customizing bullets and numbering styles
  6. Themes and Templates
    1. Applying and changing document themes
    2. Understanding the difference between themes and templates
    3. Creating and using custom templates
  7. Images and Graphics
    1. Inserting pictures, shapes, and clip art
    2. Text wrapping options for images
    3. Resizing, cropping, and aligning images and objects
  8. Tables and Charts
    1. Inserting and formatting tables
    2. Sorting data in tables
    3. Inserting charts and graphs to present data
  9. SmartArt and Drawing Tools
    1. Creating and formatting SmartArt graphics
    2. Using drawing tools for custom illustrations
  10. Page Setup
    1. Adjusting margins, orientation, and page size
    2. Inserting and formatting page numbers, headers, and footers
    3. Working with section breaks (for different headers/footers and page numbers)
  11. Text Flow and Columns
    1. Inserting and formatting columns
    2. Using breaks (page, section, column) to control text flow
  12. Watermarks and Backgrounds
    1. Inserting and formatting watermarks (text or image)
    2. Adding background colors or images to a page
  13. Table of Contents
    1. Creating and updating a Table of Contents
    2. Using Heading Styles for automatic TOC generation
    3. Footnotes, Endnotes, and Citations
    4. Inserting and formatting footnotes and endnotes
    5. Adding citations and creating a bibliography (APA, MLA, Chicago styl
  14. Bookmark, Hyperlink & cross-References
    1. Inserting Bookmark
    2. Inserting cross-references to figures, tables, and sections
    3. Inserting Hyperlink
  15. Track Changes and Comments
    1. Using Track Changes for collaborative work
    2. Inserting, viewing, and deleting comments
    3. Accepting or rejecting changes in the document
  16. Mail Merge
    1. Introduction to Mail Merge (letters, envelopes, labels)
    2. Setting up a data source (Excel, Access)
    3. Merging documents with data for customized communication
  17. Macros
    1. Introduction to macros and how they can automate repetitive tasks
    2. Recording and running macros
    3. Managing and editing macros in Word 2016
  18. Proofing and Editing Tools
    1. Using the Spelling & Grammar checker
    2. Using the Thesaurus and Find & Replace
    3. Reviewing documents using the Read Aloud feature
    4. Password protecting documents and restricting editing permissions
  19. Document Views
    1. Switching between different views (Print Layout, Web Layout, Draft)
    2. Using the Navigation Pane for easy document navigation
    3. Managing bookmarks and hyperlinks
  20. Exporting Documents
    1. Saving documents as PDF or other formats
    2. Exporting Word documents to HTML or plain text
    3. Sharing documents via OneDrive and collaboration features

 

MS OFFICE: EXCEL

  1. Overview of Excel
    1. Introduction to Excel Interface (Ribbon, Quick Access Toolbar, Formula Bar, and Status Bar)
    2. Understanding Workbooks, Worksheets, and Cells
    3. Navigating a Worksheet (Scroll Bars, Mouse Actions, Keyboard Shortcuts)
    4. Creating, Saving, and Opening Workbooks
    5. Basic File Management (Save, Save As, Export to PDF)
    6. Understanding Excel File Formats (XLSX, CSV, XLS)
  2. Data Entry and Basic Formatting
    1. Entering and editing data in cells
    2. Formatting text (font style, size, color, bold, italics, underline)
    3. Number formatting (currency, percentage, dates, time)
    4. Adjusting column width and row height
    5. Merging and centering text
  3. Basic Formulas
    1. Introduction to formulas and functions
    2. Basic arithmetic operations (addition, subtraction, multiplication, division)
    3. Using SUM, AVERAGE, MIN, MAX, COUNT functions
    4. AutoSum and AutoFill features
    5. Relative and absolute references in formulas
  4. Data Editing and Management
    1. Inserting, deleting, and moving cells, rows, and columns
    2. Copy, Cut, Paste (including Paste Special)
    3. Using Find and Replace
    4. Using Undo and Redo
  5. Sorting and Filtering Data
    1. Sorting data by one or more columns (ascending, descending, custom sorting)
    2. Applying filters to data (AutoFilter, Text Filters, Number Filters)
    3. Using Advanced Filters for complex criteria
  6. Data Validation
    1. Setting up data validation rules (drop-down lists, range restrictions)
    2. Error messages and input messages
    3. Using the Data Validation tool to restrict data entry
  7. Conditional Formatting
    1. Introduction to Conditional Formatting (highlighting cells based on values)
    2. Using built-in conditional formatting rules (color scales, data bars, icon sets)
    3. Creating custom rules and formulas for conditional formatting
  8. Cell Styles and Themes
    1. Applying and modifying cell styles
    2. Using themes and customizing workbook design
  9. Number Formatting
    1. Custom number formats (dates, currency, percentages, etc.)
    2. Using Format Painter to apply formatting
  10. Creating and Formatting Tables
    1. Converting ranges to tables
    2. Table styles and formatting options
    3. Using structured references in formulas
  11. Sorting and Filtering within Tables
    1. Sorting and filtering data within tables
    2. Using slicers to filter table data visually
  12. Using Named Ranges
    1. Defining and managing named ranges
    2. Using named ranges in formulas for clarity and efficiency
  13. Text Functions
    1. CONCATENATE, LEFT, RIGHT, MID, FIND, LEN
    2. UPPER, LOWER, PROPER
    3. TEXT function for formatting numbers and dates as text
  14. Logical Functions
    1. IF function and nested IF statements
    2. Using AND, OR, NOT with IF for complex conditions
    3. SWITCH function for multiple conditions
  15. Date and Time Functions
    1. TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY
    2. DATEDIF, NETWORKDAYS, WORKDAY functions
  16. Charts and Graphs
    1. Introduction to chart types (column, line, pie, bar, scatter, etc.)
    2. Creating, modifying, and formatting charts
    3. Using chart tools for layout and design
    4. Adding and formatting chart titles, axis labels, and legends
    5. Changing chart types and switching rows/columns
  17. Creating PivotTables & Charts
    1. Introduction to PivotTables and their purpose
    2. Creating and arranging PivotTables
  18. Excel Workbooks security
    1. Tracking changes and reviewing comments
    2. Protecting worksheets and workbooks with passwords
    3. Restricting editing and permissions
    4. Adding encryption and password protection to workbooks
    5. Locking and unlocking cells for protection

 

MS OFFICE: POWERPOINT

  1. Overview of PowerPoint
    1. Introduction to the PowerPoint Interface (Ribbon, Quick Access Toolbar, Slide Pane, Notes Pane, and Status Bar)
    2. Understanding the difference between a slide and a presentation
    3. Working with slides: navigating, selecting, and organizing slides
  2. Creating and Saving Presentations
    1. Creating a new presentation
    2. Choosing and modifying presentation themes
    3. Saving presentations in different formats (.pptx, .pdf, .ppt, etc.)
    4. Saving and sharing presentations via OneDrive or other platforms
    5. Using templates and blank presentations
  3. Adding and Editing Text
    1. Inserting text boxes and adding text to slides
    2. Formatting text (font, size, color, bold, italics, underline, and highlighting)
    3. Using text alignment (left, center, right, justified)
    4. Bullet points and numbered lists
    5. Customizing text style with themes and effects
  4. Working with Shapes and Objects
    1. Inserting and resizing shapes (rectangles, circles, arrows, etc.)
    2. Modifying shapes (fill color, outline, effects)
    3. Grouping and ungrouping shapes
    4. Using the Format Painter to apply consistent formatting
  5. Inserting and Formatting Images
    1. Inserting pictures from files and online sources
    2. Using crop and resize tools for images
    3. Applying picture styles and effects (shadows, reflections, borders)
    4. Adjusting image brightness, contrast, and color
  6. Working with Charts
    1. Inserting and editing charts (column, line, pie, etc.)
    2. Customizing chart data and formatting
    3. Formatting chart elements (titles, labels, legends)
  7. Inserting and Formatting Tables
    1. Creating tables with various styles
    2. Modifying table cells (size, color, borders)
    3. Sorting and formatting data in tables
  8. Adding and Organizing Slides
    1. Inserting new slides and selecting slide layouts
    2. Moving, deleting, and duplicating slides
    3. Rearranging slide order
  9. Slide Layouts and Design
    1. Using built-in slide layouts for different content types
    2. Customizing slide layouts (title, text, image, content)
    3. Using Master Slides to apply consistent layouts and styles
  10. Slide Design and Themes
    1. Applying and customizing slide themes
    2. Modifying slide background colors and images
    3. Using gradients, textures, and patterns as backgrounds
  11. Slide Transitions
    1. Applying slide transitions between slides
    2. Customizing transition speed and timing
    3. Using transition effects (Fade, Push, Wipe, etc.)
  12. Slide Master
    1. Introduction to the Slide Master
    2. Modifying layouts in the Slide Master for consistent formatting
    3. Inserting logos, footers, and other elements that appear on every slide
  13. Slide Animations
    1. Applying animations to slide elements (text, shapes, images)
    2. Modifying animation types (entrance, emphasis, exit, motion paths)
    3. Customizing animation timing and sequence
    4. Using the Animation Pane for advanced animation control
  14. Inserting Audio and Video
    1. Inserting audio files (from computer or online)
    2. Adding video files to slides and adjusting playback settings
    3. Trimming and formatting media (audio and video)
    4. Using video and audio as part of a slide show presentation
  15. Hyperlinks and Action Buttons
    1. Creating hyperlinks to slides, external websites, or email addresses
    2. Adding action buttons for navigation within the presentation
    3. Setting up automatic slide navigation and interactivity
  16. Protecting and Securing Presentations
    1. Password protecting a presentation
    2. Restricting editing permissions and reviewing document properties
    3. Using the "Mark as Final" feature for securing presentations
  17. Presenter Tools
    1. Using Presenter View for better control during a live presentation
    2. Managing slides and notes with Presenter View
    3. Using the laser pointer and pen tool during presentations
  18. Rehearsing and Timing
    1. Rehearsing slide timings for automated slide transitions
    2. Recording a slide show with narration and timings
  19. Preparing for Printing
    1. Printing handouts, speaker notes, and slides
    2. Customizing print layouts and orientations
    3. Creating a PDF version of your presentation
  20. Delivering the Presentation
    1. Tips for effective presentation delivery
    2. Using notes and slides for presentation guidance
    3. Interacting with the audience during the presentation

 

MS OFFICE: ACCESS

  1. Introduction to Microsoft Access
    1. What is Microsoft Access?
    2. Overview of database concepts
    3. Introduction to Database Management Systems (DBMS)
  2. Access Interface Overview
    1. Understanding the Ribbon, Navigation Pane, and Quick Access Toolbar
    2. Introduction to Access Views (Design View, Datasheet View, etc.)
  3. Creating a New Database
    1. Creating a blank database
    2. Saving and naming a database
    3. Understanding file formats in Access
  4. Creating Tables
    1. Structure of a table (fields and records)
    2. Primary Keys and Field Types (Text, Number, Date/Time, etc.)
    3. Using the Table Design View
    4. Setting up Field Properties (Field Size, Default Value, etc.)
    5. Using the Datasheet View for quick data entry
  5. Editing Tables
    1. Adding, editing, and deleting fields and records
    2. Sorting and filtering data in Datasheet View
  6. Relationships and Referential Integrity
    1. Creating relationships between tables
    2. Setting Referential Integrity rules
    3. One-to-One, One-to-Many, and Many-to-Many relationships
  7. Entering Data in Tables
    1. Using Datasheet View for manual data entry
    2. Importing data from Excel or other sources
    3. Updating and deleting records
  8. Data Validation and Error Handling
    1. Using Input Masks and Validation Rules
    2. Setting up Default Values for fields
  9. Introduction to Queries
    1. What is a query and how is it used?
    2. Types of Queries: Select, Action, Parameter, and Aggregate Queries
  10. Creating Simple Queries
    1. Using Query Design View
    2. Selecting fields to display
    3. Sorting and filtering query results
  11. Using Aggregate Functions
    1. Summing, averaging, counting records
    2. Grouping data and creating calculated fields
  12. What is a Form?
    1. Purpose of Forms in database applications
    2. Types of Forms (Single Form, Datasheet, Split Form)
  13. Creating Forms
    1. Using the Form Wizard to create simple forms
    2. Customizing forms using Layout View and Design View
    3. Adding controls (Text boxes, Combo boxes, etc.)
  14. Editing Form Properties
    1. Changing form design and layout
    2. Setting properties for form controls (e.g., Auto Tab, Input Mask)
  15. What is a Report?
    1. Purpose of Reports in Access
    2. Types of Reports (Single, Multiple Pages)
  16. Creating Reports
    1. Using the Report Wizard
    2. Customizing reports (Grouping, Sorting, and Adding Calculations)
  17. Formatting Reports
    1. Adding headers, footers, and logos
    2. Adjusting page layout and margins
    3. Using conditional formatting
  18. Importing and Exporting Data
    1. Importing data from Excel, CSV, and other formats
    2. Exporting data to Excel and other formats