Satish H

Years of Experience in MS Office Software Training

10

Teaching Experience in detail in MS Office Software Training

Excel Interface and Excel Basics Excel 2003 vs Excel 2007 Vs 2010 Excel Interface • Worksheet Components • Ribbon & Office Button • Excel Options • Status Bar & Quick Access Toolbar • Formula Bar & Name Box Formatting Techniques • Number Formats • Borders & Cell Styles • Font Type, Colour& Size • Copy Painter & Fill Handle Excel Windows Views • Freeze Panes • Split Panes • Multiple Windows Series & Arrays • Number & Date Series • Adding / Modifying Series • Creating & Using Arrays Tables • Creating & Naming Tables • Table Formatting & Styles • Table Sorting & Filtering • Resizing Tables • Conditional Formatting • Subtotals Charts & Pivot Tables Charts • Chart Types & Uses • Chart Styles • Formatting Chart Axis • Formatting Chart Area • Secondary Axis Charts Pivot Tables & Pivot Charts • Pivot Table Components • Inserting Pivot Table • Pivot Table Calculations • Formatting Pivot Tables • Pivot Table Layouts • Sorting & Filtering Pivot Charts • Pivot Chart Types • Pivot Chart Styles • Formatting Chart Axis • Formatting Chart Area • Secondary Axis Charts Other Essentials • Hyperlinks • Paste Specials • Removing Duplicates • Smart Art • Word Art & Pictures • Check Boxes • Importing Text Files • Excel Shortcuts ADVANCED EXCEL Formulas’ Operators • Operator Type and Uses • Order of Precedence Formulas • Using Formulas • Absolute & Relative Referencing • Financial Functions • Logical Functions • Text Functions • Date & Time Functions • Lookup, H&V Lookup Functions • Statistical Functions Scenario Manager • Creating Scenarios • Generating Scenario Reports Goal Seek • Using Goal Seek Analysis Tool Data Table • Sensitivity Analysis • One & Two Variable Data Table Formula Auditing • Evaluating Formula • Tracing Precedents • Tracing Dependents • Error Checking ADVANCED Solver • Installing a Solver Add-In • Adding Constraints • Generating Solver Reports • Studying Solver Reports • Solver Options Data Validation • Adding Data Validation • Custom Input Messages • Custom Error Alerts Macros • Recording & Storing a Macro • Assigning Shortcuts to Macros • Complex Functions Using Macros • Macros Security Printing • Page Layouts & Printing Titles • Header & Footers • Setting Print Area Protection • Protecting a Sheet • Protecting a Workbook • Structure Protection Reviewing • Adding Comments • Deleting Comments

Years of Experience in Non-Verbal Aptitude Coaching

10

Teaching Experience in detail in Non-Verbal Aptitude Coaching

• Puzzles, Logical questions, Analogies • Venn Dia, Blood relation, Course of action • Decision Making, Cubes and Deices • Figure problem, Clock, Calendar and age • Direction and Senses, Series, Day Sequence • Odd man out, Input And Output, Statement and arguments, Symbols and Notation • Data sufficiency, Coding and Decoding

Years of Experience in Verbal Aptitude Coaching

10

Teaching Experience in detail in Verbal Aptitude Coaching

• Aptitude oriented Grammar Concepts • Antonyms and Synonyms • Fill in the blanks • Idioms and Phrases • Comprehension • Error Correction and Analogies • Class room training • Working with Initiative, Leadership, Assertiveness, Opening and Closing, Communications, Flexibility and Creativity. • Tips and Tricks • Mock GD / PI

Years of Experience in Quantitative Aptitude Coaching

10

Teaching Experience in detail in Quantitative Aptitude Coaching

• Numbers, Time Distance, Boat and Stream • Allegation, Unity Method, Average, Geometry • Banker Discount, HCF, LCM, Simplification • Square root and Cube Roots, Surd and Indices • Race, Problems on Train, Probability • Simple and compound interest, Percentage • Profit and loss, Compound proportion, Pipe and Cistern • Area, Ratio and proportion, Algebra, Clock