Intermediate Excel 2010/2013

Duration 2 Day
Unit Standard ID No Unit Standard Avaliable
Level 1

Course Objective

This course is designed for the user who wants to use advanced functions and manage data tables to sort, filter, summarize and create Pivot Tables and PivotCharts. Charts are covered in detail to graphically enhance data.

Prerequisite

Users should be working extensively in Excel on a daily basis, completing the Basic Excel course will be an added advantage.

Topics covered

  • Advanced Formula Techniques
    • Create Name Ranges, Use Relative and Absolute Addressing, Linking and using the Text to Columns Feature
    •  Understand Errors in formulas
  • More Functions
    • Use the Logical,  Financial, Text and Date and Time Functions
  • Advanced Formatting of Data
    • Use Conditional Formatting, Create Data Validation to restrict Data Users type of what is entered onto the Worksheet
  • Create and Manage Tables
    • Use the Form feature, Sort Table, Filter Data and Summarize Data
  • Create Pivot Tables and Pivot Charts to Analyse data
  •  Protecting of Worksheets and Workbooks
  • Hide and Unhide Rows and Columns and Worksheets
  • Charts
    • Create and Modify a Chart
    • Change the Chart Type and Layout of the Chart
    • Add Trendlines to the Chart
    • Change the Location of a Chart
    • Cells, Row to make entering of Data
  • Use the Graphics and Drawing features