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:

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

Next Lesson

Lesson 2.2 – Formatting Cells

Comments

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...

“This Sentence Is False”: The Liar Paradox, from Ancient Crete to Modern Code

“All Cretans are liars,” said the Cretan Epimenides. “This sentence is false,” echoes every logic textbook. We’re still arguing 2,600 years later—and the paradox is winning. _____________________________ / \ | “THIS SENTENCE IS FALSE.” | \_____________________________/ | | self-reference v +---------------------------+ | Truth flips back on | | itself — paradox loop! | +---------------------------+ 1. Meet the Liar The classic one-liner: L: “This sentence is false.” If L is true, then what it asserts—its own falsity—must hold, so L is false. If L is false, then what it asserts isn’t the ca...

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...

Big Data and AI

Search This Blog