Home Schedule
27 Oct 2025 - Data formatting 03 Nov 2025 - Data manipulation 10 Nov 2025 - Data visualization 17 Nov 2025 - Relational databases
Monday Lecture Wednesday Recitation Friday Recitation
data manipulation preps sorting filtering pivot tables
Canvas Syllabus Contact Options Last Updated on

Tools for Information Literacy ⑫ Data control

Glance over these items to prepare yourselves for the data manipulation session

We will consider how to use Excel as a database tool

First - you may need to clean your data before you can effectively manipulate it

But, knowing that, we can still use Excel for to manipulate data

glance over How to Create a Database in Excel

Other items relevant to today's class

    1. The amazing FILTER function
    2. 10 Things You Should NEVER DO in Excel
    3. How to Make Sortable Headings in Excel
    4. Excel Pivot Tables Explained
    5. and many others
back to top