Data Analysis [MS Excel]

Data Analysis `{`MS EXCEL`}`

Uses for Microsoft ExcelMicrosoft Excel is a spreadsheet program. That means it’s used to create grids of text, numbers and formulas specifying calculations. That’s extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

How to Make a Spreadsheet in Excel
  1. Open Excel.
  2. Notice there are rows and columns. Each column has a capital letter on the top to show what column it is. …
  3. Click cell A1 and type: Item.
  4. Click cell B1 and type: Cost.
  5. Click cell A2 and type: Printing.
  6. Click in cell B2 and type 80.00. …
  7. Click cell A3 and type: Postage.
  8. Click cell B3 and type: 75.55.
Career Information for Jobs that Require Excel Skills
  • Administrative Assistant. Administrative assistants are responsible for helping the organization they work for run smoothly by completing a variety of different tasks. …
  • Information Clerk. …
  • Accountants and Auditors. …
  • Cost Estimator. …
  • Financial Analyst. …
  • Sales Manager.
Uses for Microsoft Excel. Microsoft Excel is a spreadsheet program. That means it’s used to create grids of text, numbers and formulas specifying calculations. That’s extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.
Here are five of the top features and benefits of Microsoft Excel:
  • Build great charts. Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells. …
  • Use conditional formatting. …
  • Help identify trends. …
  • Bring data together. …
  • Online access