Excel and Advanced Excel Training Duration 36 Hrs.
Program highlights and Objectives:
This program is specially designed for students willing to work as an office administrator, back or front office executive etc. Working professionals who wish to enhance their administrative skill with excel may also join this course. After completion candidate can work efficiently in MS-Excel with advanced features.
Course highlights
  • Navigate the Excel User Interface
  • Formatting
  • Usage of formula
  • Implementing Functions – Mathematical Function, Statistical function, String & Date functions.
  • Creating Chart
  • Implementing different types of chart & chart modification
  • Pivot table & Chart
  • Auto & Advanced Filter
  • Linking between two workbook & worksheet
  • Validation
  • Page Layout
  • OLE
  • Goal Seek, Solver , Scenario
  • VLookup, HLookup
  • Protecting worksheet, workbook
  • Cell Referencing
  • Absolute Cell Referencing
  • Macro
  • Performing Calculations
  • Analyzing Data
  • Visualizing Data With Charts
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data
  • Forecasting Data
Final Project
Download Curriculum
Exit Profile : MIS Professional
Placement assistance will be provided to all successful candidates
Training Objective
The primary function of MIS is to report on business operations to inform decision-making. Organizations utilize MIS to improve management, optimize operations, and gain a competitive advantage in their industry. It is a great career choice for fresher’s & working professionals.
Classroom Training | Live Online Training
Call : 8337066108 | 9123080133 | 9830070014
9433258217 | (033) 24617112
Hi ! Send your detail for quick information