Ravindra BagaleCourses & study guides

2. Data Entry Tools

By Last updated:

Chala mitrano, aaj aapan data entry fast aani chuk-mukt kashi karaychi te shikuya. AutoFill, Flash Fill, data validation (डेटा वैधता – फक्त योग्य मूल्ये स्वीकारण्याचा नियम), drop-down lists aani conditional formatting – he tools vaparle ki data swachh yeto aani report madhe mahatvache aakde lagech distat. Chala suru karuya.

What you will learn in this module

  • AutoFill and Fill Series for numbers, dates and custom lists
  • Flash Fill to split and combine text by example
  • Data validation rules, input messages and error alerts
  • Drop-down lists, including a dependent City › Area drop-down
  • Conditional formatting: highlight rules, Top/Bottom, data bars, colour scales, icon sets and formula-based rules

Concepts in this chapter

  1. 2.1AutoFill and Fill Series
  2. 2.2Flash Fill
  3. 2.3Data Validation
  4. 2.4Drop-down Lists
  5. 2.5Dependent Drop-down: City › Area
  6. 2.6Conditional Formatting: Highlight Rules and Top/Bottom
  7. 2.7Data Bars, Color Scales and Icon Sets
  8. 2.8Formula-based Conditional Formatting

The chapter recap is at the end of the last concept page.