Academy of Data Science

MS Excel Course Content

Course Duration

Tools Covered

Learning Mode

We provide

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. Addition
  2. Sigma Addition
  3. Substraction
  4. Calculate Average
  5. Sigma Average

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

  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

  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. Fill Handle
  2. Fill Handle with text
  3. Text with numbers
  4.  Fill handle with dates

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