www.excelprodigy.com Excel Prodigy Chennai : Excel Training

[MariPriya]

Name Of Training Institute : Excel Prodigy (excelprodigy.com)
Location of the Institute: Chennai
Training Offered : Excel Training

http://www.excelprodigy.com/advanced...ml#page=page-1

Excel Training
We started as Advanced Excel training center in Chennai and now converted as Excel Prodigy for training corporate to best suit their schedule, budget, learning style and expertise.

Our training courses will show you how to use Excel better, faster and more efficiently. You will learn how to save time, access new features in Excel and work with confidence.We provide a dynamic learning environment with lots of practical hands on exercises and real world examples.

We have provided advanced excel training for various organizations in Chennai, Bangalore, Hyderabad, Mumbai & Delhi.

Our Professional Excel Training Program consists of different levels.

Intermediate Excel Training
Duration: 8-12 Hours

Overview:
Our most popularcourse.You’ll learn how to create templates for commonly used worksheets. Learn how to apply filters and sort data into key elements. Getting Excel to make decisions using the ‘If’ function, Pivot Table and conditional formatting,. Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed

References
LOOKUP Functions
The VLOOKUP/HLOOKUP Functions

PivotTables
Creating, Formatting Simple PivotTables
• Page Field in a PivotTable
• Formatting a PivotTable
• Creating/Modifying a PivotChart

Chart Data Techniques
The Chart Wizard
• Chart Types
• Adding Title/Legends/Lables
• Printing Charts
• Adding Data to a Chart
• Formatting/Renaming/Deleting Data Series
• Changing the Order of Data Series

Logical Functions
IFs and Nested IF Functions
• Using AND/OR/NOT Functions

Statistical Functions
Using The SUMIF/COUNTIF Functions
• Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Text Functions
Using The MID/ SEARCH/ LEFT/ RIGHT Functions
• Using The TRIM/ CLEAN/ UPPER/ LOWER Functions.

Validations
Input Messages / Error Alerts/ Drop-Down Lists
• Conditional Formatting

Date/Time Functions
Using The TODAY
• NOW & DATE Functions
• Using The DATEDIF/ NETWORKDAYS/ EOMONTH Functions.

Fill Series
Filling a Series with formatting/without formatting
• Filling a weekdays
• Fill data using stop value Filters & Data Sorting

Contact
Excel Prodigy
New No.19, Kambar Street
Metha Nagar, Chennai - 600029