Excel has changed my view on data and its analysis

Excel is a spreadsheet program that manipulates, graphs, and analyzes numeric data some of the Common uses for Excel are: budgets, grade books, address lists, or simple inventories. Some of my best and quickest features and formulas are
The Quick Access Toolbar which is a customizable shortcut menu to commonly used commands. It’s visible no matter which tab is selected.
The formula bar allows you to enter or edit data in the selected cell. Formulas and functions can also be entered
A column is the vertical line of cells from the top to the bottom of the page. Columns are alphabetized.
A row is the line of cells from the left to the right of the page. Rows are numbered
The Ribbon contains the commands. It has multiple tabs that have their own groups of commands. Some groups have an arrow at the bottom-right corner that will reveal more options once
The Name Box tells you the name/coordinates of the cell selected. Note how cell A1 is where column A and row 1 intersect.
If you are working with a large amount of data in your worksheet, sort and filter can make finding information faster. You can customize the order of your data alphabetically, numerically, by groups, and with multiple layers too.
There are many formulas available in Excel that you can use to work with data. Each formula in Excel begins with an equal sign. Before you create a formula, you’ll need to write an equal sign (=) in the cell where you want the formula’s result to appear.
On Excel, you can use functions to automate tasks you normally use in a formula. You can use the SUM function instead of using the plus sign to add a range of cells. Let’s go through a few popular functions:

1. SUM: The SUM function adds up a range of cells. To input the function, use parentheses to indicate the range of cells. If you are summing up the numbers in cell A1 through A17, your formula would be: =SUM (A1:A17).
2. AVERAGE: Similar to the SUM function, the AVERAGE function calculates the mean of the values of a range of cells. For example: =AVERAGE (A1:A17).
3. IF: With the IF function, you can ask Excel to return values based on a logical test. The syntax looks like: IF(logical test, value_if_true, [value_if_false]). For example: =IF(A1>B1,”Over Budget”,”OK”).