Customise Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorised as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

Academy of Data Science

MS-OFFICE WITH WORD, EXCEL & POWERPOINT

Course Duration

Tools Covered

Learning Mode

We provide

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