Microsoft Excel
Part 3

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

Home Page

To return to the Microsoft Excel Course Index please Click Here

A.K.Solutions: Microsoft Excel Part 3 Course Content
Vertical Lookup tables / Subtotaling / Conditional Formatting /  Applying Filters / Financial Functions / Goal Seeking /  Solver / Scenarios / Data Tables / Conditional Sums / Import and Export.

  • Financial Functions

  • Data Tables

  • More on Lookup Tables

  • Goal Seeking

  • Using Solver

  • Auditing Formulae

  • Freezing panes

  • Creating Scenario Reports

  • Sorting Data

  • Using a list as a Database

  • Using labels as Range Names

  • Commenting complex formulae

  • Subtotaling

  • Filtering Data

  • Conditional Formatting

  • Conditional Sums

  • Importing / Exporting data

You may print this page by selecting File Print in your Browser Window

Before taking this course.  All candidates are advised to have a good working knowledge of Excel basics including basic Functions and Formulae all of which are covered in Microsoft Excel Part 1

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

Go_Top

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

Home Page

Copyright © 1994 - 2006 A.K.Solutions. All rights reserved.   Revised: January 13, 2006.