![]() ![]() ![]() Make sure the Check Sum value in Data cell B2 is 95858 (90898 on Excel for Mac 2011). Look at the Data worksheet and Clean worksheet. If you use Excel for Windows 2010 or 2007, use this version: If you use Excel for Windows Office 365, 2016 or 2013, or Excel for Mac Office 365, 2016 or 2011, use the Unicode version: There are 2 versions of the workbook, depending on which version of Excel you are using. Follow the instructions carefully and answer the questions as you go.ĭownload and open the assignment workbook. ![]() Since your company will need to perform this analysis each month with new data, you are to use formulas to clean the data so that the workbook can be easily updated each month with new records from the database. The data is in a dirty format and you are required to clean it up in order to perform some analysis on it. You have received some sales data from your company’s database. Week 3 Final Assignment > Excel Skills for Business: Advancedġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |