Certified in Master in 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

Module 3: Macros & VBA Programming in Excel

1. Excel Dashboards 2016
   • How To Build Dashboard In Excel 2016
   • Comparative Excel Dashboard
   • Create Sales Performance Dashboard Using
2. Pivotchart & Slicer Object
   • Gantt Chart
   • Dashboards Related To Finance
   • Insert Pivot Tables
   • Advanced Chart In Excel
   • Excel Sparklines
   • Creating A Chart, Graph With Pictures In the Graph
   • Add A Trendlines To A Chart
   • Advanced Pivot Table
   • Excel Data Validations
   • Data Analysis
   • Sorting & Filtering Data In Excel Apply Excel Advanced Filter
   • Advanced Conditional Formatting
3. What - IF Analysis
   • Scenario Management
   • Goal Seek
   • Data Table
   • Solver
4. Analysis Tool Pak
   • Histogram Option
   • Descriptive Statistics
   • F-Test
   • T-Test
   • Moving Average
5. Hyperlink, Linking & Embeddingin Excel
   • Hyperlink Options
   • Linking In Excel
   • Microsoft Office Security Warning
6. Advanced Functions And Formulas In Excel
   • Logical Functions
   • Date & Time Function
   • Internal Rate of Return Function
   • Advanced Lookup & Reference Functions
   • Advanced Math & Trig Function
   • Engineering Function
     • Excel Industrial Project
     • Additional Functions In Excel
     • Excel Related To H.R
     • Using Excel in Finance

Module 4: Macros & VBA Programming in Excel

• Creating a Macro
• Running a Macro
• Editing a Macro
• Adding a menu to the Menu Bar
• Adding a Commands to a Menu
• Adding Buttons to a Toolbar
• Data Handling, MIS, EXCEL and Access
• Macro Generation and Application Design
• VBA in Excel 2016
• VBA Programming
• Macros & the VB Editor
• Modifying the Recorded Code
• Projects & Reports
• Various Examples