+

links

Microsoft excel users who are familiar with the basics of the program can learn how to streamline repetitive tasks and display spreadsheet data in more visually effective ways. 

In this course you will use Excel to enhance your work with templates, charts, graphics and formulas

Creating and Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-based Research Tools

Creating and Modifying Charts

Create a Chart

Format Chart Items

Change the Chart Type

Create a Diagram

Working with Graphic Objects

Insert Graphics

Create AutoShapes

Format Graphic Objects

Change the Order of Graphic Objects

Group Graphic Objects

Move, Copy, and Resize Graphic Objects

Calculating with Advanced Formulas

Create and Apply a Name for a Range of Cells

Calculate Across Worksheets

Calculate with Date and Time Functions

Calculate with Financial Functions

Calculate with Statistical Functions

Calculate with Lookup and Reference Functions

Calculate with Logical Functions

Sorting and Filtering Data

Sort Data Lists

Filter Data Lists

Create and Apply Advanced Filters

Calculate with Database Functions

Add Subtotals to a Worksheet

Using Excel with the Web

Export Excel Data

Publish a Worksheet to the Web

Import Data from the Web

Create a Web Query

Next Course

on application

£200.00 + VAT pp

One day course.

10.00am to 4.00pm

Refreshments and luncheon included.