Home
About Us
Overview
Mission & Vission
Our Team
Our Project
Programs
MS-Office 2013
Advance Excel
VBA Programing
MS Access
Tally ERP9
Gallery
Member
Contact Us
Advance Excel
Course Duration:- 20 hrs with Industry Expert Trainers
Delivery Mode:- Online/Offline
Course Contents
Intoduction to Excel
Basic Concept of Menu and Toolbar
Simple cells formatting(Insert, Rows, Columns, Sheets, Merge Cells)
Cell Reference
Conditional Fromatting with New Rules
Define Name Range and Uses of Name Range
Counting based on condition using (countif, countifs)
Logical Function(IF, AND, OR, Not, Nestedif)
Mathematical Functions
Date & Time Functions.
Financial Function
Lookup and Reference Function
Auto and Advance Filter
Data Sorting based of color and value
Subtotal
Data Validation with custom rules
Formula Auditing in excel
Pivot Table and Charts
Security and Protection options
Data Import and Export between two files
What if Analysis
workbook sharing
Basic concept fo Macro recording
Revision and practical assesment
For more information please submit your details
Contact us for Offline/Online or Corporate Training
Name
*
Mobile No
*
Your Email
*
Program
*
MS-Office
Advance Excel
Tally ERP9
VBA Programing
Training
*
Offline
Online
City
*
Message