Skip to main content

Lesson 2.1 – Entering Data

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 for Excel to recognize them. When entered correctly, they are stored as numeric values and aligned to the right.

Examples:

  • 12/03/2024
  • 2024-03-12
  • 14:30

If a date appears left-aligned, Excel is treating it as text.

4. Entering Formulas

Formulas always begin with an equal sign (=). Excel calculates the result automatically.

Examples:

  • =A1 + B1
  • =SUM(A1:A10)

Formulas appear in the Formula Bar, while the result appears in the cell.

5. Using the Formula Bar

The Formula Bar displays the content of the active cell. It is especially useful for editing long text or complex formulas.

Click a cell → edit in the Formula Bar → press Enter to confirm.

6. Avoiding Common Data Entry Errors

  • Do not add spaces before or after values.
  • Use consistent date formats.
  • Do not mix text and numbers in the same column.
  • Avoid using commas or symbols inside numeric values.

7. Practical Exercise

Complete the following steps to practice entering clean data:

  1. Create a worksheet named Lesson_2_1_Practice.
  2. In column A, enter five product names (text).
  3. In column B, enter five quantities (numbers).
  4. In column C, enter five dates in DD/MM/YYYY format.
  5. In column D, enter a simple formula (e.g., =B1*2).
  6. Check alignment: text left, numbers and dates right.

Next Lesson

Lesson 2.2 – Formatting Cells

Labels:

Comments

Post a Comment

Popular posts from this blog

Alfred Marshall – The Father of Modern Microeconomics

  Welcome back to the blog! Today we explore the life and legacy of Alfred Marshall (1842–1924) , the British economist who laid the foundations of modern microeconomics . His landmark book, Principles of Economics (1890), introduced core concepts like supply and demand , elasticity , and market equilibrium — ideas that continue to shape how we understand economics today. Who Was Alfred Marshall? Alfred Marshall was a professor at the University of Cambridge and a key figure in the development of neoclassical economics . He believed economics should be rigorous, mathematical, and practical , focusing on real-world issues like prices, wages, and consumer behavior. Marshall also emphasized that economics is ultimately about improving human well-being. Key Contributions 1. Supply and Demand Analysis Marshall was the first to clearly present supply and demand as intersecting curves on a graph. He showed how prices are determined by both what consumers are willing to pay (dem...
Post a Comment
Continue reading

Fundamental Analysis Case Study NVIDIA

  Executive summary NVIDIA is analyzed here using the full fundamental framework: balance sheet, income statement, cash flow statement, valuation multiples, sector comparison, sensitivity scenarios, and investment checklist. The company shows exceptional profitability, strong cash generation, conservative liquidity and net cash, and premium valuation multiples justified only if high growth and margin profiles persist. Key investment considerations are growth sustainability in data center and AI, margin durability, geopolitical and supply risks, and valuation sensitivity to execution. The detailed numerical work below uses the exact metrics you provided. Company profile and market context Business model and market position Company NVIDIA Corporation, leader in GPUs, AI accelerators, and related software platforms. Core revenue streams : data center GPUs and systems, gaming GPUs, professional visualization, automotive, software and services. Strategic advantage : GPU architecture, C...
Post a Comment
Continue reading

Behavioral Portfolio Theory (BPT) – Rethinking Investor Behavior and Portfolio Construction

  Traditional finance theories like Modern Portfolio Theory (MPT) assume that investors are perfectly rational and risk-averse, aiming to maximize utility by optimizing expected returns and variance. However, decades of research in behavioral finance have shown that investors often deviate from purely rational behavior. Behavioral Portfolio Theory (BPT) , introduced by Shefrin and Statman in 2000, offers a fresh perspective by integrating psychological and emotional factors into portfolio construction. What is Behavioral Portfolio Theory? Behavioral Portfolio Theory suggests that investors mentally segment their wealth into multiple “mental accounts” or layers, each with distinct goals, risk preferences, and expectations. Unlike MPT's single-layer approach focusing on an overall risk-return tradeoff, BPT models the portfolio as a layered pyramid , where each layer reflects different investor aspirations. For example: The bottom layer prioritizes capital preservation and safe...
Post a Comment
Continue reading