Idea Computers Tally Academy

ADVANCED MS – EXCEL - Training

45 days

Daily 2 Hours

Certification

Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013, Advanced Excel is designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

Course Fees Rs 3500

Course objectives:

ADVANCED MS – EXCEL 2007/2010/2013

INTRODUCTION TO MS- EXCEL
USES OF EXCEL
BASICS OF EXCEL SHEET
VIEWS OF EXCEL SHEET
SPREED SHEET
WORKSHEET CALCULATION

MENU TABS:

OFFICE BOTTON/FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
PICTURE TOOLS
DRAWINGS TOOLS
DESINGINGTOOL

FUNCTIONS IN EXCEL:

GENERAL FUNCTIONS.
SUM FUNCTIONS.
LOGICAL FUNCTIONS.
MATHEMATICAL FUNCTIONS.
STATISTICAL FUNCTIONS.
TEXT FUNCTIONS.
DATE &TIME FUNCTIONS.
- DATEDIF FUNCTIONS.
- STRING MANIPUCATIONS
LOOKUPS
V LOOKUP
V LOOKUP MATCH.
V LOOKUP SHEET TO SHEET.
VLOOKUPSHEETTO SHEET MATCH.
V LOOKUP BOOK TO BOOK.
VLOOKUPBOOK TO BOOK MATCH.
H LOOK UP
- H LOOKUP MATCH
- H LOOKUP SHEET TO SHEET.
- H LOOKUP SHEET TO SHEET MATCH.
- H LOOKUP BOOK TO BOOK.
- HLOOKUP BOOKTO BOOK MATCH.
- OFFSET
- RIGHT LOOKUPS
- DOUBLE LOOKUPS
- CONDITIONAL LOOKUP
- INDIRECT
- INDEX
- PAYROLL CREATION
- REPORTING
- ADD INS
- DYNAMIC CHARTS
- MISREPORTING&DASHBOARD PREPARATION
- TEMPLATES CREATION

Coming Soon

Idea Computers Tally Academy Certification Process:

At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a data-set to work. Once you are successfully through the project (Reviewed by an expert), you will be awarded a certificate with a performance-based grading. If your project is not approved in 1st attempt, you can take extra assistance for any of your doubts to understand the concepts better and reattempt the Project free of cost.

90 hours training by working professionals on the same platform.
Course completion certificate will be issued.

CALL ME BACK