Managing and Analyzing Data in Excel 2010 – Lynda

The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.

Topics:

• Multiple key sorting
• Single and multiple column numeric filters
• Creating a top-ten list with values or percentages
• Setting up subtotals
• Creating multiple-field criteria filters
• Creating unique lists from repeating field data
• Using the Remove Duplicates command
• Finding duplicate data with specialized arrays
• Counting the number of unique items in a list
• Using SUMIF and COUNTIF functions
• Working with the database functions such as DSUM and DMAX

Fees: – INR 15, 00 (assuming $ = INR 60)

Duration:

1 Hour 32 Minutes

• Excel