Learn everything about Analytics

Managing and Analyzing Data in Excel 2010 – Lynda

Lynda
0-6 Month Online
Intermediate Contact Institute
Online Business Intelligence
Online Self Paced 407
Rate this post
DescriptionProgram StructureToolsContact

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
Name :
Email :
Contact Number :
Message :
Code :

Leave A Reply

Your email address will not be published.

Join 50,000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.