Microsoft Training Links for CSV

Here is a list of Microsoft training links on CSV so you know what to do with your report once it's in CSV:


Task

Training Link
CSV to Excel https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
Filter for Unique Values or Remove Duplicate Values https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
Filtering - Advanced https://support.office.com/en-us/article/filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b
Filtering/Sorting by Color https://support.office.com/en-us/article/Guidelines-and-examples-for-sorting-and-filtering-data-by-color-B1BF3982-051D-49B8-8330-80E99C94365B
Format as Table https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
MS Excel training https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home
Pivot Tables https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-A9A84538-BFE9-40A9-A8E9-F99134456576
Pivot Tables: Calculate https://support.office.com/en-us/article/Calculate-values-in-a-PivotTable-11f41417-da80-435c-a5c6-b0185e59da77
Pivot Tables: Design, Layout, Format https://support.office.com/en-us/article/Design-the-layout-and-format-of-a-PivotTable-a9600265-95bf-4900-868e-641133c05a80
Pivot Tables: Refresh https://support.office.com/en-us/article/Refresh-PivotTable-data-6D24CECE-A038-468A-8176-8B6568CA9BE2
Pivot Tables: Sort https://support.office.com/en-us/article/Sort-data-in-a-PivotTable-or-PivotChart-e41f7107-b92d-44ef-861f-24430830450a
Pivot Tables: Subtotal https://support.office.com/en-us/article/Subtotal-and-total-fields-in-a-PivotTable-173f5b30-b546-4293-87d2-aee638f74e7d
VLookup https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us