Training Courses
We offer a comprehensive range of training programmes (from one-to-one tuition, to group training sessions). Click here for a full list of course / topics.
Each training course is customised to fully meet client requirements, with a maximum number of 8 delegates per course.
Training Courses
We offer a comprehensive range of training programmes (from one-to-one tuition, to group training sessions). Click here for a full list of course / topics.
Each training course is customised to fully meet client requirements, with a maximum number of 8 delegates per course.
Consultancy : Software Development
After attending a training course, clients often ask us to help in the development of particular software systems, that they would like to create e.g. employee training records (MS Access), project planning tools (MS Project), equipment maintenance (MS Excel) etc. A few examples are listed below ;
Microsoft Excel
Introduction - 1 Day
• What Is A Spreadsheet ?
• Entering / Formatting Data
• Opening / Saving Workbooks
• Copying / Pasting Data
• Increasing Column Width / Row Height
• Automatic / Keyboard Shortcuts
• AutoFill / AutoCorrect / AutoComplete
• Simple Formulae / Calculations
• Creating Graphs / Charts
• Printing Worksheets
• Cell Comments
Microsoft Excel
Intermediate - 1 Day
• Building Formulae
• Relative And Absolute References
• Splitting / Combining Cell Content
• Copying / Linking Worksheets & Workbooks
• IF / COUNTIF / VLOOKUP Functions
• Conditional Formatting - Basics
• Freeze Panes / Split Screen
• Sorting / Filtering Data
• Creating Pivot Tables
• Protecting Cells / Sheets
• Creating Nested Formulae
• Creating Combination Charts
Microsoft Excel
Advanced - 1 Day
• Named Ranges
• Advanced Sorting / Filtering Data
• Creating Complex Nested Formulae
• Data Validation
• SUMIF / DSUM / INDEX / MATCH Functions
• Conditional Formatting - Advanced
• Using Date Functions / Formulae
• Customising Ribbon / Tabs
• Pivot Tables - Advanced
• Macros – Creating / Modifying / VBA
Microsoft Excel
Excel VBA : User - 1 Day
• Introducing Visual Basic for Applications
• Recording / Running a Macro
• Editing a Macro in the Visual Basic Editor
• Creating a Standard Module
• Creating a Sub Procedure
• Declaring Variables
• Understanding Data Types
• Using Message Boxes
• Using Input Boxes
• Using the If...End If Decision Structures
• Using the Select Case Structure
• Using the Do...Loop Structure
• Using the For...Next Structure
• Error Trapping / Break Points
• Stepping Through a Procedure
Microsoft Excel
Excel VBA Professional - 1 Day
• Creating / Designing User Forms
• Filling UserForm Controls
• Filling a ListBox / ComboBox
• Validating User Inputs
• Option Buttons / Checkboxes
• Multi-Page Control
• Using Calendar Controls
• Passing Form Values Into Excel
• Creating Run Time Events
• Automatically Running Code
• Creating User Defined Functions
• Exchange Data With External Applications
Ideally, this course would allow time for the Users to develop their own Code, in a Spreadsheet, which they bring along to the training day.