IT Tools With Advance Excel
Course : E-Accountant (12 months)
Introduction: Introduction of Computer, Types of Computer, Operating Software, Trouble Shooting, Internet.
MS Word: Formatting Text, Editing Images, Shapes & Charts, Hyperlink, Cross Reference, WordArt, Page Setup, Watermark, Mail Merge, Compare, Protection.
MS PowerPoint: Slide Preparation, Insert, Smart-Art, Charts, Design, Transitions, Animations, Slide Show, Review.
MS Excel: Preparing Salary Sheet, Mark Sheet using Sum, Average, Maximum, Minimum, Count, Counta, Logical Functions, Financial Functions, Date & Time Functions, Math & Trig. Functions, Text Functions etc.
Lookup & References: HLOOKUP, VLOOKUP, VLOOKUP with LARGE MAX, VLOOKUP with SUBTOTAL, Multiple VLOOKUP, Approximate VLOOKUP, VLOOKUP with MATCH, INDEX with MATCH Function etc., Absolute/Fixed, Relative & Mixed References.
Others: Advance Filter, Pivot Table & Charts, Hyperlink, Data Validation, Scenario Manager, Goal Seek, What-if-Analysis, COUNTIFS, SUMIFS, SUMPRODUCT, Loan Sheet, Attendance Sheet, Calendar, Advance Conditional Formatting, More than 100 Shortcut keys
Advantage: To achieve excellence in office work using MS Office. An e-Accountant gets lot of work in MS Excel, hence expertise in Advance Excel is essential to succeed as an e-Accountant.