Complete MS-Excel (Basics + Advance)

Course Description:
Complete Practical Oriented Course With Project

Course Contents:
• Introduction to Excel Object Model
• Introduction To Ribbon Bar & Panels
• Relative & Absolute Reference
• Applying Formulas
• Working with Functions
• Charts & Smart Drawing Objects
• Working with Page Layout & Printing
• Sorting & Conditional Formatting
• Security / Protection of Workbook & Sheets
• Working with Nested if Conditions
• Data Validations, Customization of Series List
• Various Types of Functions: Mathematical, Statistical
• Logical and Text Functions
• What if Analysis, Goal Seek, Trends and Scenarios
• Pivot Tables, Understanding of Name Ranges
• Recording and Running Macros
• Charts & Spark-lines

Course Outcome:
*