Brochure VIKOM INSTITUTE
Brochure VIKOM INSTITUTE
Brochure VIKOM INSTITUTE
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
What is Excel
Excel Keyboard shortcuts
Excel Basics
Formula & Cell Reference
Ga e of For ulas
a) Most co
o l used for ulas
b) Operatio i for ulas
c) Relative and Absolute Cell references
d) Co
o l used for ulas
e) List of Functions in Excel
f) Rarel used For ulas
Understanding the Arrays
Features of MS Excel 2010 and 2013
a) Introduction and Improvisation by 2010
b) Introduction and Improvisation by 2013
Upcoming version of Excel
Excel Charts
Table, Scenarios, Goal seek and What If analysis
Pivot Table
Spark lines
Introduction of Water Mark in excel.
Macro recording and Old Xl 4 macro function
Add a ADD IN from Macro in Excel
Input forms and Data validations
Web integration, Hyperlinks and dynamic Hyperlinks
E tras
A reference to Advanced Excel to VBA course
A reference to Dashboards
And much more
2
COURSE HIGHLIGHTS
Course will be dealt by various professionals expert in Excel, VBA, finance, cost,
accounts, auditing, software developing and so on.
Solved excel workbook is provided after each class for practice and unsolved
excel workbook are also available for each class on demand.
After completion of 25% and 60% classes an evaluation test will be done to
check your knowledge in excel.
Excel E-Book will be provided at the end of the course so that you will depend
on course instead of a single book for learning.
Query will be solved in 24 hours so that next session will not be effected.
Various assignment sheets will be given to improve your thinking .
Videos length are short so that you can handle your work with course.
The length of the course is 200 hours, 2 hours per day so you can choose any 100
days from 4 months.
This course is in English language but Indian customers can also ask their query
in Hindi language also
The cost is equivalent to 2500 INR of India. You can take help from Yahoo
currency converter . If your currency in not INR, to get amount equivalent to
your currency.
You can paid in any currency. However foreign exchange risk will be born by you.
3
ABOUT
WWW.VIKOMINSTITUTE.COM
4
Important Links
1.
2.
3.
4.
Want cool excel tricks then like us on face book and get daily updates
https://www.facebook.com/pages/Excel-Tricks/297136933632952?ref=hl