Advanced Excel TallyERP9 Trainer

Ten Years experienced Faculty about MS Office, Tally.ERP9

Advanced Excel Contents
Introduction and uses of MS Excel
Auto Fit/best Fit
Currency format
Wrap text, Format painter
Excel Shortcut Key s
Difference between Workbook, Worksheet & Cells
Working with 30 Basic Formulas like: (Sum, Product, Average, Count, Max, Min, Mod etc.)
Logical Function (IF, AND, OR, NOT) Tax Condition
Date Function
Simple & Conditional formatting
Budget
Bookmark & Hyperlink
Custom List
Data Validation
Vlookup
Hlookup
Form
Financial Functions like: (PV, FV, PMT, PPMT, IPMT, NPER, RATE, SLN, DB etc.)
Goal Seek
Scenario Manager
Data sorting
Trace precedence, Show formulas and error checking
Filter &Advance Filter
Macro s

Cell, Range, Worksheet & Workbook protection
Database Functions
Consolidation of Data
MIS Reports (Data Management)
Pivot Table
Page Setting, Hide & Unhide
Arrange, save workspace, freezing data, split option
Loan Amortization Sheet
Attendance sheet
Linking Multiple Sheets
Linking Between Word/Excel/PPT
Graphic Operations- Create charts, Enhance charts, drawing toolbar features etc.