frequently used formulas and functions

Unit Outcomes:

  • Use the VLOOKUP function to find values.
  • Apply filtering to data.
  • Prepare data to convert charts.
  • Format a worksheet as a table.
  • Use the SUMIF and COUNTIF functions.
  • Create a Pivot Table.
  • Add a clustered bar pivot chart.

I attached the example data

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.