Copying data and formulas
Using simple aggregate functions (Sum, Count, Average, Min, Max)
Types of cell referencing: relative and absolute
Applying conditions in a formula (The IF function)
Working with ranges
Filtering data with auto filter
Generating subtotal reports
Creating pivot tables
Referring data from other worksheets
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.
*The cost for the course in Indian Rupees (INR) would change depending on the "Current Rate"of US Dollar