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...

...approach and the ability to apply the method to your own working. DESCRIPTION PRINCE2 (PRoject IN Controlled Environments) is a project management methodology...

...It is strongly advised that delegates begin the pre-course work and reading no later than 3 weeks prior to the training course start date. PREREQUISITES...

...Technique RolesSteps for planning a quality reviewOutcomes Planning Plans Elements of a planLevels of plan Product Based Planning Technique Creating...

...more efficiently and effectively. You can stay informed and control project work, schedules, and finances, keep project teams aligned, and be more productive...

...Reports Using the Reports Dialogue Box Creating a Pre-Defined Report Creating a Custom Report Creating Visual Reports Opening the Visual Reports Dialogue...

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

...Custom Forms Toolbar Modifying a Form Using the Edit Menu Using the Item Menu Creating your Own Form Using the Organizer Opening the Organizer Copying...

...through code Stopping Code Excel Objects and their hierarchy Workbook Range Cell Worksheet Columns Rows Using the Offset property Using the object browser...

...left, right, mid, instr) Working out what kind of value is residing in a cell (isnumeric, isstring, isdate... etc) Creating your own Functions A value...

...the with-end with structure Forms Showing and hiding Designing Using option buttons Using check boxes Using multi pages Using other controls Showing...

...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code. DESCRIPTION Anyone wishing to automate...

...This course introduces experienced Word users to developing the application and its uses. Delegates will learn a broad range of structures and procedures...

...a very good grounding in the use of Microsoft Word. Delegates should have attended Intermediate or Advanced Word courses or have equivalent knowledge...

...Forms and Reports are introduced mostly using the inbuilt wizards. DESCRIPTION This course provides an introduction to using Microsoft Access for database creation... Learn about: Microsoft Access...

...Queries Append Queries Delete Queries Update Queries Exporting Queries... Learn about: Microsoft Access...

...Contacts from a SharePoint Server Moving your Database to a SharePoint Server Publishing to a Web Server PIVOTING DATA Creating a PivotTable About PivotTables... Learn about: Microsoft Access...

...TO COLLABORATE SharePoint Basics What is SharePoint? System Requirements Creating a Workspace Accessing a Workspace Publishing to a Workspace SharePoint... Learn about: Microsoft Access...

...Copy, and Paste Multiple Cells and Items How to Use Paste Special How to Insert and Delete Cells, Rows, and Columns Using Undo, Redo, and Repeat Smart...

...PREREQUISITES You need to be comfortable with Excel basics, including using sum functions and typical navigation around a spreadsheet. ADVANCED FILE TASKS...