Renée’s job entails using a company laptop to constantly open other peoples’ workbooks, sorting the data, importing a new sheet from CSV data, adding one row from the CSV file to the original spreadsheet, using Autosum to add across columns, then finally filling in the cells containing the final sums with a yellow color. This work generally has her using multiple tabs and takes a lot of time, and her keyboard doesn’t support hotkeys because of a mechanical error. How can she use Excel’s features to streamline her work? Explain the exact steps she should take.
