Advance Excel Training Center

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
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
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 - [email protected], [email protected], Skype ID - AdvExcel1

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