Course Details

Government Certified Institute from Central Board of IT & Vocational Training Highly Qualified Lecturers Professional Training in Financial Accounting with Tally ERP 9.0 latest version 5.1 from Specialized Lecturer from Tally Academy Toppers in Science IT , Tally ERP 9.0 FYJC to TYBCOM Coaching Classes FYJC Computer Science SYJC Computer Science FYBSC CS, SYBSC CS, TYBSC CS FYJC IT SYJC IT FYBSC IT, SYBSC IT, TYBSC IT Banking Preparations IDOL Online Admission Services. We provide specialize training on advance Excel. Module 1 Introduction Function Wizard Absolute Referencing Name Range Conditional Formatting Sorting and Filtering Advance Filter Consolidate Vlookup and Hlookup Working with Goal Seek Data Tables Scenario Manager Financial Functions IF Function And, Or and Not Function Pivot Tables Pivot Charts Subtotals Working with Smart Art Working with Quick Access Toolbar Working with Graphics Custom Styles and Merging Styles Using Templates Inserting and Editing Comments Working with Date Functions Module 2 Macros Recording a Macro Assigning a Macro Running a Macro Deleting a Macro Collaborating with Others Sharing Workbook (track changes) Setting Workbook Permissions Form Module 3 VBA Array Checkbox Combo box List box Logical operators Mod operator Option button Multi-column combo box Multiple list box selection Select case Spin button Text box User form Vlookup