Advance Indirect function with Count & Sum family Functions – Chapter 3

1,000.00

Excel MIS Analytics Indirect Count and Sum family functions – Chapter 3

Category:

Description

  • What is indirect function
  • Why you need this function. Case studies to understand this complex function
  • Indirect with Drop Down
  • Name managers use in Excel – Their use and Advantages
  • Data validation – Rules and Usage in Excel
  • Combining data validation with Indirect
  • Dynamic and Static drop-downs- role in dashboards
  • Count and Sum function discussion in detail
  • Use of Count IF and SUM IF functions from basic to advance with different examples
  • Use of COUNTIFS and SUMIFs and their advantage over Countif and Sumif
  • Use of wild characters like * and ?
  • Classwork files and assignments will be provided
  • My online or phone support 24*7 to answer your queries.

Reviews

There are no reviews yet.

Be the first to review “Advance Indirect function with Count & Sum family Functions – Chapter 3”