Courses in Southwark

...all the cells with Formulas Displaying a cell in the Watch Window Deleting a watch Hiding the Watch Window Protecting your work Creating Reports Print Areas...

...to provide you with a detailed understanding of the PRINCE2 approach and the ability to apply the method to your own working environment. This will...

...is designed to provide you with a detailed understanding of the PRINCE2 Objective Practitioner Examination. This will be achieved during the PRINCE2 training...

...Configuration Management Managing configuration Managing Product Delivery (MP) Managing creation & completion of products Stage Boundaries...

...guided planning, and flexible tools. GETTING STARTED Starting Out What is Microsoft Office Project 2007? What is a Project? Why Use Project 2007?...

...Resources and Tasks Assigning a Resource to a Task (Gantt View) Assigning a Resource to a Task (Task Information Dialogue) Using Task Usage View to Modify...

...ADVANCED INFORMATION MANAGEMENT TOOLS Advanced Calendar Options Using the Time Zone Feature Creating Recurring Appointments Setting Calendar Options Adding...

...PERT Viewing Scenarios Earned Value Analysis About EVA Viewing EVA Tables About the EVA Fields Reporting EVA Results EXPERT TOPICS Working With Forms...

...Explorer Project Properties The Code Window The Immediate Window Finding Macros Export and Import VBA Modules Add and Remove a module ANALYSING VBA Understanding...

...a browse for a file box Providing a GetSaveAsFileName box to save a file Using Select Case vs using If statement Expanding on Conditional Formatting limitations...

.../ deleting a menu Placing the menu Adding Buttons Customising the buttons Resetting in-built menu Working with Shortcut menus Adding / Deleting menu items...

...common worksheet operations, convert worksheets into forms and understand Excel VBA code. PREREQUISITES Must be confident or at least have had sufficient...

...to customise Word installations to manipulate data and/or create automated templates and forms. BOOKMARKS What are Bookmarks? Defining Bookmarks Using...

...FORMS Introduction Built-In Dialog Boxes Predefined Dialog Boxes User-Defined Forms Adding Form Controls Form Control Properties Control and Dialog...

...THE NEW INTERFACE Using the Quick Access Toolbar Basics of Tabs The Home Tab Create Tab External Data Tab Database Tools Tab CREATING A DATABASE First... Learn about: Microsoft Access...

...Multiple Table Queries Creating a Multiple Table Query Creating a Calculated Field Using the Expression Builder Using Queries to Summarize Advanced Queries... Learn about: Microsoft Access...

...Using the Navigation Pane and Tab Using the Switchboard Manager Creating a Switchboard Editing a Switchboard Deleting a Switchboard Modal Dialog Boxes... Learn about: Microsoft Access...

...Aggregate Functions Nested Subqueries and Uses of the IN Keyword Using SQL Joins Creating Simple Joins Using an Alias Sorting Joins Creating Outer Joins... Learn about: Microsoft Access...

...What is AutoComplete? Working with Basic Formulas Moving your Data Dragging and Dropping Cells How to Cut, Copy, and Paste Cells How to...

...Finding the Right Function Using Functions in Excel Inserting Functions Using the IF Function Working with Nested Functions Working with Names and Ranges...