Microsoft Excel Workshop

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

To return to the Microsoft Excel Course Index please Click Here

A.K.Solutions: Microsoft Excel Workshop Course Content
This workshop is designed to show you examples from many of the functions and formulae available in Excel.  Including 'How to write your own User Defined Functions'.  Numerous tips and tricks with use of formatting codes and conditional formatting to obtain professional looking workbooks.  An ideal course for anybody who knows the basics but wants to understand more about the functions available and how to develop their own.  Involves some use of VBA (Visual Basic for applications) but no previous knowledge of VBA is required.

• Introduction

  • Navigation tips within a Worksheet

  • Timesaving Tips and Tricks on data entry

• Formulae

  • Examples of formulae

  • Reminder on Absolute and Relative Addressing

  • Some important rules about formulae

  • Cross-referencing formulae

  • Date calculations

  • Formatting results

  • Use of formatting placeholders

• Functions

  • Exploring Excel Functions

  • How to find the function you require

  • Use of Auto functions

  • Make sure you understand the syntax to best effect

  • Statistical functions

  • Logical functions

  • Lookup functions

  • Information functions

  • Financial functions

  • Mathematical and Trigonometry functions

  • Text functions

  • Date and Time functions

• VBA

  • Designing your own 'User defined Functions'

  • Testing the functions

• More on Formatting

  • Use of Custom formatting

  • Use of format codes

All is explained in an easy to understand way

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

All candidates are advised to have a basic working knowledge of Excel before taking this course.

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

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

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