• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

Quantitative data is explicit, specific, and exact. To be able to turn that data into knowledge that leads to actionable decisions, however, you need to understand what that information means for your organization. To do that, you have to be able to select the right information, summarize it, and analyze it to get to the answers you need, usually using Excel. Excel is an extremely useful tool for the knowledge worker. You can easily create simple worksheets with minimal instruction, or perform sophisticated analyses in a wide variety of business situations.

Checklist for Creating Knowledge with Numbers

The following skills are ones that will help you use Excel to analyze data to produce meaningful knowledge.

  • Sort an Excel database by one or more fields.

  • Filter an Excel database to show the specific records you need.

  • Subtotal your database to display groups and counts of related records, and subtotals of numeric data.

  • Create formulas that refer to absolute and relative cell addresses, and use parentheses to specify the calculation order.

  • Use functions in fields appropriate to your work, such as financial or statistical functions.

  • Create cross tab and summary tables with PivotTable Reports.

  • Create scenarios and use Goal Seek to solve what-if problems.

  • Project trends for your data.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint