Apply the skills you learned throughout this course to plan, design, and create a spreadsheet on your own that you would find useful in your everyday life, employment, or personal business. Examples include a travel budget, blood bank donor log, inventory records, household assets, or manage invoices, etc.
The project should include a variety of features learned in this course and aminimumof 6 columns and 8 rows. Refer to the Module Objective stated at the beginning of each module for assistance in determining what should be included in your spreadsheet.
The level of this project should include what you have learned and used in this course. Therefore it should include concepts, formulas/functions, formatting features (tables, pivot tables, sorts, etc.) that were introduced in Modules 5-8.
Formulas/Functions should include but not limited to VLOOKUP, DSUM, DCOUNTA, DAVERAGE, etc.
Plan, design, and create a spreadsheet on your own that you would find useful in your everyday life, employment, or personal business. Examples include a travel budget, blood bank donor log, inventory records, household assets, or manage invoices, etc. The project should include a variety of features learned in this course and a minimum of 6 columns and 8 rows. Refer to the Module Objective stated at the beginning of each module for assistance in determining what should be included in your spreadsheet. The level of this project should include what you have learned and used in this course. Therefore, it should include concepts, formulas/functions, formatting features (tables, pivot tables, sorts, etc.) that were introduced in Modules 5-8. Formulas/Functions should include but not limited to VLOOKUP, DSUM, DCOUNTA, DAVERAGE, etc. You will submit your workbook when you finish your project. You will also submit a Word document with the information below. Please include: Create and format a table, add and sort data table, use formulas in a table, filter a table, validate table data, (use sort & filter button, use remove duplicates button, Data validation, Module 5 Create a table, apply style to table, remove duplicate data, sort & filter button, use total row button, filter table, use LOOKUP function, use accounting format, use DAVERAGE function, use DSUM, DCOUNTA, Module 6 Protect worksheet and workbooks (use unlock, freeze, unfreeze, protect/unprotect) Save custom views of a worksheet, use hyperlinks, use screen tips, work with grouped/ungroup worksheets, use title cell styles, check compatibility. Module 7 Import a text file-use get&transform tool, delimite data, rename worksheets, use power query editor, use total, Link worksheet data to a word document, Link an excel chart to a PowerPoint slide, import excel data into access, insert a graphic file in a worksheet Module 8 Plan and design a PivotTable, change a PivotTable’s summary function and design, Filter PivotTable data using slicer, clear filters and remove slice., Explore PivotTable data relationship-Use GETPIVOTDATA function, create a PivotChart, use quick Layout, move chart to new worksheet, and name the worksheet. Update a Pivottable report, refresh values. PLEASE ALSO INCLUDE A STEP-BY-STEP INSTRUCTIONS FOR THIS PROJECT THAT WERE DONE IN COMPLETING IT.