ADVANCE EXCEL (Global vision technologies)

GVT is one of the best IT Institutes, registered ISO 9001:2008 (QMS) certified, with assurance of 100% placement. GVT Institute is not just another institute. It s a humble birth of a significant education system and institution where every action and thought is student oriented, personal attention to every student is ensured, and LEAD is the Philosophy we follow.

Advance Excel has proven to be of great help for the Marketing Professionals. Therefore, this course aims at equipping Marketers with excel skills required for effective planning, executing and analyzing the performance in terms of ROI on each activity executed. The course is designed considering the Marketing activity cycle.

COURSE CONTENT:-

(Use of Multiple Formulas and Functions)

Grouping of Worksheets
Auto Fill Series-Numeric, Alphanumeric
Named ranges
File protection
Creation of custom lists
Data Validation-text, numeric
Comments
Multiple Use of Conditional Formatting
Use of Goal Seek, Scenarios Manager, Formula Auditing
Multiple Column Sort, Advance Filter and Custom Filter
Use of Form in Data Entry
Validation of Cells, Error Message, Error Alert
Use of Data Table in PMT
How to maintain Manual Loan Sheet.
All Spreadsheet Solutions Manual and Predefine.
How to Separate Text in columns
Consolidate Data Quarterly and Yearly Data
Consolidate, Analyze and Summarize Data by Pivot Table
Comparison of Two Columns Data
Use of Vlookup and Match together
Use of Vlookup and If together
How to create multiple list
How to Transpose Data by shortcut keys
Highlight Duplicate List by conditional formatting
Calculate Discount on MRP & TA, DA, HRA of Employee
Grading System
Grouping & Outlining Data
Creating charts
Need to represent data graphically
Position of a chart
Types of charts
Guidelines on selecting a chart
Titles, Gridlines, Legends
Data labels and Data table
Representing data graphically
Choosing different types of charts
Pivot Tables-introduction, concepts
Using the List Function
Pivot table

GVT- Global Vision Technologies
NM: 24/25, Old DLF, Sector - 14, Opposite ITI, Gurgaon.
Ph: 0124-4077070, +91-9953222158, 9953222112
Email: [email protected]
Web: www.gvt.org.in