Time : 10:00 am - 5:00 pm

MS Excel - Beginner

  • Course Code
    : CC-04
  • Class Room Training
    : 18 - 30 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