Academy of Data Science

Request A Call Back
Apply For franchise
Menu
Menu

MS-OFFICE WITH WORD, EXCEL & POWERPOINT

Course Duration

  • 60 Hours
  • 5 sessions/week

Tools Covered

  • MS Word
  • MS Excel
  • MS PowerPoint

Learning Mode

  • Online Live Classes
  • One on one Interactive session

We provide

  • Special sessions for doubt solving
  • Sessions recordings (on request)
  • Sessions documents (on request) 
  • Assignments Mock interview
  • Live Projects

MS Word Full Course Syllabus

1.About MS Word

  1. MS Office Button
  2. Quick Access Toolbar
  3. Title Bar
  4. Ribbon & Tabs
  5. Ruler

2.Text Basics

  1. Insert, Delete, Select Text
  2. Copy & Paste Text
  3. Save the Document

3.Proofing Features

  1. Correct Errors
  2. Check Word Count

4.Formatting Text

  1. Format Font(Size/Style/Color)
  2. Change Text Case
  3. Format Text Alignment
  4.  Insert Text Box
  5. Bold, Italic, Underline

5.Format Paragraph

  1. Create first line indent
  2. Apply a style
  3. Create new style

6.Modify Page Layout

  1. Change Page Orientation
  2. Change Page Size
  3. Change Page Margins
  4. Insert Break
  5. Insert Header Footer

7.Working with Tables

  1. Insert Table
  2. Convert text to table
  3. Add row/column in table
  4. Delete column/row
  5. Modify table
  6. Split text to column

8.Inserting Illustrations

  1. Insert Smart Art
  2. Add text in Smart Art
  3. Insert Picture
  4. Insert Clip Art
  5. Format Picture

9. Working with Lists

  1. Create Lists
  2. Use symbols as Bullets

10. Using Word Art

Using Word Art

11.Using Borders

  1. Using different Borders and shadings
  2.  Page Borders

12. Spacing

  1. Spacing

13. ADVANCED MS WORD

  1. Add Check box
  2. Convert doc to pdf
  3. Hyperlink
  4. Using Watermark
  5. Password Protect a Document
  6. Add/Remove Line Numbers
  7. Macro
  8. Create folder in Word document
  9. Create a template in word
  10. Inserting calendar

MS Excel Full Course Syllabus

1.About MS Excel

  1. Workbook window
  2. Create & Open Workbooks
  3. Office button
  4. Ribbons & Tabs
  5. Features of tabs
  6. Quick Access Toolbar
  7. Mini Toolbar
  8. Title, Help, Zoom, View

2. Excel Worksheet

  1. Worksheet, Row, Column
  2. Moving on Worksheet
  3. Enter Data
  4. Select Data
  5. Delete Data
  6. Move Data
  7. Copy Paste Data
  8. Spell Check
  9. Insert Symbols

3.Excel Calculations

  1. Addition
  2. Sigma Addition
  3. Substraction
  4. Calculate Average
  5. Sigma Average

4.Excel Fill Handle

  1. Fill Handle
  2. Fill Handle with text
  3. Text with numbers
  4.  Fill handle with dates

5.Excel Formula

  1. Create Formula
  2. Fill handle in formula
  3. Relative references
  4. Absokute references
  5. Instruction for typing
  6. Quick excel functions

6.Excel IF

  1. If Function
  2. If with calculations
  3. Excel COUNTIF
  4. Advance If

7.Advanced Excel

  1. Macros
  2. sumif
  3. vlookup
  4. Pivot table
  5. ISNA
  6. Find & Remove Duplicates
  7. Create Drop Down List
  8. Merge cells in excel

MS PowerPoint Full Course Syllabus

1.About MS PowerPoint

  1. MS Office Button
  2.  Quick Access Toolbar
  3. Ribbon and Tabs
  4. Features of the tabs
  5. Slide, Placeholder, Notes
  6. Mini Toolbar

2. Presentation Basics

  1. Creating a Presentation
  2. Save a Presentation
  3. Add Slide
  4.  how to apply themes
  5. Change color in themes
  6.  Background of theme

3.Text Basics

  1. Delete Text
  2.  Format Font Size/Style
  3. Format Text Color
  4. Change Text alignment
  5. Insert a Text Box
  6. Copy & Paste Text
  7. How to cut & paste text

4.Inserting Picture

  1. Insert Picture & clipart
  2. Edit Picture & clipart
  3. Numbered Lists

5.Working with Tables

  1. Insert Table
  2. Format Table

6.Charts

  1. Insert Chart
  2. How to enter chart data
  3. Chart Data

7.Slide Effects

  1. Animation Effect
  2. Custom Animation Effect
  3. Slide Transition Effects
  4. Set Slide Transition Sound
  5. Set Slide Transition Speed
  6. How to advance slides
  7. Viewing Slides