Subjects covered in this course include:

•    Working    with    VLOOKUP

•    Linking    cells    between    Excel    tabs

•    Templates

•    PivotTable    and    PivotChart    basics

•    Drop-down    menus    in    cells

•    Working    with    SUMIF    and    COUNTIF

•    Sorting    in    depth

•    Filtering    in    depth

•    Naming    cells

•    Calculating    with    dates

•    Absolute    referencing

•    Working    with    SUBTOTAL

•    Protecting    worksheets

•    Logic    tests    (eg:    IF,    AND,    OR)

•    Conditional    formatting

•    Print    area,    page    breaks    and    page    scaling

and much more including our T7 Tips and Tricks section.

Is this course for me? Before    enrolling    into    this    course,    you    must    be    comfortable    and    familiar    with    the    skills    covered    in    Excel Basics    such    as    SUM    and    AVERAGE    formulas,    correct    data    structure,    sorting    data,    creating    charts    and    filtering    data.        If    you    are    not    familiar    with    these    skills,    you    will    need    to    attend    and    complete    Excel Basics   prior to attending Excel Intermediate .  This course is ideal for analysing large blocks of data.