MS Excel - Intermediate

  • Course Code
    : CC - 05
  • Class Room Training
    : 15 - 25 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 Complex Formulas and Basic
    functions can choose this course and who wants to
    Learn Interesting tips & tricks can choose this course.
  • Certificate
    : GST CENTRE – Participation Certificate.
    The Association of GST Professionals, India *
  • Students can appear Exam after completion of 25 Hours of Classroom Training.
  • Syllabus

  • 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