Learn Advanced Excel, VBA Macros or MS Access

Learn Complete Advanced Excel with VBA and Dashboad

Excel Formulas

Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive Training Program explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas

Enrol This Course Now

PART=1

     1. Workbooks (File) & Worksheet Handling

        Excel Limitation

        Excel Shortcut use and benefits

        Excel Setting and Custom List Creation

        Excel Tamplate and File Location System

        Advanced Paste Special

        Calulation with Paste Special

        Link Data range as Picture Link

        Loopkup Picture in Excel Worksheet

     2. Advanced Formating for Reports and Dashboard

        Formatting Triks

        Date & Time For Trinks

        Advanced Custom Formating (Number Format using Code)

        Condtional Formatting

        Advanced Conditional Formatting using Formulas

        File,Sheets or Cells Protection Method

        Benefits of Data Table or Cells Style

     3. Data Handle and Data Analysis

        Data Fill and Selection Method

        Advanced Sorting and Filter Trinks

         Data Summerization with Pivot Table

         Calculation with Pivot table

        Extranal Data Pivot Table

        Relationship and Slicer in Pivot Table

        Power Pivot in Excel 2016

        Use SQL Query in Pivot Table

     4. Page Setting and Form Creation

        Drow Form in Excel Sheet

        Hyperlink in Excel

        Text and Symbol

         Page Setup

        Manage View

        Sheets Option and Arrange

     5. Calculation (more then 200 Formulas)

        Mathameticals Calculation in Excel

        Logical Formulas (IF, and, Or, Xor, IfError Formulas)

         Nested If Formulas ( Multi Condition in If,and,or )

         Text and Advanced Text Formulas

        Date and Time Calculation using Data Time Formulas

        Ref# Formulas and VLookup

        Lookup Method(VLookup,HLookup,Match,Index,Offset)

        Advanced VLookup and VLookup Listing

        Math & trico. Formulas

        Data Summerization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE,SMALL and more)

        Database and list managment Formulas

        Information Formulass

        Financial Formulas

     6. Advanced Formulas

        Advanced Array Formulas

        Complicated Large Formulas Creation

         Advanced Naming Method with Formulas

         Report Automation with Formulas

         Live Automation Projeact

        Use Formulas in Conditional Formatting

        New Formulas Creation with VBA Programming

     7. Databse and Other Application Conectvity

        MS Access Database Conectvity

        Notepad and Webdata Connectvity

         Embed Other Application

         SQL or Oracle Connectvity

         SQL Query in MS Excel 2016

         File & Folder Directory Access

     8. Dashboard Report Automation

        Chart Creation

        Chart Triks

         use Button on chart

         Dynamic Chart with Offset Formulas

         Dashboard Example

         Live Project

     Course Duration & Fees

         25 to 35 Hours ( Mon to Fri - 1 Hours Class 5:00AM to 11:00PM)

        One to One Live Online Class

         Fees : - 7500/

         Class Videos, Notes, PDF Books, Articles and Free Re-Joining

Enrol This Course Now

Sample Videos

Watch More

Advanced Excel & MIS Training Institute

Part of IPT (Institute of Professional of Training)
This is Group of Working Professianal Do Frelance with Us you can join our Class from your Computer using Gotomeeting

Operational Office : - Dakshinpuri, New Delhi - 110062
E-Mail - Kumar@iptindia.com, sujeetkumar.ipt@gmail.com, Skype ID - AdvExcel1

Mobile - +91 8802579388, +91 8826828093, +91 9968811487

         

Book Demo Class