Intermediate Excel - Learning more

Organizing data

     Advanced filter

    Sort by multiple columns

    Subtotal function

    Create an automatic form

     Working with large sheets of data

Special Features

   Custom Auto Fill

   Data validation

   Indirect function

   Related drop down lists

   Using the And Symbol

Manipulating data

   Vlookup

    Vookup with iferror

   If functions, nested if’s

More Manipulating Data

   If with and

   If with not and Or

   Index/match

   Create pivot table