Managing Data in Excel.

Frequency, COUNTIFS, MINIFS, MAXIFS, Names, Lists or drop-downs, Dependent Lists, Check-boxes

Course Summary

Learning Objectives of the Course:

  1. Summarize data by creating Range and Frequency Distributions
  2. Define Names in Excel to speed up and simplify processing on large spreadsheets
  3. Add controls such as checkboxes to make data input easy and error-free
  4. Increase speed and accuracy of data input using lists, and dependent lists

You will Learn

Summarize data by creating Range and Frequency Distributions:
  1. Summarize your data by creating frequency tables, using the inbuilt FREQUENCY function
  2. Create frequency tables or find out distribution for a specific range using the COUNTIFS formula
  3. Create data ranges using the new MINIFS and MAXIFS formulas
  4. Accelerate your work and minimize chances of errors by writing the COUNTIFS, MINIFS, and MAXIFS formulas using the dynamic array method
Define Names in Excel to speed up and simplify processing on large spreadsheets:
  1. Simplify writing formulas while working on large sheets
  2. Reduce complexities in collaborative working by writing easy to understand formulas
  3. Learn multiple methods to define Names
Add controls such as checkboxes to make data input easy and error-free:
  1. Access the Developer tab for adding control items to an Excel worksheet
  2. Add a control item, such as a checkbox
  3. Configure a control box to capture and process data as per need
Increase speed and accuracy of data input using lists, and dependent lists:
  1. Create lists using multiple methods
  2. Create dependent or dynamic lists
  3. BONUS: Quickly create lists or dependent lists with varying using a simple method
Person making a list of all features available with course

What all does the course include?

  • 7 Lecture videos + resource files
  • Personalized feedback on submission of assignment
  • Course Certificate on approval of assignment
  • Earn a badge on course completion
  • Direct link to add certificate in your LinkedIn Profile
  • Unlock invites to 2 LIVE sessions on course completion
  •  Discussion forum to clarify doubts from our experts

Course Curriculum

Course Pricing

  • One Time Fee
  • $14.99 USD

    Buy Now
  • Get immediate access
  • Assignment Included
  • Certificate & Badge
  •  

Music Credit: bensound.com