Section outline

    • Session 4 Managing Data in Excel

      In this session you will learn how to apply conditional formatting rules which provide an alternative way to visualise data and make worksheets easier to understand. 

      You will also learn about the Excel function Vlookup. 

      Moreover, you are going to see one of the most powerful Excel’s tools for managing and analysing data. 



    • Students must
      Mark as done


      Watch this video which provides an introduction to Managing Data in Microsoft Excel.



    • Topic 4: Managing Data in Excel Video Presentations Book
      Students must
      Mark as done

      To investigate the topic of Managing Data in more detail, now view the following video presentations which demonstrate  Conditional Formatting Rules, using the Vlookup Function, Pivot Tables and examples of the application of Pivot Tables in Excel.

    • Students must
      Mark as done

      Topic 4 Review: Managing Data

      After working through this session, you should now be able to: 

      • Set and manage a conditional formatting rule

      • Compute the Vlookup and Hlookup functions

      • Create a Pivot Table

      • Create a Pivot Chart