Course Contents

Introduction to MS Excel and Understanding Basic working with it.
Working with Formulas of various types.
Function types  and operations with them in Excel.
Conditional Formatting
Data Sorting and Filtering
Advanced Filtering with Pivot Table
Changing and Updating Data Range
Pivot Charts
Formatting Pivot Charts
Dynamic Pivot Chart creations.
VBA Macro
Adding Add-Ins in Excel

Need Counselling ?

Frequently Asked Questions

K2N Academy's courses are designed with inputs from corporate houses as Industry Ready programs which have ready acceptance in Industries.
We do provide soft copies of notes and handout of the classes for the benefit of students.
Yes we have selective courses which lead to global certifications.
We do provide certificates to the students on the basis of periodic evaluation test conducted during training..