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

customercare.gstcentre@gmail.com
Verify your certificate

MS Office Expert

  • 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
    using advanced function can choose this course and
    who wants to Learn Interesting tips & tricks can choose this course.
  • Certificate
    : GST CENTRE – Merit Certificate.
  • Students can appear Exam after completion of 25 Hours of Classroom Training.
  • Syllabus

  • Lesson Objectives
  • Introduction
  • About a Hyperlink
  • Insert a Hyperlink
  • Make an Email Address a Hyperlink and Remove Hyperlink
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert and Resize the Shape
  • Change the Order of Shapes
  • Changing a Shape’s Appearance
  • Change the Shape Style and Color
  • Change the Shape Outline and Shadow Effects
  • 3D Effects
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert, Move and Resize a Text Box
  • Changing a Text Box’s Appearance
  • Changing a Text Box’s Appearance
  • 3D Effects for Text Box
  • Creating Word Art
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Locate and Insert Clip Art
  • Insert a Picture from a File
  • Changing Text Wrapping Settings
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Crop and Add Border to an Image
  • Image Adjustments
  • Artistic Effects and Styles
  • Compressing Pictures
  • Removing the Background from an Image
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Select a Style and Apply a Style Set
  • Modifying a Style and Create New Style
  • Using Themes
  • Customizing a Theme
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert a Header and Footer
  • Adding Page Numbers
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • About Track Changes
  • Adding and Deleting Comments
  • Accepting and Rejecting Changes
  • Changing How Markups Appear
  • Comparing Two Documents
  • Using the Reviewing Features Safely
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert Blank Table and Convert Text to Table
  • Add and Delete Row and Column
  • Apply a Table Style and Border
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert a Smart Art Illustration and Add Text to Smart Art graphic
  • Changing the Organization of a Smart Art Graphic
  • Modifying the Smart Art Graphic's Appearance
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Insert a Template
  • Entering Information to a Template
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Use Mail Merge
  • Insert Recipient Data
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • The Order of Operations
  • Create a Complex Formula using the Order of Operations
  • Working with Cell References
  • Relative References
  • Absolute References
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Know the Parts of Functions and Arguments
  • Create a Basic Function in Excel
  • The Function Library
  • The Insert Function Command
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Track Changes
  • Adding, Editing and Deleting Comments
  • Accepting and Rejecting Changes
  • Adjusting how Changes are viewed
  • Finalizing your Workbook
  • Protecting your workbook
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Create a New Workbook using a Template
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Types of Charts
  • Identify the Parts of a Chart and Create a Chart
  • Chart Tools
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Sparklines
  • Create Sparklines
  • Change the Appearance of your sparklines and Display Range
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Create a Conditional Formatting Rule
  • Conditional Formatting Presets
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Using a Pivot Table
  • Pivoting Data
  • Using Report Filters
  • Slicers
  • Using a Pivot Chart
  • Self-Examination Questions
  • Lesson Objectives
  • Introduction
  • Using Goal Seek
  • Other Types of What-If Analysis
  • Self-Examination Questions