Excel Functions for Reformatting Data Files (CSV)

Most of the bulk management of courses, users, and enrollments requires CSV files with specific formatting. This Glossary contains several Excel functions and formulas you may find useful for manipulating your data into the appropriate format.

Browse the glossary using this index

Special | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ALL

P

Pivot tables

this data summarization tool can automatically sort and count data. If you have a list of enrollments including the course information for each one, a pivot table may be useful in generating a list of courses or checking enrollment numbers.