Academy of Data Science

Request A Call Back
Apply For franchise

MS Excel Course Content

Download Brochure
Apply Now

Course Duration

  • 60 Hours
  • 5 sessions/week

Tools Covered

  • MS Excel

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

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