Lesson 2.1 – Entering Data In this lesson, you will learn how to enter clean and structured data in Excel. Correct data entry is essential for accurate calculations, sorting, filtering, and all types of data analysis. Excel recognizes different types of data such as text, numbers, dates, and times, and each behaves differently inside the worksheet. 1. Entering Text Text is used for labels, names, categories, and descriptions. Excel aligns text to the left by default. Examples: Product A Customer Name Category To enter text, click a cell and type. Press Enter to confirm. 2. Entering Numbers Numbers are used for quantities, prices, percentages, and calculations. Excel aligns numbers to the right by default. Examples: 150 3.75 -20 Avoid adding spaces or symbols (except decimal separators), otherwise Excel may treat the value as text. 3. Entering Dates and Times Dates and times must follow a valid format...
Practical training for data analysts and rational investors. Guides on SQL, data analysis, ETL, and personal finance to make data-driven decisions.