Session Description:
Have you ever pulled a list from your database for further analysis in more depth only to find out that you forgot some key types of information in your lengthy output? Have you had trouble summarizing that same data quickly and efficiently or struggled to present this same data in a visual format that can draw out the obvious conclusions?
This session will describe and offer step-by-step instructions on how to use the following Excel tools: the "vlookup" formula, Pivot Tables, and Graphs/Charts. Each of these tools can help any Research Officer provide analysis for themselves or their clients that help provide thematic results that offer further strategies for fundraisers and other key staff.
Highlights:
-
How to create and use a vlookup formula in an excel spreadsheet
-
How to insert and manipulate a Pivot Table in order to summarize large volumes of data
-
How to create a chart to present data in a visual format (eg: pie chart, bar graph, etc.)