Project 1: Budget Projections
Let’s review and summarize a sample set of purchase orders for continuing resources to project serials budgets. For this project, we’ll format, sort, and filter our data. We’ll learn several ‘tricks’ to work more quickly in Excel. We’ll use Excel functions, sometimes also called formulas, to project inflation and to compare lists of purchase orders. We’ll use a pivot table to summarize our data.
What we'll learn: Excel vocabulary; basic formatting; sorting; filtering; basic pivot tables; basic calculations; functions: Xlookup(), IfError(), If(), combined functions.
