Getting Started With Excel.

Introduction

Microsoft Excel is a spreadsheet program developed by Microsoft that allows users to organize, calculate, format, and analyze data using grids of rows and columns. Rows are the horizontal lines in the Excel worksheet while columns are the vertical bars in the worksheet. Excel worksheet contains cells and ranges, A cell in a Microsoft excel worksheet is made by the intersection of rows and columns while a range is made up of two or a group of cells. Microsoft Excel also has a workbook that is made up by a group of worksheets. The rows are ordered in alphabets while the columns are ordered in numerical form.

Basics and cleaning in Microsoft Excel

Microsoft Excel contains a formula bar that helps display or edit contents in an excel worksheet. keying in data is done by clicking a cell and typing data that can be inform of texts, Numbers, and dates. To move to next cell press enter. Tabs i.e File, Home, Insert, Draw , Page layout etc.

Home tab

The Home tab can be used to expand the width of all columns for visibility of data in the cells by clicking Format and choosing Auto column width. Conditional formatting can be used to view values between a range ,greater than or less than depending on the information you want, or check on text that contains specific alphabets of your choice. You can also sort and filter your data which will enable you to standardize your data.

Data tab

this tab can be used to design scatter charts that looks at two numeric variables and also design a pivot table .Data validation is also possible in this tab to avoid inserting wrong data in your worksheet. In this section you can also remove duplicates to ensure standardization of data.

Other tabs

Insert is used to add tables and columns etc, Custom is used to pick color and font size. Filtering hides rows temporarily and without deleting them. Wrap texting is used to make long texts appear on multiple lines in the same cell.

Functions used in Excel

Arithmetic operators

The following signs are used in excel for Arithmetic analysis in Microsoft Excel; + is used for addition, - is used for subtraction, * is used for multiplication, / is used for division, ^ is used for exponent.

Statistical functions

These functions are used to summarize ,analyze and interpret data. They include :=COUNT which is used to count non-blank numeric cells, =COUNTA which is used to count all non-blank cells, =COUNTBLANK Which is used to count all blank cells.
Conditional aggregation functions are also used in Microsoft excel for various functions ,They include =COUNTIF which Counts cells that match a single rule or criteria while=COUNTIFS can check multiple conditions at the same time, =SUMIF add values based on a single condition, while =SUMIFS add values based on multiple conditions .=AVERAGEIF is used to calculate the average of a group of cells in a specific range.

Dispersion and spread functions.

These measures how far apart numbers are from average. They include;=POWER, =SQRT used to find square root, =PRODUCT used for multiplication purposes, =MIN used to find the minimum value in a range, =MAX used to find the maximum value in a range, =MODE which is used to find mode ,=MEDIAN ,=SUM,=AVERAGE.

Non-numerical functions

These functions are used in text columns. They include;

1. =LEN used to check on the length of texts
2. =RIGHT used to check on the letters on the right part of a text
3. =LEFT used to check on letters on the left part of a text
4. =TRIM used to trim texts
5. =MID used to check on the middle letters of a text
6. =FIND used to find specific letters on a text
7. =CONCATused to join words from different cells
8. =LOWER used to replace texts to lower case
9. =UPPER used to replace texts to upper case
10. =PROPER used to replace texts to proper case

Other non-numerical functions are also in relation to date , month and year. They include;

• =Today it shows the current date

• =Now it shows the current time

• =YEAR it shows the current year

• =MONTH it shows the current month

• =DAY
  To find difference between dates ,months and year ,the following functions can be used;

• =Datedif shows the difference between two dates in different cells

• =Monthdif shows difference in months

• =Yeardif shows the difference between years e.g difference of a hire year and the current year

• =Networkdays

Conclusion

In conclusion, mastering the basics of Microsoft Excel provides a foundational skillset for efficiently managing and understanding data. By learning how to navigate the grid, perform simple calculations, and use core functions like SUM or AVERAGE, users can instantly transform messy, manual tasks into organized, automated workflows. Ultimately, these basic features serve as the critical building blocks for anyone looking to build data literacy, save time, and unlock more advanced analytical tools in the future.