Posts

IT-ERA EXERCISE 9: Pivot Table and Pivot Chart

Image
SALES TABLE LIST WORKBOOK Sales Person and Order Amount Region, Sales Person and Order Amount Sales Person, Month and Order amount

IT-ERA EXERCISE 8: Functions Sum , Average , If, Vlookup

Image
FINAL OUTPUT DATA SSS FORMULA FINAL OUTPUT w/ FORMULAS

IT-ERA EXERCISE 7: Charts and Filters

Image
{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)

Image
BUDGET & SUPPLIES FORMULAS ----------------------------------------------------------------------------------------------------------------------------- CUSOMER INVOICE FORMULAS

IT ERA: Bonus Points

Image
  https://youtu.be/6yfJ1olR9zg

IT ERA EXERCISE 4-5: Smart Art Graphics

Image
1. COVER   2. HEADER   3. FOOTER 4. PAGE NUMBER 5. HEADER 6. FOOTNOTE 7. INSTER CAPTION 8. TABLE OF FIGURES 9. INSERT CITATION 10. BIBLIOGRAPHY