E
x
c
e
l
P
T
P

MS Excel Corporate Professional onsite Training in India

September 18, 2013

Excel PTP is one of Best Corporate, professional and international training provider Training Company in Gujarat. ExcelPTP is part of Amar Technolabs Pvt. Ltd. Software Company and always ready to dealing to provide their best effort to provide Corporate Solution on Training programs.

By Excel PTP Program we delivered our Highly Qualified Trainer on MS Excel as per your need and on customize Courses over MS Excel.

MS Excel Basic

Excel Basics
The Excel Screen • Moving About the Workbook • Simple Data Entry • Selecting Ranges • Saving Workbook Formats
Copying & Filling
Using Fill for Quick Copying • Copying Cell(s) to One/Many Cells & Worksheets
Editing Data
Overwriting/Editing Cell Contents • Editing Formulae/Functions  • Using Undo/Redo •  Search & Replace
Adjusting a Worksheet
Inserting/Deleting Cells • Inserting/Deleting/Resizing Rows/Columns
Working With Worksheets
Copying/Moving/Renaming Worksheet(s) • Inserting/Deleting/Grouping Worksheets  • Hiding & Unhiding Worksheets
Formulae                                                                 
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
Formatting in Excel
Formatting Numbers/Dates/Currency • Formatting for Effect Bolding/ Italics/ Underling • Cell/Background Colours • Cell Alignment
Working with Functions
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Viewing Worksheets
Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows
Paste Special
Paste Special to Copy Formulae/Formats/Validations • Paste Special to Add/Multiple & Transpose
Fill Series
Filling a Series with formatting/without formatting • Filling a weekdays • Fill data using stop value
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
Define Names & Lables
Creating/Deleting Labels/ Names • Creating/Using Names in Formulas/ Across Workbooks
PivotTables 
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
LOOKUP Functions
The VLOOKUP/HLOOKUP Functions • MATCH with VLOOKUP Functions
Logical Functions 
IF’s and Nested IF Functions • Using AND/OR/NOT Functions
Statistical Functions
Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions
Date/Time Functions
Using The TODAY • NOW & DATE Functions • Using The DATEDIF/ NETWORKDAYS/ EOMONTH 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
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
Hyper / Data Linking 
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application
Filters & Data Sorting
Applying & Using AutoFilter • Creating a Custom AutoFilter • Sorting On More Than One Column
Printing
Simple Printing/Previewing • Page Setup & Orientation • Creating and Formatting Page Headers/Footers • Custom views

Advance MS Excel

Excel 2007 & 2010 Quick Overview
Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features
Basic Formula
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
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
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
Pivot Tables – Advance
Adding new calculated Fields / Items • Changing the Summary Function • Consolidate Pivot table
LOOKUP Functions – Advance 
MATCH with VLOOKUP Functions • INDEX & MATCH Functions • OFFSET/ INDIRECT functions
Logical Functions – AdvanceIf Loop and Nested IF Loop Functions • Using IF/ISERROR Functions
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
Date/Time Functions 
Using The Today • Now & Date Functions • Using The Datedif/ Networkdays/ Eomonth Functions • Using The Weeknum Functions • Using The Edate/ Networkdays.Intl/ Weekdays.Intl Functions.
Text Functions Using
The Mid/ Search/ Left/ Right Functions • Using The Trim/ Clean/ Upper/ Lower Functions • Using The Subsitute/ Text Functions • Using The Trim/ Clean/ Proper/ Dollar Function
Validations 
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting
Advanced Filters
Extracting Records with Advanced Filter • Using Formulas In Criteria
Advanced Sorting
Sorting by Top to Bottom / Left to Right • Creating / Deleting Custom List • Sort by using Custom List
Hyper / Data Linking
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application
Math & Trigonometry Functions
Using SUMPRODUCT Functions • Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
Summarizing Data
Creating Subtotals/Nested Subtotals • SUBTOTALS Formula
Outlining
Creating/Working with an Automatic/Manual Outline • Grouping / Ungrouping
Consolidation
Consolidating Data with Identical/Different Layout
Using Auditing Tools
Displaying/Removing Dependent & Precedent Arrows • Evaluate Formula – Step IN/ Step Out
Custom Views
Creating Custom Views • Displaying Custom Views • Deleting Custom Views
Sharing and Protecting Workbooks
Sharing Workbooks & Tracking Changes • Protecting sheets / workbooks / Files
Importing & Exporting Data
Importing Data from Database/ Text Files/ Web • Exporting Data • Changing External Data Range

For more information you can contact us at our email Ids as: info@ExcelPTP.com or visit our Office at office Address.