MS Excel Advanced

Leverage Excel’s advanced features to automate and streamline your day-to-day work.

Total Duration: 8 hours

ENROLL   

Target Audience:

A must for

  • Every professional from entry to senior level managers in any industry
  • Engineering & IT graduates BTech/ BE, BSc-IT, BCA, MCA, MSc-IT etc
  • Management/Commerce graduates – MBA, BBA, B.Com
  • For students aspiring for entry level jobs in any domain

Total Duration: 8 hours

Course Objectives:

  • Participants will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work
  • They will apply visual elements and advanced formulas to a worksheet to display data in various formats
  • Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work

Content:

  • Charts
  • Working with Datalists
  • Filtering & Querying data
  • Protection
  • Working with templates
  • Pivot Table
  • Projections, Vlookup
  • Macros

 

ENROLL