Exclusive Advanced Excel Training in Chennai
Excel Spark Advanced Excel Training will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information.
List of Topics:
Pivot Table, VLookup/ HLookup, If & Nested If, Countif, Sumif and Charts.
Format as Table, Compare Two Tables, Highlight Duplicate Records, SubTotal, Data Validation, Formula Auditing, Different Error Types, Conditional Formatting, Goal Seek, Data Table, Pareto Chart, Define Name, Text to Multiple Columns, Grouping/Un Grouping, Auto Outline, Consolidate, Text Format to Number/ Date Format, File Protection, Protect & Hide Formulas, Text & Date Formulas, Custom list, Quick Reports, Useful Shortcuts and Tips & Tricks
Exce Spark is the Authorised Testing Center to conduct Microsoft Office Specialist (MOS) Exam
