Microsoft Excel Level 2

Duration

1 day

Overview

This course is intended to extend the knowledge of delegates beyond the basics of Excel and into the realms of automation and customization.

Prerequisites

This course is tutor led and is aimed at delegates with a reasonable working knowledge of the basics of Microsoft Excel or who have attended the Excel level 1 course.

Objectives

On completion of the course delegates will be able to: 

·          Create and use Custom Lists

·          Use a variety of functions including:

o         Financial

o         Logical

o         Mathematical

o         Date and Time

o         Statistical

o         Lookup and Reference

·          Create and edit 3-dimensional formulae

·          Use Named Ranges

·          Use the Audit tools

·          Create and use Conditional Formatting

·          Incorporate Data Validation

·          Create and interrogate a database

·          Sort and Filter data

·          Create Subtotals

·          Create and use Scenarios

·          Use the Goal Seek feature

·          Create and edit a basic Pivot Table

·          Create a Date Table

·          Use worksheet Protection

·          Create and use Custom Charts

·          Create and assign basic macros