We are specialists in on-site training and qualified to deliver the following courses at your offices anywhere within the UK. For more information please call us free on 0800 2922842 or email info@pbatraining.co.uk

Microsoft Excel Foundation 1 Day Course
The Course Includes:

  • Introduction to spreadsheets
  • Overview of the Excel menus and toolbars
  • Entering & editing data and text
  • Saving workbooks
  • Formatting spreadsheet data & text
  • Calculating using AutoSum
  • Modifying spreadsheet (resizing & inserting columns, rows etc)
  • Constructing basic formulas
  • Copying formulas
  • Understanding absolute cell references
  • Introduction to Excel functions
    • The SUM function
    • The MIN function
    • The MAX function
    • The Average function
    • The COUNT & COUNTA functions
  • Working with the date and time functions
  • Highlighting data with Conditional Formatting
  • Managing large workbooks (freezing rows, columns & panes etc)
  • Printing workbooks & selected spreadsheet data

Microsoft Excel Intermediate 1 Day Course
The Course Includes:

  • Excel overview refresher
  • Linking workbook data
  • Protecting workbooks & cell ranges
  • Advanced conditional formatting techniques
  • Finding data records with VLookups & HLookups
  • Filtering data with the Auto & Advanced filters
  • Macros and their uses
  • Calculating Subtotals and working with Levels
  • Sorting data using Pivot Tables & Pivot Charts
  • Consolidating data in multiple spreadsheets
  • Linking worksheets with 3D formulas
  • Using the Watch Window
  • Data validation & creating drop-down lists
  • Creating and applying custom styles
  • Creating spreadsheet templates
  • Embedding & linking spreadsheets in Word documents & PowerPoint slides

Microsoft Excel Advanced 1 Day Course
The Course Includes:

  • Using advanced functions
    • Conditional Logic: using the IF function
    • Using Not, AND, OR functions
    • Nested IF functions
    • The IFERROR function
  • Using maths & statistical functions
    • The SUMIF function
    • The COUNTIF function
    • The AVERAGEIF function
  • Introduction to the new 2007 Excel functions: SUMIFS, COUNTIFS, AVERAGEIFS
  • Working with data
    • Tidying the database with the TRIM function
    • Extracting text & data using FIND and MID functions
    • Using the VALUE function
    • Finding data records using MATCH and INDEX functions
  • Working with advanced database functions
    • The DSUM function
    • The DAVERAGE function
    • The DCOUNT function
  • Working with analytical tools
    • Using Goal Seek
    • Creating & merging Scenarios

Microsoft Access Foundation 1 Day Course
The Course Includes:

  • What’s new in Access 2007
  • Creating a new database
  • Opening database files
  • Creating tables
  • Using table views
  • Understanding data types
  • Setting Primary keys
  • Changing field properties
  • Creating input masks
  • Understanding table relationships
  • Using sub datasheets
  • Creating & using forms
  • Using filters
  • Creating queries

Microsoft Word Foundation 1 Day Course
The Course Includes:

  • Creating a file and folder structure
  • Overview of Word menus and toolbars
  • Opening and saving Word documents
  • Entering and formatting text
  • Formatting paragraphs
  • Proofing text
  • Copying and pasting text
  • Importing graphics & photos
  • Creating page layouts using tables
  • Printing Word documents

Microsoft Word Advanced 1 Day Course
The Course Includes:

  • Creating and applying Styles
  • Structuring a document with Levels
  • Understanding and using Outline View
  • Creating a Table of Contents
  • How to create protected Forms
  • Inserting and using Bookmarks
  • How to cross reference bookmarks
  • Inserting Citations & creating a Bibliography
  • How to import and edit graphics & photos
  • Creating protected form documents
  • Creating and running Macros

Microsoft Project Foundation 1 Day Course
The Course Includes:

  • Introduction to the main MS Project Views
  • How MS Project creates the Gantt Chart
  • Creating & defining a new project
  • Defining project working times
  • Creating custom calendars
  • Entering and outlining project tasks
  • Understanding task linkage types
  • How to link tasks correctly
  • Setting milestones & deadlines
  • Setting lag and lead time
  • Entering & assigning resources
  • How to resolve overallocated resources
  • Setting the baseline & interim plans
  • Tracking and updating the project

Microsoft Project Advanced 1 Day Course
The Course Includes:

  • Understanding the critical path in MS Project
  • Correctly applying task constraints
  • Creating individual task calendars
  • Working with multiple pay rates
  • Applying custom calendars& work times
  • Entering material resource consumption rates
  • Interrupting work & rescheduling tasks
  • Setting up recurring tasks
  • Working with resource availability
  • Leveling overallocated resources
  • Grouping data by custom selection
  • Applying & working with a budget in MS Project
  • Creating detailed visual reports in Excel