Excelis perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.
From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.
In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.
Free Trial Session Is Limited To Phase I Only
Module
1: Overview of the Basics
Customizing
common options in Excel Absolute and relative cells Protecting and un-protecting worksheets and cells
Module
2: Working with Functions
Writing conditional expressions (using IF) Using logical functions (AND, OR, NOT) Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH,
INDEX)
Module
3: Data Validations
Specifying a valid range of values for a cell Specifying a list of valid values for a cell Specifying custom validations based on formula for a cell
Module
4: Working with Templates
Designing the structure of a template Using templates for standardization of worksheets
Module
5: Sorting and Filtering Data
Sorting tables Using multiple-level sorting Using custom sorting Filtering data for selected view (AutoFilter) Using advanced filter options
Module
6: Working with Reports
Creating subtotals Multiple-level subtotals Creating Pivot tables Formatting and customizing Pivot tables Using advanced options of Pivot tables Pivot charts Consolidating data from multiple sheets and files using Pivot
tables Using external data sources Using data consolidation feature to consolidate data
Module
7: More Functions
Date and time functions Text functions Database functions
Module
8: Formatting
Using auto formatting option for worksheets Using conditional formatting option for rows, columns and cells
*The cost for the course in Indian Rupees (INR) would change depending on the "Current Rate"of US Dollar
/ 
+91 9819006132
+91 9819006132 
