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

APPLY FOR CENTRE
Verify your certificate
SEARCH OUR CENTRES

PICK YOUR STATE

×
Assam
Punjab
Rajasthan
Goa
Bihar
Jammu and Kashmir
Orissa
Tamilnadu
Haryana
Madhya Pradesh
Delhi
Maharashtra
Telangana
Uttar Pradesh
Gujarat
Karnataka
Kerala
West Bengal
Uttarakhand
Chandigarh
Jharkhand
Sikkim
Chhattisgarh

   PICK YOUR CITY

×
Loading...

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

    Chapter 1
    Working with Hyperlinks

  • Lesson Objectives
  • Introduction
  • About a Hyperlink
  • Insert a Hyperlink
  • Make an Email Address a Hyperlink and Remove Hyperlink
  • Self-Examination Questions

    • Chapter 2
    Working with Shapes

  • 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

    • Chapter 3
    Text Boxes and Word Art

  • 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

    • Chapter 4
    Inserting Clip Art and Pictures

  • Lesson Objectives
  • Introduction
  • Locate and Insert Clip Art
  • Insert a Picture from a File
  • Changing Text Wrapping Settings
  • Self-Examination Questions

    • Chapter 5
    Formatting Pictures

  • 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

    • Chapter 6
    Styles and Themes

  • 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

    • Chapter 7
    Working with Headers and Footers

  • Lesson Objectives
  • Introduction
  • Insert a Header and Footer
  • Adding Page Numbers
  • Self-Examination Questions

    • Chapter 8
    Reviewing Documents

  • 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

    • Chapter 9
    Working with Tables

  • 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

    • Chapter 10
    Smart Art Graphics

  • 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

    • Chapter 11
    Using a Template

  • Lesson Objectives
  • Introduction
  • Insert a Template
  • Entering Information to a Template
  • Self-Examination Questions

    • Chapter 12
    Using Mail merge

  • Lesson Objectives
  • Introduction
  • Use Mail Merge
  • Insert Recipient Data
  • Self-Examination Questions

    • Chapter 13
    Creating Complex Formulas

  • 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

    • Chapter 14
    Working With Basic Functions

  • 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

    • Chapter 15
    Reviewing and Sharing

  • 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

    • Chapter 16
    Using Templates

  • Lesson Objectives
  • Introduction
  • Create a New Workbook using a Template
  • Self-Examination Questions

    • Chapter 17
    Working With Charts

  • Lesson Objectives
  • Introduction
  • Types of Charts
  • Identify the Parts of a Chart and Create a Chart
  • Chart Tools
  • Self-Examination Questions

    • Chapter 18
    Working With Sparklines

  • Lesson Objectives
  • Introduction
  • Sparklines
  • Create Sparklines
  • Change the Appearance of your sparklines and Display Range
  • Self-Examination Questions

    • Chapter 19
    Using Conditional Formatting

  • Lesson Objectives
  • Introduction
  • Create a Conditional Formatting Rule
  • Conditional Formatting Presets
  • Self-Examination Questions

    • Chapter 20
    Creating Pivot Tables

  • Lesson Objectives
  • Introduction
  • Using a Pivot Table
  • Pivoting Data
  • Using Report Filters
  • Slicers
  • Using a Pivot Chart
  • Self-Examination Questions

    • Chapter 21
    Using What-If Analysis

  • Lesson Objectives
  • Introduction
  • Using Goal Seek
  • Other Types of What-If Analysis
  • Self-Examination Questions

    • ONE YEAR

    E-LEARNING SUPPORT

    www.learngstindia.com