Certified in Smart Excel

Module 1: Complete Microsoft Excel 2016

• Introduction MS Excel 2016
• Getting Started with Excel 2016
• Create a new Workbook in Microsoft Excel 2016
• Worksheet Fundamental
• Selecting cells and Ranges
• Find & Replace Options
• Formatting Cell and Worksheet
• Cell Styles
• Conditional Formatting
• Creating Table in Excel 2016
• Sorting Data in Excel
• Filter in Excel 2016
• Creating Charts and Graphics
• Pivot Table & Pivot Chart Option
• Graphics & Designing in Excel
• Add INS Group Buttons of Insert Tab Excel 2016
• Linking & Hyper linking In Excel 2016
• Printing Your Work
• Analyzing Data with Excel
• Data Validation in Excel
• Solver Option
• Inking Option
• View Tab
• Using Macros in Excel

Module 2: Functions And Formulas In MS-Excel

• Working with Formulas and Functions
• Logical Functions
• Text Function
• Date and Time Function
• Financial Function
• Lookup & Reference Function
• Mathematical & Trigonometry Functions Function
• Trigonometry Functions
• Database Function
• Statistical Functions in Excel
• Information Functions in Excel
• Engineering Function
• Using Names to work with Ranges