Office Automation Courses

Connect with us on WHatsAPP

Online courses in Advance Excel

(Indian RS.)
(US $)
Advance Microsoft Excel
advance excel  
Course Contents  

Excel is 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
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)

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

Designing the structure of a template
Using templates for standardization of worksheets

Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options

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

Date and time functions
Text functions
Database functions

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

Google Talk:
Yahoo Messenger:
WhatsAPP / Viber
MSN Messenger:
Skype Talk:
Connect with us on WhatsAPP  / Connect with us on Viber +91 9819006132
Contact Person:
Mr. Faiyaz Khairaz: Mobile - Connect with us+91 9819006132
Office Address:
Head Office: Chinoy Mansion, First Floor, Block # 2,
Opposite St. Stephens Church, Warden Road,
Mumbai(Bombay) - 400 036, Contact No.:+91-22-23676218 / +91-22-23679302 /
Mobile: +91-9819006132.
"Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)." "COMPUFIELD-Leader in Global IT Corporate training having more than 20yrs exp.Programs offered MS-Office, Advance Excel, Java, Oracle, Linux and many more.""Compufield : free e-greeting cards, animated, musical greetings, ecards, postcards for Christmas, xmas, new year, eid, diwali, valentine's day, birthday, friendship, anniversary, love, congratulations, Halloween."