Name Of Training Institute : Excel Prodigy (excelprodigy.com)
Location of the Institute: Chennai
Training Offered : Excel Training
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 Us :
Excel Prodigy
New No.19, Kambar Street
Metha Nagar, Chennai – 600029