Nibi's Techπ MODULE 3: MICROSOFT EXCEL (DATA THINKING, FORMULAS & ANALYSIS)
3.1 INTRODUCTION TO MICROSOFT EXCEL
Microsoft Excel is a spreadsheet application developed by Microsoft used for organizing, calculating, and analysing data. Unlike Microsoft Word, which focuses on text, Excel is designed to work with numbers, structured data, and logical relationships between values.
At its core, Excel is a tool for thinking in data. Instead of writing sentences, you organize information into rows and columns, then apply formulas that allow the computer to perform automatic calculations and analysis.
Excel is widely used in schools, businesses, banks, hospitals, and research institutions because it helps users make sense of large amounts of information quickly and accurately.
3.2 UNDERSTANDING THE EXCEL WORKSPACE
When you open Excel, you see a grid made up of horizontal rows and vertical columns. The intersection of a row and a column is called a cell. Each cell has a unique address, such as A1, B2, or C5.
This structure is important because Excel does not βseeβ data as paragraphs like Word. Instead, it sees data as structured points in a grid system. Every calculation or analysis depends on referencing these cells correctly.
For example, if you type β50β in cell A1 and β20β in cell A2, Excel can use those positions to perform operations like addition, subtraction, or comparison.
The workspace also includes the formula bar, where you can view or edit what is inside a selected cell, especially formulas.
3.3 DATA ENTRY AND STRUCTURING INFORMATION
Data entry in Excel involves typing information into cells in an organized manner. Unlike Word, where spacing is flexible, Excel requires structure because each column and row represents a category or record.
For example, if you are tracking studentsβ scores:
This structured approach allows Excel to process and analyse information efficiently.
Good data entry habits are essential. Data should always be consistent, meaning similar types of information should be placed in the same column. Mixing different types of data in one column makes analysis difficult and leads to errors.
3.4 BASIC FORMULAS AND FUNCTIONS
Formulas are one of the most powerful features in Excel. A formula is an instruction that tells Excel to perform a calculation using values in cells.
All formulas in Excel begin with an equal sign (=). This tells Excel that what follows is a calculation, not normal text.
One of the simplest formulas is addition. For example, if A1 contains 10 and A2 contains 20, the formula =A1+A2 will return 30.
Excel also provides built-in functions, which are pre-written formulas designed for specific tasks.
Some important basic functions include:
These functions are widely used because they reduce manual calculation and improve accuracy.
3.5 LOGICAL THINKING IN EXCEL
Excel is not just about numbers; it is about logical decision-making. This means Excel can evaluate conditions and return results based on whether something is true or false.
For example, you can create a rule such as:
βIf a student scores above 50, they pass; otherwise, they fail.β
This is done using the IF function:
=IF(B2>50, "Pass", "Fail")
This introduces students to computational thinking, where decisions are based on conditions rather than manual judgment.
Logical thinking in Excel is important because it mirrors how computers make decisions in real-world systems like banking apps, grading systems, and automated reports.
3.6 WORKING WITH TABLES AND DATA FORMATTING
Tables in Excel help organize data in a clean and readable format. When data is converted into a table, Excel automatically adds filtering and sorting options.
Formatting is also important because it improves readability. For example, headings can be made bold, borders can be added around cells, and different background colors can be used to separate categories.
However, formatting should be functional, not decorative. The goal is clarity, not visual complexity.
A well-structured Excel sheet should always be easy to understand even without explanation.
3.7 CHARTS AND DATA VISUALIZATION
One of the most powerful features of Excel is its ability to convert raw data into visual charts. This is known as data visualization.
Instead of reading long rows of numbers, charts allow you to quickly understand patterns and trends.
For example:
Charts are especially useful because the human brain processes visuals faster than numbers. This makes Excel a powerful communication tool, not just a calculation tool.
3.8 REAL-WORLD APPLICATIONS OF EXCEL
Excel is used in many real-life situations because it simplifies complex data management.
In schools, it is used for grading systems, attendance tracking, and performance analysis. In businesses, it is used for budgeting, sales tracking, and financial reporting. In healthcare, it is used to manage patient records and statistics.
Even small businesses use Excel to track expenses and profits. This makes it an essential skill for anyone entering the digital world.
3.9 COMMON MISTAKES IN EXCEL
Many beginners struggle with Excel because they treat it like Word. One common mistake is entering unstructured data, which makes analysis difficult.
Another mistake is forgetting to use formulas and instead calculating manually, which defeats the purpose of Excel. Students also sometimes mix text and numbers in the same column, which can break formulas.