Duration : 6 Months
Course Contains :
LEARN EXCEL BEGINNING TO ADVANCED LEVEL

Learn the Data Analysis.

Learn the Sort & Advance Filter Options.

• Sort
• Advanced Sort
• Auto Filter
• Advanced Filter

Learn the use of Pivot Tables & Charts.

• Pivot Tables
• Pie Chart
• Column Chart
• Line Chart

Learn the Financial Function with

• PMT
• FV
• PV
• INTRATE

Learn the Validation & Protection with

• Protect Sheet
• Protect Work Book
• Validation
• Template

Learn the What If Analysis Tools with

• Goal Seek
• Solver
• Scenarios

Learn the Lookup Tools with

• VLOOKUP
• HLOOKUP

Learn the Type of Reference with

• Relative Reference
• Absolute Reference
• Mixed Reference

Learn the Logical Function with

• IF
• IF with or
• IF with and
• IF with not
• Sumif
• Sumifs

Learn the various function with

• Change case with Lower case, Upper case, Proper case, Len
• Concatenate
• Day, Month, Year, Date, Weekday
• Integer, Square Root, Power
• Trim Function like Left, Right, MID
• MOD, EDATE, EOMONTH

Learn the Various Excel Project

• Live Project with Financial Function
• Live Project with VLookup
• Live Project with Income Tax Computation Sheet
• Live Various Project with Various Excel Function

LEARN VARIOUS PROJECT WITH MICROSOFT WORD (39 Pages)

• Various Personal Letter
• Various Duty Roster
• Certification (To Whom It May Concern)
• Various ORDER, Notice, Corrigendum, Notification
• Various Recruitment Order
• Various BIO – DATA

VIRTUAL MEMEORY WITH VARIOUS GOOGLE APPS

• Google Drive
• Google Sheets, Google Docs, Google Slides
• Google Form

LIVE PRINTING CLASS

• WORD PRINTING
• EXCEL PRINTING
• POWERPOINT PRINTING
• PDF PRITING
• PHOTO PRINTING

Eligibility : Madhyamik or Equivalent Passed / Appeared or higher