Instructor's MS office tips
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training Sitemap add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version 		Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Posts by Stephen (trainer)

Active questions (69)
Advanced/consultancy questions (6)
Today's questions
Unanswered questions (13)

See also: Hints and tips

Bookmark This PageBookmark this page

Version 2.0

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Contributer acheivements

bronze contributer Bronze: 25 posts
silver contributer Silver: 50 posts
gold contributer Gold: 100 posts
platinum contributer Platinum: 500 posts
diamond contributer Diamond: 1000 posts

Posts by Stephen (trainer)

8 active questions allocated to this trainer

RepliesDateAppTitle
02010 Jul 30Error 400
I'm trying to create a pivot table from a static piece of data and whe
02010 Jul 30Referencing a workbook containing VBA
Hello, I tried to apply what we learned at the beginning of the wee
12010 Jul 27Building Forms
I attended VBA Introduction-Intermediate training programme last week;
02010 Jul 27Working with Outlook
Is it possible to specify the sender of the email (i.e. if you have ac
22010 Jul 26Excel VBA - Open sheet within current workbook
Good Afternoon I was told during the VBA Advanced course today that
12010 Jul 23Tanya
how do you fix a $ signs?
12010 Jul 22Nested fuctions
I was learning to do some nested functions and was applying this to a
22010 Jul 20VBA chart range
Please I will glad if you help me with this problem, how can i use VBA

Entire post history

platinum contributer[825 posts]

DateTitle
2010 Jul 28RE: Tanya
2010 Jul 28RE: Excel VBA - Open sheet within current workbook
2010 Jul 28RE: Building Forms
2010 Jul 22RE: Nested fuctions
2010 Jul 22RE: Inserting a new row in a particular place
2010 Jul 22RE: Field Size
2010 Jul 22RE: Field Size
2010 Jul 22RE: VBA chart range
2010 Jul 20RE: sorting data
2010 Jul 16RE: conditional formatting
2010 Jul 16RE: ODBC drivers
2010 Jul 15RE: Variable
2010 Jul 15RE: vba
2010 Jul 15RE: VBA Copy cell format to destination cell
2010 Jul 13RE: conditional formatting
2010 Jul 1RE: Backward compatibility
2010 Jul 1RE: Function using IF AND
2010 Jul 1RE: Slow worksheets after upgrade?
2010 Jul 1RE: Format Painting
2010 Jun 30RE: Function using IF AND
2010 Jun 30RE: SHAPES/OBJECTS NUMBERING
2010 Jun 21RE: Maximising
2010 Jun 16RE: Linking headers to a cell value
2010 Jun 16RE: Slow worksheets after upgrade?
2010 Jun 14RE: Running a Macro from another spreadsheet
2010 Jun 9RE: Format Painting
2010 Jun 9RE: Running a Macro from another spreadsheet
2010 May 26RE: Currency Conversion in Excel
2010 May 21RE: ACCESS
2010 May 21RE: MS Access/Excel
2010 May 21RE: access data page
2010 May 21RE: Deleting Duplicated Data
2010 May 21RE: Excel VBA Find Method (CTRL + F)
2010 May 13RE: functions
2010 May 11RE: Formatting
2010 May 6RE: Excel - Data Sorting
2010 May 6RE: Copy whole worksheet
2010 May 6RE: calendar control
2010 May 5RE: Button to hide/show rows
2010 Apr 27RE: Access VBA Combo Box
2010 Apr 22RE: MS Excel
2010 Apr 22RE: Offset function and formulas
2010 Apr 21RE: Combo Boxes
2010 Apr 21RE: Combo Boxes
2010 Apr 21RE: Combo Boxes
2010 Apr 21RE: Deleting rows of Data
2010 Apr 21RE: calendar control
2010 Apr 21RE: Combo Boxes
2010 Apr 20RE: Comments box
2010 Apr 12RE: Formatting Cell colour of columns
2010 Apr 12RE: Problems setting a user defined primary key
2010 Apr 6RE: Excel VBA
2010 Apr 6RE: Deleting rows of Data
2010 Apr 6RE: Excel v Access
2010 Apr 6RE: Sharing Excel files
2010 Apr 6RE: Multiselect from list in data validation
2010 Mar 31RE: Access 2007 VBA Coding and Backward Compatibility
2010 Mar 29RE: Background colour on report depending upon certain text in a
2010 Mar 29RE: Access CloseButton
2010 Mar 29RE: Concatenate in VBA
2010 Mar 29RE: Excel VBA
2010 Mar 29RE: VBA
2010 Mar 26RE: Deleting rows of Data
2010 Mar 22RE: Access CloseButton
2010 Mar 22RE: User Form Windows
2010 Mar 22RE: Pivot Table unhide/show Grand total column
2010 Mar 22RE: Background colour on report depending upon certain text in a
2010 Mar 22RE: access
2010 Mar 22RE: acces 2003
2010 Mar 22RE: Study material
2010 Mar 18RE: Access CloseButton
2010 Mar 18RE: Fixing equations in linked sheets
2010 Mar 17RE: Open event
2010 Mar 17RE: Excel VBA switching between workbooks
2010 Mar 17RE: lookup relative to sheet name
2010 Mar 17RE: combo boxes in forms and spreadsheets
2010 Mar 16RE: Countif
2010 Mar 11RE: Excel VBA switching between workbooks
2010 Mar 10RE: Excel
2010 Mar 10RE: Access 2003
2010 Mar 10RE: counting field values
2010 Mar 10RE: ACCESS DATABASE
2010 Mar 4RE: validation rule?
2010 Mar 4RE: Pivot Table Sources
2010 Mar 3RE: Access VBA Dates
2010 Mar 3RE: Charts Formatting
2010 Mar 3RE: Dates Changing in Access
2010 Mar 3RE: Date format activex calendar
2010 Mar 3RE: Pivot Table Field Grouping
2010 Mar 3RE: how to copy autofilter data
2010 Mar 3RE: VBA conditional formatting
2010 Mar 3RE: VBA conditional formatting
2010 Mar 3RE: VBA code as a template
2010 Mar 1RE: Making a table from a query which involves the calculation o
2010 Mar 1RE: pmt formulaes and IFs
2010 Feb 24RE: Relationships
2010 Feb 24RE: Excel VBA variable type
2010 Feb 24RE: Sorts
2010 Feb 24RE: Search form with search button
2010 Feb 24RE: Join queries - position of tables
2010 Feb 23RE: Formulas
2010 Feb 23RE: Consolidating data in excel 2007
2010 Feb 23RE: Crosstab query
2010 Feb 23RE: End of a record
2010 Feb 23RE: data formating
2010 Feb 23RE: Counting in reports
2010 Feb 23RE: Dates Changing in Access
2010 Feb 23RE: Date format activex calendar
2010 Feb 23RE: Access VBA Dates
2010 Feb 23RE: Linking Excel Files as Tables in Access
2010 Feb 18RE: Pivot tables
2010 Feb 17RE: Outlook security settings
2010 Feb 17RE: Outlook Security Setting
2010 Feb 17RE: Creating a Public variable Excel 2007
2010 Feb 17RE: Multiple spreadsheets
2010 Feb 17RE: pivot tables
2010 Feb 17RE: Excel 2007
2010 Feb 17RE: Copying down formulas
2010 Feb 17RE: MsgBox
2010 Feb 17RE: charts in excel
2010 Feb 17RE: custom functions
2010 Feb 17RE: Excel VBA - code protection from users
2010 Feb 17RE: Creating a Public variable Excel 2007
2010 Feb 17RE: Excel VBA
2010 Feb 17RE: Outlook Security Setting
2010 Feb 17RE: Outlook security settings
2010 Feb 12RE: Copying Records
2010 Feb 12RE: MsProject
2010 Feb 12RE: Charts Formatting
2010 Feb 12RE: Copying data
2010 Feb 12RE: Auto populate fields
2010 Feb 10RE: MsgBox
2010 Feb 5RE: Character formatting
2010 Feb 5RE: Cells
2010 Feb 5RE: charts in excel
2010 Feb 5RE: Change in list details for data validation
2010 Feb 5RE: PIVOT TABLES
2010 Feb 4RE: Creating a query in MS Access
2010 Feb 1RE: Pivot Charts in queries
2010 Jan 27RE: Application.Filesearch
2010 Jan 27RE: VBA insert rows
2010 Jan 24RE: Excel
2010 Jan 24RE: Extending Named Range
2010 Jan 24RE: Combo Box - display
2010 Jan 20RE: Excel
2010 Jan 20RE: VBA insert rows
2010 Jan 15RE: VBA Code - Working with multiple files
2010 Jan 13RE: Personal.XSLB
2010 Jan 11RE: Disabling record additions in query results
2010 Jan 11RE: access vba code
2010 Jan 11RE: Access VBA
2010 Jan 11RE: Microsoft Access 2003 VBA
2010 Jan 8RE: pivot table - data format issues
2010 Jan 7RE: pivot table - data format issues
2010 Jan 6RE: vba
2010 Jan 5RE: Finding Current Address
2009 Dec 31RE: VALIDATION IN EXCEL VBA
2009 Dec 29RE: Excel
2009 Dec 18RE: VBA Row Function
2009 Dec 17RE: Age Calculator
2009 Dec 17RE: Formatting
2009 Dec 17RE: Macro
2009 Dec 17RE: LIST BOX TO STORE VALUES
2009 Dec 17RE: VBA
2009 Dec 14RE: LIST BOX TO STORE VALUES
2009 Dec 11RE: Find particular records
2009 Dec 11RE: The database engine could not lock table (table name) becaus
2009 Dec 8RE: Excel 2003
2009 Dec 8RE: excel sheet protection
2009 Dec 1RE: Macro's
2009 Dec 1RE: Exchange rates
2009 Nov 27RE: Pivot Tables and Calculated Fields
2009 Nov 27RE: Autofilter
2009 Nov 26RE: A quick Macro
2009 Nov 25RE: printing
2009 Nov 25RE: Picking out one word from a phrase
2009 Nov 25RE: Copy paste from People soft
2009 Nov 25RE: A quick Macro
2009 Nov 24RE: Sumproduct - counting distinct values in two columns
2009 Nov 24RE: MS Access VBA
2009 Nov 24RE: Logical Functions (i think)
2009 Nov 24RE: Excel - Cell Formatting
2009 Nov 24RE: Excel - Cell Formatting
2009 Nov 24RE: e-mail and websites
2009 Nov 24RE: excel vba (macro)
2009 Nov 22RE: functions
2009 Nov 22RE: Compact and Repair
2009 Nov 22RE: Printing Excel to PDF
2009 Nov 22RE: Excel Bug: Huge left blue margin after big macro
2009 Nov 22RE: Combo box on sub form
2009 Nov 19RE: Connection to an acess database
2009 Nov 19RE: Call Stack
2009 Nov 19RE: Pivot Tables Calculations
2009 Nov 19RE: Excel - Formula
2009 Nov 17RE: Cross tabs
2009 Nov 17RE: replacing data
2009 Nov 12RE: Working with the Outlook application
2009 Nov 4RE: Combo box on sub form
2009 Nov 2RE: Switch Clearing
2009 Oct 30RE: Functions in VBA
2009 Oct 30RE: Help with a comparing query
2009 Oct 29RE: Connecting to an MS Access DB over WEBDAV in excel
2009 Oct 29RE: Unprotecting a spreadsheet
2009 Oct 28RE: Help with a comparing query
2009 Oct 28RE: Web Query
2009 Oct 28RE: VBA Access and VBA Excel on the web
2009 Oct 26RE: working days formula
2009 Oct 26RE: Viewing a form
2009 Oct 26RE: Microsoft Advanced Access - 2003
2009 Oct 26RE: access VBA
2009 Oct 23RE: Excel 2007 VBA code
2009 Oct 23RE: Entering Data on a form
2009 Oct 23RE: Excel 2007 VBA code
2009 Oct 23RE: Access VBA
2009 Oct 23RE: Macros
2009 Oct 23RE: Query Building
2009 Oct 20RE: Combo Boxes - Form Design
2009 Oct 20RE: Acces Report Layout
2009 Oct 19RE: Access
2009 Oct 12RE: Access forms/subforms
2009 Oct 12RE: Converting Dates in a CSV file for Stephen
2009 Oct 12RE: Excel Formulas
2009 Oct 12RE: 3D bar charts
2009 Oct 1RE: Printing Excel to PDF
2009 Oct 1RE: Creating a Graph in VBA for Excel
2009 Sep 30RE: Excel Bug: Huge left blue margin after big macro
2009 Sep 30RE: Compact and Repair
2009 Sep 30RE: Access VBA
2009 Sep 25RE: Calling a sub name into the current sub
2009 Sep 25RE: For/Next Do/Loop - Step Functions
2009 Sep 24RE: Printing
2009 Sep 24RE: Calling a sub name into the current sub
2009 Sep 24RE: Macros
2009 Sep 24RE: Printing out VBA code in colour
2009 Sep 23RE: repayments
2009 Sep 23RE: Linking Excel and pdf
2009 Sep 22RE: dates in VBA
2009 Sep 22RE: print file using macro
2009 Sep 17RE: File size
2009 Sep 17RE: File size
2009 Sep 17RE: Cartesian Queries
2009 Sep 17RE: Closing Workbooks
2009 Sep 17RE: VBA
2009 Sep 17RE: Run Time Error 1004
2009 Sep 17RE: SQL
2009 Sep 17RE: microsoft excel
2009 Sep 17RE: Dynamic lists in Excel Combo Boxes
2009 Sep 17RE: Change colour of text
2009 Sep 17RE: pivot tables
2009 Sep 17RE: Printing
2009 Sep 17RE: Formating Dates on a previously created document
2009 Sep 17RE: Problems with SQL statements in VBA dealing with filtering.
2009 Sep 11RE: Project duration
2009 Sep 11RE: Project Course
2009 Sep 11RE: Project
2009 Sep 11RE: project
2009 Sep 11RE: Access Forms
2009 Sep 11RE: Crosstab Query
2009 Sep 11RE: Importing Data from Excel
2009 Sep 11RE: MS Project
2009 Sep 11RE: Conversion of Access 97 to Access 2003 and 2007
2009 Sep 10RE: File size
2009 Sep 10RE: Cartesian Queries
2009 Sep 7RE: Closing Workbooks
2009 Sep 7RE: Run Time Error 1004
2009 Sep 4RE: VBA - Conditional Formatting
2009 Sep 1RE: Macro visibility
2009 Sep 1RE: VBA 2007
2009 Aug 28RE: SQL statement - syntax for filtering by multiple fields
2009 Aug 28RE: functions
2009 Aug 25RE: Filtering & sorting a table while accessing it
2009 Aug 21RE: Adding additional items to a macro
2009 Aug 20RE: Currency symbols
2009 Aug 20RE: Union Queries
2009 Aug 20RE: VBA - Identifying object names
2009 Aug 20RE: Filtering an entire workbook
2009 Aug 17RE: VBA
2009 Aug 14RE: microsoft excel
2009 Aug 7RE: Update Tasks & Tracking
2009 Aug 7RE: VBA
2009 Aug 7RE: Weighted averages
2009 Jul 24RE: Functions
2009 Jul 24RE: Variables
2009 Jul 24RE: General
2009 Jul 23RE: Access Training
2009 Jul 23RE: SQL
2009 Jul 23RE: class modules
2009 Jul 20RE: Access Training
2009 Jul 20RE: Accessing Hyperion add-in
2009 Jul 20RE: Dynamic lists in Excel Combo Boxes
2009 Jul 20RE: Formulas
2009 Jul 20RE: Finding the average length of service
2009 Jul 20RE: Circular References
2009 Jul 20RE: Creating a Macro to Print Screen
2009 Jul 20RE: Hyperlinks
2009 Jul 20RE: Accessing Hyperion add-in
2009 Jul 20RE: VBA
2009 Jul 20RE: Access 2003 to Word
2009 Jul 17RE: Access stability for large DBs
2009 Jul 3RE: Pivot Tables
2009 Jul 3RE: Accessing Hyperion add-in
2009 Jul 1RE: VBA
2009 Jul 1RE: Combo Boxes / Navigation
2009 Jul 1RE: Time that macro takes to run increases each time.
2009 Jun 26RE: Check Boxes
2009 Jun 25RE: Formulae in Excel
2009 Jun 24RE: VBA Excel: Toggle individual objects on and off
2009 Jun 23RE: VBA
2009 Jun 22RE: Cash Flow Modelling
2009 Jun 12RE: Importing information from Access to Excel
2009 Jun 10RE: Access VBA
2009 Jun 10RE: Check Boxes
2009 Jun 2RE: validation lists
2009 Jun 1RE: Forms
2009 May 26RE: Update Query
2009 May 26RE: Pivot Tables
2009 May 26RE: Excel VBA: Declare statement to reference an external proced
2009 May 26RE: Excel - all versions
2009 May 21RE: Printing
2009 May 21RE: Circular References
2009 May 21RE: Traffic lights
2009 May 19RE: Finding the average length of service
2009 May 18RE: Resourcing #2
2009 May 18RE: Resourcing #1
2009 May 18RE: Pivot tables
2009 May 18RE: VBA
2009 May 18RE: Refresh External Data using VBA
2009 May 18RE: Using a menu for report printing
2009 May 18RE: Forms
2009 May 18RE: VBA
2009 May 18RE: functions
2009 May 18RE: VBA Variables
2009 May 15RE: Visual basic
2009 May 14RE: Access
2009 May 14RE: Access
2009 May 14RE: Processing Speed
2009 May 13RE: Run-time error 2176
2009 May 13RE: Coding conventions and project structure conventions
2009 May 11RE: VBA
2009 May 11RE: Access VBA
2009 May 11RE: Printing Forms
2009 May 11RE: Project Custom Reports
2009 May 11RE: Combining projects
2009 May 11RE: Using VBA to change a data type
2009 May 7RE: Refresh External Data using VBA
2009 May 7RE: Excel VBA
2009 Apr 24RE: Linking tasks in Project 2007
2009 Apr 22RE: vlookup
2009 Apr 22RE: Reports
2009 Apr 22RE: Reports
2009 Apr 22RE: Payment schedule (PMT) repayment vs interest only mortgage
2009 Apr 22RE: Formulas
2009 Apr 17RE: V-lookup
2009 Apr 17RE: Naming Cell Ranges
2009 Apr 17RE: Cache Index
2009 Apr 17RE: Formulas
2009 Apr 17RE: pivotcharts
2009 Apr 17RE: Select first cell of a range
2009 Apr 13RE: Macro to reset drop down list
2009 Apr 13RE: Saving document in excel
2009 Apr 13RE: rtr interface
2009 Apr 13RE: sub totalling
2009 Apr 13RE: VBA libraryies
2009 Apr 9RE: SS, SF, FF
2009 Apr 9RE: Front Page
2009 Apr 9RE: Pivots
2009 Apr 9RE: Dynamic lists in Excel Combo Boxes
2009 Apr 9RE: input box
2009 Apr 9RE: VBA in Excel 2007
2009 Mar 26RE: Macros
2009 Mar 26RE: Countif formulas and contains criteria
2009 Mar 25RE: Countif formulas and contains criteria
2009 Mar 24RE: Access 2000
2009 Mar 24RE: Queries
2009 Mar 24RE: Logical Functions
2009 Mar 24RE: Data formatting
2009 Mar 24RE: days & dates
2009 Mar 23RE: Logical Functions
2009 Mar 23RE: resources
2009 Mar 23RE: EXCEL
2009 Mar 23RE: V look ups
2009 Mar 23RE: Formating cells
2009 Mar 23RE: formatting
2009 Mar 23RE: Example for pivot table question.
2009 Mar 23RE: Pivot tables
2009 Mar 23RE: Excel
2009 Mar 20RE: VBA
2009 Mar 20RE: Variables
2009 Mar 20RE: coversion text to date
2009 Mar 20RE: Excel VBA - Print a Userform
2009 Mar 20RE: File manipulation
2009 Mar 20RE: Unique Item
2009 Mar 20RE: data management
2009 Mar 20RE: Formats
2009 Mar 20RE: Export pivot table to excel
2009 Mar 19RE: returning values
2009 Mar 19RE: returning values
2009 Mar 19RE: Charts and plotting nonzero amounts
2009 Mar 19RE: Tables
2009 Mar 19RE: returning values
2009 Mar 19RE: Tracking
2009 Mar 19RE: Conditional formatting
2009 Mar 19RE: actual working hours
2009 Mar 18RE: actual working hours
2009 Mar 18RE: actual working hours
2009 Mar 18RE: Export pivot table to excel
2009 Mar 18RE: coversion text to date
2009 Mar 18RE: VBA across Access and Excel
2009 Mar 18RE: actual working hours
2009 Mar 16RE: Hiding Tasks in MS Project
2009 Mar 16RE: macro's
2009 Mar 6RE: Name Ranges
2009 Mar 5RE: Floating form
2009 Mar 5RE: Data Reporting
2009 Mar 5RE: Access 2003
2009 Mar 5RE: OLE
2009 Mar 5RE: Microsoft project - printing
2009 Mar 5RE: Access Commands
2009 Mar 5RE: Split Database
2009 Mar 5RE: Using MS Access queries
2009 Feb 27RE: Solver
2009 Feb 27RE: PRIMARY KEYS
2009 Feb 25RE: Number format in msgbox
2009 Feb 18RE: CheckLocking in Access
2009 Feb 11RE: VBA
2009 Feb 11RE: Vlookup
2009 Feb 11RE: Access VBA
2009 Jan 21RE: Line and bar charts with secondary axis
2009 Jan 21RE: Vlookup
2009 Jan 7RE: formatting in reports
2009 Jan 7RE: Excel VBA
2009 Jan 5RE: Currency Formatting
2009 Jan 5RE: VBA Objects
2009 Jan 5RE: subtotals fill blanks
2009 Jan 5RE: Graphs
2009 Jan 5RE: Queries
2009 Jan 5RE: access
2009 Jan 5RE: Gantt charts
2008 Dec 17RE: Excel VBA
2008 Dec 1RE: Resource pools
2008 Dec 1RE: Access - tabel
2008 Dec 1RE: VB for Access
2008 Nov 28RE: SumProduct
2008 Nov 27RE: VLOOKUP
2008 Nov 27RE: functions
2008 Nov 27RE: VBA
2008 Nov 27RE: Currencies in VBA
2008 Nov 27RE: Currencies in VBA
2008 Nov 27RE: Active X Data Objects
2008 Nov 27RE: ADO
2008 Nov 27RE: Labelling tiers
2008 Nov 27RE: VB
2008 Nov 27RE: time for procedures to run
2008 Nov 27RE: message boxes
2008 Nov 27RE: Excel VBA
2008 Nov 27RE: vlookup
2008 Nov 3RE: give the value of the right-most cell which is not blank in
2008 Nov 3RE: multipe OR statements?
2008 Oct 27RE: Microsoft access - copying a form on our database to update
2008 Oct 23RE: Split tasks
2008 Oct 21RE: Loops and operators
2008 Oct 20RE: Loops and operators
2008 Oct 20RE: queries and subforms
2008 Oct 15RE: Sharing a Workbook with VBA Coding
2008 Oct 14RE: Excel VBA
2008 Oct 14RE: Pivot Tables - Orientation issues?
2008 Oct 14RE: Adding totals to data
2008 Oct 14RE: User Froms / command button - on click
2008 Oct 13RE: Sharing a Workbook with VBA Coding
2008 Oct 13RE: VBA
2008 Oct 8RE: Ascertaining a minimum value
2008 Oct 6RE: Calculated items in Pivot table
2008 Oct 6RE: Macro Errors
2008 Oct 6RE: EXCEL
2008 Oct 6RE: Project 2007 - Changing Resource Pools
2008 Oct 6RE: Excel VBA - Checking cell value against specific criteria
2008 Sep 27RE: Excel WSSI
2008 Sep 19RE: Client Milestone
2008 Sep 19RE: number of records in the database
2008 Sep 17RE: Excel Formatting
2008 Sep 16RE: Merging databases
2008 Sep 12RE: normalisation of a database
2008 Sep 10RE: using a Scroll bar with a cell of text
2008 Sep 2RE: Printing Project
2008 Sep 2RE: Printing Project
2008 Aug 29RE: Formatting reports
2008 Aug 29RE: Filtering
2008 Aug 29RE: Adding Dates
2008 Aug 29RE: Filtering
2008 Aug 29RE: Filtering
2008 Aug 29RE: Filtering
2008 Aug 29RE: Recurring Tasks
2008 Aug 29RE: Adding Dates
2008 Aug 29RE: Microsoft Project
2008 Aug 29RE: EDATE
2008 Aug 29RE: Percentage of column entry
2008 Aug 29RE: VBA, Compatibilty checker
2008 Aug 29RE: Auto date
2008 Aug 29RE: Copying data
2008 Aug 19RE: cell fomatting
2008 Aug 19RE: VBA Excel Message Box
2008 Aug 19RE: Reports
2008 Aug 19RE: Macros
2008 Aug 19RE: Excel
2008 Aug 19RE: Microsoft Excel
2008 Aug 19RE: Package and Deployment
2008 Aug 19RE: Charts
2008 Aug 19RE: filter
2008 Aug 19RE: filters
2008 Aug 19RE: Access Run-time
2008 Aug 19RE: importing data
2008 Aug 13RE: Reporting
2008 Aug 12RE: VBA
2008 Aug 12RE: Visual Basic
2008 Aug 12RE: Data Validation
2008 Aug 12RE: Make table queries
2008 Aug 12RE: Access Invoicing
2008 Aug 12RE: VBA Calculations
2008 Aug 12RE: Arrays
2008 Aug 4RE: Offsets
2008 Aug 4RE: Working Hours
2008 Aug 4RE: Filter by form
2008 Aug 1RE: Access VBA
2008 Aug 1RE: Access
2008 Aug 1RE: access/excel
2008 Aug 1RE: How to print a Gnatt chart
2008 Aug 1RE: Database Accessibility and the web
2008 Aug 1RE: Access
2008 Jul 25RE: Access
2008 Jul 24RE: Microsoft Project
2008 Jul 24RE: transferring data from one spreadsheet to another
2008 Jul 21RE: Yes / No Field on Query
2008 Jul 21RE: switchboard -
2008 Jul 21RE: report - query in access
2008 Jul 21RE: Query in Access
2008 Jul 21RE: report - query in access
2008 Jul 21RE: Query in Access
2008 Jul 17RE: Work Breakdown Structure
2008 Jul 17RE: MS Project - Tasks
2008 Jul 17RE: visual basic
2008 Jul 14RE: Finish/end dates
2008 Jul 10RE: Project Information - Start Date / End dates
2008 Jul 4RE: Converting Text Value to a Date
2008 Jul 4RE: Converting Text Value to a Date
2008 Jul 3RE: Access
2008 Jun 30RE: Charts
2008 Jun 30RE: excel
2008 Jun 30RE: What is a pivet table
2008 Jun 30RE: linking
2008 Jun 30RE: list formatting
2008 Jun 30RE: pie charts
2008 Jun 30RE: Access Advanced
2008 Jun 25RE: using formula
2008 Jun 25RE: Deleted queries
2008 Jun 25RE: table
2008 Jun 25RE: forms
2008 Jun 25RE: table queries
2008 Jun 25RE: Access 2007
2008 Jun 25RE: Access queries
2008 Jun 25RE: Access
2008 Jun 25RE: Access 2007
2008 Jun 25RE: Excel - VBA
2008 Jun 23RE: Excel VBA
2008 Jun 23RE: Setting up a print option in VB
2008 Jun 23RE: Excel VBA : Populating a list box with a field
2008 Jun 18RE: showing 'latest' months data in a summary
2008 Jun 16RE: Worksheet protection
2008 Jun 16RE: Resource Pools
2008 Jun 16RE: Worksheet protection
2008 Jun 16RE: Worksheet protection
2008 Jun 16RE: Lead times
2008 Jun 16RE: Summary not whole number
2008 Jun 13RE: Summary not whole number
2008 Jun 13RE: Project 2007
2008 Jun 13RE: Excell
2008 Jun 13RE: PROJECT FEILD
2008 Jun 13RE: Entering Resources
2008 Jun 13RE: Font
2008 Jun 12RE: Font
2008 Jun 12RE: MS Project
2008 Jun 12RE: Microsoft project
2008 Jun 12RE: Linking Data from Excel
2008 Jun 12RE: Blank data
2008 Jun 12RE: index formula
2008 Jun 11RE: How do you do sub totaling on VBA.
2008 Jun 11RE: Access Queries
2008 Jun 10RE: Worksheet protection
2008 Jun 10RE: Pivot tables
2008 May 30RE: Calendars
2008 May 30RE: Project 2007 predecessors
2008 May 23RE: arrays
2008 May 22RE: Exceeding Characters
2008 May 21RE: Exceeding Characters
2008 May 21RE: Consolidation
2008 May 21RE: Formulas
2008 May 21RE: excel and programs
2008 May 21RE: V Look Ups
2008 May 21RE: Protecting worksheets
2008 May 21RE: Avanced filters
2008 May 9RE: Printing in VBA
2008 May 9RE: Case select drops through valid cases to case else
2008 May 9RE: multiple projects ?
2008 May 9RE: inner forms
2008 May 9RE: Printing in VBA
2008 May 9RE: Access - Null Values
2008 May 2RE: microsoft project
2008 May 2RE: Sharing resources
2008 May 2RE: Calendar view
2008 May 2RE: Calendar view
2008 May 2RE: Constraints
2008 May 2RE: MS Project - Recurring Tasks
2008 May 2RE: Levelling out
2008 May 2RE: Project 2007
2008 Apr 30RE: Portfolio assembling
2008 Mar 28RE: Functions within functions
2008 Mar 28RE: End(xldown)
2008 Mar 28RE: Formulas
2008 Mar 14RE: Consolidate Baselines
2008 Mar 14RE: gantt chart dates when going into a new calendar year
2008 Mar 14RE: Collaboration
2008 Mar 14RE: Microsoft project
2008 Mar 14RE: Project - Show summary task detail
2008 Mar 14RE: MS Project
2008 Mar 14RE: Sub sets
2008 Mar 14RE: Printing
2008 Mar 14RE: Monitoring Progress
2008 Mar 14RE: Task constraints
2008 Mar 13RE: Resource Planning
2008 Mar 13RE: Excel VBA
2008 Mar 7RE: Resource Planning
2008 Mar 7RE: project
2008 Mar 7RE: MS Project crashing when applying filters
2008 Mar 7RE: MS Project 2003
2008 Mar 7RE: Microsoft Project
2008 Mar 7RE: MS Project
2008 Mar 7RE: project 2007
2008 Mar 7RE: Pool Resources
2008 Feb 29RE: Project
2008 Feb 29RE: MS Project
2008 Feb 29RE: Working with multuiple plans
2008 Feb 29RE: Project 2007
2008 Feb 29RE: MSP
2008 Feb 29RE: Graphic Indicators
2008 Feb 26RE: if
2008 Feb 26RE: Excel VBA buttons/images
2008 Feb 25RE: Find and replace Task name
2008 Feb 17RE: Refer to data that has been named - define
2008 Feb 15RE: data validation
2008 Feb 15RE: Data
2008 Feb 15RE: View bar
2008 Feb 15RE: Excel VBA
2008 Feb 14RE: Allocating resources
2008 Feb 13RE: Excel VBA
2008 Feb 11RE: Getting Age from Date of Birth Formula
2008 Feb 10RE: Xcel
2008 Feb 10RE: Templates
2008 Feb 10RE: header and footers
2008 Feb 10RE: Access
2008 Feb 10RE: Access
2008 Feb 10RE: Macros
2008 Feb 10RE: Access/Excel
2008 Feb 10RE: Access primary key
2008 Feb 10RE: access
2008 Feb 10RE: access
2008 Feb 10RE: Excel
2008 Feb 10RE: Autotext
2008 Feb 10RE: general course
2008 Feb 10RE: charts
2008 Feb 10RE: ms excel
2008 Feb 10RE: VBA
2008 Feb 10RE: Using MySQL database as an external datasource
2008 Feb 10RE: Excel
2008 Feb 10RE: Pivot Table
2008 Feb 10RE: Excel
2008 Feb 10RE: Importing Data
2008 Feb 10RE: Pivot Table
2008 Feb 10RE: Two or more work sheets
2008 Feb 10RE: Excel charts and graphs
2008 Feb 10RE: Emailing a sheet
2008 Feb 10RE: match function
2008 Feb 10RE: Cocatenation
2008 Feb 10RE: Pivot Table
2008 Feb 10RE: List of objects /
2008 Feb 9RE: Variables
2008 Feb 9RE: Can you pull data from Maconomy database using VBA
2008 Feb 9RE: Change an Object's Property
2008 Feb 9RE: Adding date range to a report / query
2008 Feb 9RE: MS project
2008 Feb 9RE: Expenses
2008 Feb 9RE: Macros
2008 Feb 9RE: Printing
2008 Feb 9RE: Microsft Project
2008 Feb 9RE: gant chart
2008 Feb 9RE: Active project
2008 Feb 9RE: Change Working time - adding, deleting or renaming calendars
2008 Feb 9RE: Multiple Projects
2008 Feb 9RE: resource allocation
2008 Feb 9RE: overallocated
2008 Feb 5RE: calendar view
2008 Feb 5RE: project against resources
2008 Feb 5RE: MSP Calendars
2008 Feb 5RE: Project
2008 Feb 5RE: Photo viewer?
2008 Feb 4RE: MS Project 2007 - Timescale
2008 Feb 4RE: Project
2008 Feb 4RE: MS project
2008 Jan 30RE: Track progress
2008 Jan 30RE: Task constraints
2008 Jan 30RE: Tasks
2008 Jan 18RE: Working times
2008 Jan 18RE: MS Project
2008 Jan 18RE: Printing
2008 Jan 18RE: Tasks
2008 Jan 18RE: MSP Printing
2008 Jan 18RE: Problems when moving from Resource usage to Gantt chart view
2008 Jan 18RE: Task Dependencies
2008 Jan 18RE: Moving a project date
2008 Jan 18RE: Task Dependencies
2008 Jan 18RE: Microsoft Projects
2008 Jan 18RE: Microsoft Project
2008 Jan 18RE: Task dependency
2008 Jan 18RE: Material resource
2008 Jan 18RE: Non-working time display in Gantt Chart
2008 Jan 18RE: Text/Graphic Boxes
2008 Jan 7RE: Access - re-designing
2008 Jan 4RE: Macro to automate e-mailing of spreadsheet
2008 Jan 4RE: Creating Database of Images
2008 Jan 4RE: command button caption font size
2008 Jan 4RE: VBA Pivot Chart Colours
2008 Jan 4RE: Excel
2008 Jan 4RE: Complex Function
2008 Jan 4RE: Excel VBA
2008 Jan 4RE: Complex code
2008 Jan 4RE: VLookup
2008 Jan 4RE: VBA for excel
2008 Jan 3RE: Excel
2008 Jan 3RE: Do Loop
2008 Jan 3RE: default value in Access
2008 Jan 3RE: how can i stop this message coming up when sending email thr
2008 Jan 3RE: Linking Workbooks
2008 Jan 3RE: Naming task bars
2008 Jan 3RE: Task dependencies
2008 Jan 3RE: Assigning Projects
2007 Dec 20RE: Dependency Linking
2007 Dec 20RE: leveling resources in master file
2007 Dec 20RE: Reporting/Tracking
2007 Dec 20RE: linking tasks to resource availability
2007 Dec 20RE: Microsoft Project
2007 Dec 19RE: linking tasks to resource availability
2007 Dec 19RE: Resource Allocation
2007 Dec 19RE: Export
2007 Dec 18RE: Linking Project Plans
2007 Dec 18RE: Import
2007 Dec 18RE: Resourcing
2007 Dec 13RE: Queries
2007 Dec 13RE: Format emails
2007 Dec 13RE: Array's or creating virtual tables and populating
2007 Dec 13RE: Watch window
2007 Dec 10RE: Percentage & Number formatting within Access queries
2007 Dec 10RE: Cut and Paste
2007 Dec 10RE: Copying settings (ie custom views etc)
2007 Dec 10RE: What are constraints?
2007 Dec 10RE: Re-occuring tasks
2007 Dec 7RE: default filters and master file anomolies
2007 Dec 7RE: default filters and master file anomolies
2007 Dec 4RE: Resources
2007 Nov 30RE: Reports
2007 Nov 30RE: Resources
2007 Nov 30RE: Task Constraints
2007 Nov 29RE: Country Look Up
2007 Nov 29RE: Excel absolute referencing
2007 Nov 29RE: Critical Path Tasks
2007 Nov 29RE: Task Constraints
2007 Nov 29RE: MS PROJECT 2003
2007 Nov 29RE: Resources
2007 Nov 29RE: MS Project
2007 Nov 29RE: ms project
2007 Nov 22RE: Material resourses
2007 Nov 22RE: project 2007
2007 Nov 22RE: Microsoft Project
2007 Nov 22RE: MS Project Reference Manual
2007 Nov 22RE: Project Headings
2007 Nov 21RE: Resource pools
2007 Nov 21RE: Import Data
2007 Nov 21RE: Resource Allocation
2007 Nov 21RE: Printing
2007 Nov 21RE: Time series
2007 Nov 21RE: Excel
2007 Nov 21RE: Format Painter
2007 Nov 21RE: EXCEL
2007 Nov 21RE: Excel External Data
2007 Nov 21RE: Excel Charts
2007 Nov 21RE: Excel Functions
2007 Nov 21RE: Excel Intermediate
2007 Nov 21RE: Work with Access Database
2007 Nov 21RE: Charts
2007 Nov 21RE: Reporting
2007 Nov 21RE: Hanging Depedency
2007 Nov 21RE: Resources
2007 Nov 21RE: Resource
2007 Nov 21RE: Microsoft Project
2007 Nov 21RE: MS Projects
2007 Nov 21RE: Finance
2007 Nov 15RE: Assigning Macro to new workbook
2007 Nov 15RE: Project
2007 Nov 14RE: Multiple Projects
2007 Nov 14RE: dependancies
2007 Nov 14RE: MS Project
2007 Nov 13RE: Please post the Google MSP forum URL's
2007 Nov 12RE: Separating numbers and text
2007 Nov 9RE: Microsoft Access Foundation
2007 Nov 9RE: project 2007
2007 Nov 9RE: Sharing an Access Database
2007 Nov 9RE: Amending data in cells
2007 Nov 9RE: Microsoft Project
2007 Nov 8RE: formulas
2007 Nov 8RE: Separating numbers and text
2007 Nov 8RE: Return/Enter
2007 Nov 8RE: Variable
2007 Nov 8RE: Excel Maths
2007 Nov 8RE: Resources
2007 Nov 8RE: Baseline of projects
2007 Nov 8RE: Integration with MS Outlook
2007 Nov 8RE: micro soft projects 2003
2007 Nov 8RE: MS Project, Calendar, Working Time

Rate this page:
2.2/5 (127 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner		 Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

 Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams		 Association of Computer Trainers verified by visa, mastercard securecard

© 2010 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Mini sitemap. These are the main areas of our web site. Full sitemap.

Professional & Management

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London

Training Formats

Public scheduled courses
On-site training
Closed company courses

MS Office & IT Applications

Excel courses
Excel training
Excel Training Courses Medway
Microsoft Excel training
Microsoft Project training
Microsoft Office training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training
MS Project courses
MS Project training
Outlook courses
PowerPoint courses
PowerPoint training
VBA courses
Word courses
(more...)

Crystal Reports training

DreamWeaver courses
Dreamweaver training

Training Information

London Computer Training
Computer Training London

Training venues
Client list
FAQ
Pricing and availability
Course details / Syllabus

Training Information
Training Articles
Microsoft Training Blog

Interested in Access training?
Please see the following pages:

Access courses
Access training
Microsoft Access training
Microsoft access courses
Microsoft training access course
Microsoft+access+training
Access courses in london