excel worksheet project

/in /by

Complete an excel project on Cengage I will let you know the email and password once you accept the question. Here are some things you are expected to know to complete the project. If you get a good grade I will not hesitate to give a great tip. Let me know if you have any questions.

  1. Run and Edit a Macro
  2. Insert a Button (Form Control) button and Edit.
  3. Assign a macro to a new button.
  4. Create a data validation rule. Create an input message. Create a Stop style error alert.
  5. Identify and correct any invalid values.
  6. Enter a formula using the COUNTIF function, SUMIF function, AVERAGEIF function.
  7. Create a formula using the DCOUNT function, DSUM function
  8. Created a PivotTable and Edit
  9. Insert a Timeline Slicer
  10. Insert a formula using the GETPIVOTDATA function
  11. Insert a calculated field in PivotTable and Edit.
  12. Create a PivotChart
  13. Create a query and load data from a CSV file.
  14. Import the data from the Access database and insert a PivotTable.
  15. Insert and format WordArt
  16. Use the Error Checking command to identify the error in a cell.
  17. Enter a formula using the CUMIPMT function, CUMPRINC function, SLN function, DB function, SYD function, NPV function, IRR function
  18. Add a Trendline.