Advance Excel - Virtual Vision Institute

1
EXCEL SYLLABUS
2
What is Microsoft Excel?

• It is a spreadsheet program that is commonly used
  to record and analyze numerical data. Why is
  Microsoft Excel essential? We all deal with
  numbers daily. Microsoft excel is something that
  can be used for personal reasons or business. It
  is handy and easy to use if taught correctly.
  This course is designed for the ones who want to
  become a data scientist or business analyst. What
  will you learn? In this course, you will learn
  both primary as well as advanced techniques. You
  can use Microsoft Excel for work or study, and
  soon you will be known as the Excel Ninja!

3
Advance Excel Syllabus

• Basic Excel, Maintaining Stock
• Conditional Formatting
• Time Calculation
• Excel Financial Function
• Payroll Sheet
• Depreciation Calculation
• What If Analysis, Graph

4
Advance Excel Syllabus

• Charts, V Lookup, H Lookup
• Generate Pay Slip
• Indirect Function, Pivot Table
• Freeze Panes
• Hyperlink,
• Advance Filter
• Logical Test

5
THANK YOU..!!!