IT-ERA EXERCISE 9: Pivot Table and Pivot Chart
SALES TABLE LIST WORKBOOK Sales Person and Order Amount Region, Sales Person and Order Amount Sales Person, Month and Order amount
Posts
IT-ERA EXERCISE 8: Functions Sum , Average , If, Vlookup
FINAL OUTPUT DATA SSS FORMULA FINAL OUTPUT w/ FORMULAS
IT-ERA EXERCISE 7: Charts and Filters
{Make Charts} SORT BY ID# (Ascending) SORT BY NAME (Ascending) SORT BY LOAN AMOUNT (Descending) {Creating Subtotals} SUM BY LOAN AMOUNT SUBTOTALS BY ITEM TYPE {Filter by Item Type} ----------------------------------------------------------------------------------------------------------------------------- {Creating and Customizing Chart}
IT-ERA EXERCISE 6: Computing Sales Invoice and inventory of Supplies (EXCEL)
BUDGET & SUPPLIES FORMULAS ----------------------------------------------------------------------------------------------------------------------------- CUSOMER INVOICE FORMULAS