Excel 2007 Advanced

Afiniti

Short course

Inhouse

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

The aim of this course is to provide delegates with further practical experience of Microsoft Excel 2007. By the end of the course delegates will be able to manipulate data, charts, databases and security to an advanced level. Suitable for: existing users of Excel

About this course

Delegates should have a good knowledge of Excel 2007, gained through the attendance of an Excel 2007 one day intermediate course or through experience in the work place.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Core Topics

Viewing Worksheets

• Customising View Options

• Displaying & Customising Toolbars

• Hiding Workbooks & Worksheets

• Freezing Panes

• Grouping & Ungrouping Worksheets

More Formatting Techniques

• Using Styles

• Conditional Formatting

• Using The Format Painter

• Using Guidelines

• Hiding And Displaying Cells

More Formulae and Functions

• Using the Series Command

• Using the Insert Function Wizard

• IF Functions and VLOOKUP

• Using Excel Function Categories

• Correcting Formulas

• Using the Formula Error Checker

• Using the Formula Auditing Toolbar

• Using the Watch Window

Advanced Auditing & Manipulation

• Tracking precedants & dependants

• Auditing

• Goal Seek

• Scenario wizard

• Pivot Tables

Database & List Management

• Using Databases

• Creating and Editing A Database

• Sorting a Database

• Using Autofilters

• Advanced Filters

• Working With Filtered Data

• Using Data Forms

Charts

• Chart Wizard

• Chart Toolbar

• Working with Charts

• Formatting the Chart

Drawing & Picture Objects

• Drawing Toolbar

• Working with Autoshapes

• Creating Text Boxes

• Adding Pictures

• Layering Objects

• Grouping & Ungrouping Objects

Excel 2003 & other Applications

• Converting Files from Other Applications

• Copying Data from Another Application

• Embedding and Linking Objects

• Hyperlinks

• Managing Links

See related categories

Excel 2007 Advanced

Price on request

The best Excel courses

See all

See all