Member-only story
Hello everyone!
Today, we will see about Excel. Excel is a powerful spreadsheet used for analysis, visual representation, accounting, etc.
An Excel has rows and columns. Rows are numbered and columns are named alphabetically. The intersection of a row and column is a cell. Generally, column name should come first followed by row number. For example, A1, C11, etc.
Click on a cell and type the data, then give enter to move to the next cell. Double-click the cell to edit the data entered.
You can do any basic formulas by giving the ‘=’ sign. Eg: =A1+B1 in a cell and give enter. Addition(+), Subtraction(-), Multiplication(*), and Division(/) all these are basics in excel.
We can perform advanced calculations like sum, avg, etc. These are pre-built functions. Each function will have its parameters, so after typing the function name open parenthesis and fill in the parameters.
Formatting is possible by adjusting cell colour, text font, number format, etc. Right-click on a cell or use the ribbon at the top of the Excel window to access formatting options.
The topmost bar is the title bar, the next one is the menu bar, and then we have the toolbar, and at the bottom, we have the status bar.
