Don Bosco Institute of Management Studies & Computer Application

Menu
Menu
Degree Colleges in Bangalore

WAYANAMAC EDUCATION TRUST ®

DON BOSCO

INSTITUTE OF MANAGEMENT STUDIES & COMPUTER APPLICATIONS

Affiliated to BU, Approved by AICTE, UGC & GOK, Accredited by NAAC with B++ Grade

Vision: "To be the Most Preferred Institution by Students, Parents and Recruiters"

Facebook Twitter Instagram Youtube Linkedin
Menu

Value Added course in Certificate for Advanced Excel

Objectives of the study:

  • Use advanced functions and productivity tools to assist in developing worksheets.
  • Manipulate data lists using Outline, Auto filter and Pivot Tables.
  • Use Consolidation to summaries and report results from multiple worksheets.

Course Name

Value Added  course in Certificate for Advanced Excel

Course coordinator

Prof.Vinayak. T

Duration

6 weeks  Total 30 hours in a week 5 hours

Eligibility

Students can do this simultaneously  with undergraduate course

Intake capacity

51 students

Course Syllabus
  1. Goal Seek
  2. Data Tables (PMT Function)
  3. Solver Tool
  4. Scenario Analysis
  1. Number, Date & Time Validation
  2. Dynamic Drop down List Creation using Data Validation – Dependency List
  3. Custom validations based on a formula for a cell
  4. Text and List Validation
  1. Vlookup / HLookup
  2. Vlookup with Helper Columns
  3. Creating Smooth User Interface Using Lookup
  4. Index and Match
  5. Reverse Lookup using Choose Function
  6. Nested VLookup
  7. Worksheet linking using Indirect
  8.  
Outcomes:
  1. Use advanced functions and productivity tools to assist in developing worksheets. 
  2. Manipulate data lists using Outline, Auto filter and Pivot Tables.
  3. Use Consolidation to summaries and report results from multiple worksheets.
Need Help?