Contact Us
Feed Back Form
E-Mail
Us
Tel:
024 7637 2073
Contact Us |
Tel: |
|
To view course details please Click on the Course Title
in the table below |
Title |
Brief Description |
| Part 1 | More
than just a beginners course! Designing a Workbook from scratch. Over 20 different formulae and functions examined. Absolute and Relative addressing. Multiple Worksheets, cross referencing formulae, numerous Tips and Tricks. Cell protection. Documenting formulae. Printing. |
| Part 2 | Auto fill / Custom Lists / Auto formula / Styles / Charts / Lookup formula / Range names in formulae / Pivot reports / Macros / Database tables / Data sorts / Data entry forms / Conditional logic / Date calculations / Nesting functions. |
| Part 3 | Vertical Lookup tables / Subtotaling / Conditional Formatting / Applying Filters / Financial Functions / Goal Seeking / Solver / Scenarios / Data Tables / Conditional Sums / Import and Export. |
| Excel Workshop | 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. |
| VBA behind Excel |
For this 2 day course, no previous knowledge of VBA is required but
a good knowledge of Excel is Recommended |
To contact A.K.Solutions:- enquiries@aksolutions.co.uk |
|
Contact Us |
Tel: |
|
Copyright © 1994 - 2006 A.K.Solutions. All rights reserved. Revised: January 13, 2006. |
