|
Note: This tutorial is based upon Microsoft Excel 2000. If you are using Excel 2002 some operations may look slightly different (e.g. pivot tables), but the same principles apply.
|
Excel tips for data management and analysis
This tutorial will explain Excel functions that are extremely useful when manipulating and analyzing large datasets, such as expenditures and coverage rates. It focuses on skills you can use to develop Financial Sustainability Plans as well to manage any spreadsheet-based data. The tutorial is organized in 2 sections:- Data management reviews advanced Excel functions that simplify data management and can help you avoid common mistakes during spreadsheet manipulations.
- Data analysis explains the Analysis ToolPak that you can install on your computer for easy data and statistical analysis.
To practice these functions as you work through the tutorial, download our sample Excel file, ExcelAdvanced.xls. using the link below.
|
.
