How To Use Excel Like A Pro:

Excel is such a lifesaver. It is commonly used in so many fields since everything is digital. Just by using formulas, simultaneous calculations are done within seconds. The collected data is of no use until it’s organized properly, excel is specifically made to organize. It is so COOL! Do check out Lio App

WHAT IS EXCEL USED FOR?

Excel is used to organize, analyze and store larger data. It is commonly used among accounting teams to manage wider data sets.

We don’t have to spend hours summing the amount and manually track the data. Excel has a shortcut to fix and speed up the process.

Excel basics:

If you already know the basics then just hold, and let others learn them too!

• Creating a new spreadsheet.
• Executing basic number crunching like addition, subtraction, multiplication, and division.
• Configuring text and titles in columns.
• Grouping your data in alphabetical order.

Excel formulae:

I know it’s very engulfing that it has a wide range of formulas but we’ll get through it.

• Addition: use the + sign between the cells to be summed.

Example: C4+D2.

• Subtraction: use the – sign between how many ever cells are to be subtracted.

Example: C4-D2.

• Multiplication: use the * sign between the cells to be multiplied.

Example: C4*D2.

• Division: use the / sign between the cells to be divided.

Example: C4/D2.

By using all these signs you can create a formula, for example: =(C4-D3)/((A6+B7)*6). Make sure to close the brackets.

Now it’s for the known peeps!

Excel shortcut keys:

1. To create a spreadsheet: Ctrl + N.
2. To open an existing spreadsheet: Ctrl + O.
3. To save a spreadsheet: Ctrl + S.
4. To close the current workbook/spreadsheet: Ctrl + W.
5. To close Excel: Ctrl + F4.
6. To shift to the next sheet: Ctrl + PageDown.
7. To go to the previous sheet: Ctrl + PageUp.
8. To go to the Data tab: Alt + A.

Excel tips:

• Use filter to facilitate your data.
• Add one or more rows and columns.
• Remove corresponding sets or data points.
• Inverse rows into columns.
• Divide text information between columns.
• Get the average of numbers in the cell.
• Use the IF excel formula to automize excel functions.
• Add a drop-down menu.
• Add checkboxes.
• Use the format painter.
• Use INDEX and MATCH formulae to pull data from horizontal columns. They work only from right to left.
• Use the VLOOKUP function to pull data from one place of a sheet to another. They work from left to right lookup.

This will be such a mess at the beginning but as I said you’ll get through it. Once you get a hold of the IF formulae, EXCEL is the one thing that you will never give up on.