Facebook Linkedin Instagram Twitter
  • Who We Are
  • What We Do
  • Programs
  • Duration: 5 Days
  • Mode: Face-to-Face

Overview

This training program aims to equip participants with Excel skills, covering a range of functions, tools, and automation techniques essential for efficient. Each session is designed to build on the previous one, providing a comprehensive understanding of Excel functionalities.

Highlights

  • Hands-on with advanced Excel functions
  • Focus on formulas, lookup, text, and date functions
  • Practical use of PivotTables and data tools
  • Certification based on attendance, assignments, and test score

Eligibility

  • Working professionals with 2 to 5 years’ experience.
  • Pre-requisites: Laptop/System for Each participant

Course Content

  • Review of Basic Formulas
  • IF, AND, OR functions for decision-making in cells
  • LOOKUP, HLOOKUP, INDEX, MATCH for searching and referencing data
  • CONCATENATE, LEFT, RIGHT, MID for manipulating text
  • TODAY, NOW, DATE, TIME, and related functions
  • Freeze, Split window, Protecting sheets
  • Hands-on exercises and practice sessions

Outcomes

At the end of the course the learner will deal with:-
  • Proficient use of advanced Excel formulas, including IF, AND, OR, LOOKUP, HLOOKUP, INDEX, and MATCH functions.
  • Mastery in data analysis tools such as PivotTables, Pivot Charts, Data Validation, and Data Consolidation.

Certification Criteria

  • Attendance: 90% minimum
  • Assignment completion: 100%
  • Post-test assessment score: 70% minimum
  • Duration: 1 Day (8 Hours)
  • Mode: Face-to-Face
  • Duration: 5 Days
  • Mode: Face-to-Face
  • The programs will be certified by TVSTS.

Register Now

Apply For Job

Upload supported files Doc & PDF

Online Courses Registration

Apply For Job

Upload supported files Doc & PDF.
  • Corporate Training - B2B
  • Training – Onsite & Online
  • Consultancy & Management
  • BFSI
  • Educational Outreach Program - B2E
  • Manpower Solutions
  • Contract Staffing
  • NAP
  • LEAD
  • Our Facilities
  • Career
  • Ongoing Programs