DIGIBRAND

WEEKLY UPDATE
EXIT
SEO Plugin by
Certification Program in Microsoft Office – Academy of Data Science

Academy of Data Science

MS Excel Course Content

Course Duration

Tools Covered

Learning Mode

We provide

MS Word Full Course Syllabus

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

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

  1. Correct Errors
  2. Check Word Count

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

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

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

  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

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

  1. Create Lists
  2. Use symbols as Bullets

Using Word Art

  1. Using different Borders and shadings
  2.  Page Borders

  1. Spacing

  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. 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

  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

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

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

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

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

  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. MS Office Button
  2.  Quick Access Toolbar
  3. Ribbon and Tabs
  4. Features of the tabs
  5. Slide, Placeholder, Notes
  6. Mini Toolbar

  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

  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

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

  1. Insert Table
  2. Format Table

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

  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