- ## Introduction Excel is is a spreadsheet application that lets you organize, calculate, visualize and analyze data in grid of rows and column in a cell. Excel is usually the first tool people learn for organizing and studying data. ## Excel interface The Excel interface is everything you see on the screen when you open Excel — the layout of menus, buttons, and the grid where you enter your data. Here are its main parts:
Title bar — the strip at the very top showing the file name (e.g., "Book1 - Excel").
Ribbon — the row of tabs near the top (Home, Insert, Page Layout, Formulas, Data, Review, View, etc.). Each tab holds buttons for related tools — for example, the Home tab has formatting tools, and the Data tab has sorting and filtering tools.
Formula bar — the long bar just below the ribbon. It shows the actual content of a selected cell — including the formula, if there is one — not just the result displayed in the grid.
Name box — the small box to the left of the formula bar. It shows the address of the cell you've selected (like B4), and you can also type a cell address here to jump to it.
Worksheet grid — the main area made up of columns (labeled A, B, C…) and rows (labeled 1, 2, 3…). Where a column and row meet is called a cell, and each has its own address, like C7.
Sheet tabs — found at the bottom of the window. These let you switch between different worksheets in the same workbook (file).
Status bar — the thin strip at the very bottom. It can show quick info like the sum or average of selected cells, and lets you switch between view modes (Normal, Page Layout, etc.).
Knowing these basic parts is important because almost every instruction in Excel points back to one of them.
Basic skills: Formulas & Functions
Start with these:
=sum(range)-add up a group of numbers-=SUM(A1:A10)
=Average(range)-find the average of a group of numbers-AVERAGE(A1:A10)
=Min(range),=Max(range)-Min and Mix are used to find the smallest or largest number in a group of cells. Min gives you the lowest value, and Max gives you the highest.=MIN(A1:A10),MAX(A1:A10)
=COUNT(range) and =COUNTA(range). COUNT tells you how many cells in a range contain numbers, while COUNTA tells you how many cells are not empty at all, whether they contain numbers, words, or dates.=COUNT(A1:A10),=COUNTA(A1:A10)
=COUNTIF(range), which counts how many cells match a specific condition you set.=COUNTIF(A1:A10)
Data Cleaning
Data cleaning is the process of detecting, Correcting, or removing inaccurate, incomplete, inconsistent, duplicated or irrelevant data from a dataset so that it becomes reliable and usable for analysis and reporting. The main goal of data cleaning is to ensure accuracy, completeness, consistency, validity and uniformity.
Text cleaning
Text problems: wrong spacing, wrong capital letters, spelling mistakes, or the same word written in different ways.
=PROPER(A2)-Marking each word start with a capital letter.
=UPPER(A2)-Makes all letters capital.
=LOWER(A2)-Makes all letters small.
- Select the column
- Go to the Home tab and click Filter.
- Click the filter arrow to see the different values in the column. In our example, we can see the names are typed in different letter cases (some lower case, some upper case, some mixed).
- Once you see the problem, add a new column next to it. Use the PROPER function (example: =PROPER(B2)) to fix the names so they all start with a capital letter, in a consistent way.
Find and replace, this is handy for cleaning data — for example, fixing a consistently misspelled name, replacing a symbol, or updating a value that appears many times in your sheet. use CTRL + H ,the click on replace all.
Numeric data cleaning
Numeric data cleaning fixes problems in number columns like salary, age, quantity, or price, so the numbers can actually be calculated with summed, averaged,etc
Conclusion
Excel is a simple but powerful tool for cleaning data. Features like removing duplicates, fixing missing values, and correcting formats help turn messy data into clean, organized data. This makes the data easier to understand and use for analysis. In short, good data cleaning in Excel leads to better and more accurate results.
Top comments (0)