Mon - Fri 9:00 am - 5:30 pm

Verify your certificate

MS Office Intermediate

  • Course Code
    : CC-02
  • Class Room Training
    : 30 - 50 Hrs
  • E-Learning Facility
    : One Year Free Login
  • Eligibility
    : 10+2 / Equivalent
  • Suitable for
    : Everyone who likes to Improve their Skills and more Productive at Work
    can choose this course and who wants to Learn basic
    mathematical computations can choose this course.
  • Certificate
    : GST CENTRE – Participation Certificate.
    The Association of GST Professionals, India *
  • Students can appear Exam after completion of 30 Hours of Classroom Training.
  • Syllabus

  • Lesson Objectives
  • Introduction
  • The Excel Interface
  • The Ribbon
  • The Quick Access Toolbar
  • Backstage View
  • Creating and Opening Workbooks
  • Compatibility Mode
  • Convert a Workbook
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • The Cell
  • Select Single and Multiple Cells
  • Insert and Delete Cell Content and Delete Cells
  • Copy & Paste and Cut & Paste Cell Content
  • Access More Paste Options
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Modifying Column Width
  • Modify Row Height
  • Insert Rows and Columns
  • Delete Rows and Columns
  • Wrapping Text and Merging Cells
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Change Font and Font Size
  • Use the Bold, Italic and Underlined Commands
  • Font Color and Fill Commands
  • Text Alignment Commands
  • Formatting Numbers and Dates
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Use Save as Commands
  • Use Auto Recover
  • Save as an Excel 97-2003 Workbook and as PDF
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Creating Simple Formulas
  • Creating Formulas with Cell References
  • Create a Formula Using the Point and Click Method
  • Edit a Formula
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Rename, Insert and Delete a Worksheet
  • Copy and Move a Worksheet
  • Color Worksheet Tabs
  • To Group and Ungroup Worksheets
  • Freeze and Unfreeze Worksheet Panes
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • View Print Pane and Print Selection
  • Change Page Orientation
  • Fit a Worksheet on One Page
  • Modify Margins While in Print Preview
  • Use Print Titles
  • Insert a Break
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Sort in Alphabetical, Numerical and Date or Time Order
  • Custom Sorting
  • Sort by Cell Color, Font Color, or Cell Icon
  • Sorting Multiple Levels
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Outlining Data using Subtotal
  • Showing and Hiding Data
  • Removing Groups and Subtotaling
  • Creating your Own Groups
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Filter and Clear Filtered Data
  • Search Filter and Text Filter
  • Know Date Filter and Number Filter
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Format Information as a Table
  • Modifying Tables
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • The Ribbon
  • Backstage View
  • The Quick Access Toolbar and Ruler
  • Creating and Opening Documents
  • Compatibility mode
  • Convert a Document
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert, Delete and Select Text
  • Format Font Size, Style and Color
  • Use Bold, Italic and Underline Commands
  • Other Font Commands
  • Text Alignment
  • Text Box
  • Moving Text
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • To use Save as and Save Command
  • Auto Recover
  • Save as in Other File Format
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • To Change Page Orientation and Page Size
  • To Set Page Margins and Open Page Setup Dialogue Box
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Run Spelling and Grammar Check
  • Ignoring “errors”
  • Automatic Spelling and Grammar Checking
  • To Hide Spelling and Grammar Errors in a Document
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Print
  • Quick Print
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Indenting Text
  • Tabs
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Line Spacing
  • Paragraph Spacing
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Create List
  • Bullet Options
  • Multilevel Lists
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert a Break
  • To Delete a Break
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Add Columns to a Document
  • Adding Column Breaks
  • Self-Examination Questions