Courses in Southwark

...You will learn how to create robust and professional models utilizing Excel functionality that most Excel users do not know how to use. Day 3 uses...

...case Initiating a project (IP) Planning qualityPlanning the projectExpanding the business caseAssessing riskIdentifying controls Controls Overview of controlsControlled...

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

...Organisation Roles The project board The project management team Starting up a Project (SU) Creating the project management team Defining the project's...

...Using the Find Dialogue Using Page Setup Setting Page Options Setting Margins Setting Headers Setting Footers Modifying the Legend View Settings Printing...

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

...a New Project with Tasks Editing Business Tasks and Projects Viewing Business Tasks and Projects Communications History and Linking Creating a History...

...and finances, keep project teams aligned, and be more productive through integration with familiar Microsoft Office system programs, powerful reporting...

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

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

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

...descriptive information Creating Opening Distributing Modifying Manipulating Windows Explorer Creating, Deleting, Renaming folders Copying / Moving / Renaming...

...Delegates will learn a broad range of structures and procedures intended for manipulating data, documents and templates. PREREQUISITES This course assumes...

...intended for manipulating data, documents and templates. DESCRIPTION This course introduces experienced Word users to developing the application and its...

...This course provides an introduction to using Microsoft Access for database creation, focussing mostly on table design and select queries. Forms and Reports... Learn about: Microsoft Access...

...Changing Group Properties Using Calculated Controls in a Report Formatting Reports Formatting Gridlines Modifying the Font Adding Logos Changing the Layout... Learn about: Microsoft Access...

...a Subform Working with a Subform Synchronizing Subform Data with a Main Form Displaying a Subform within a Main Form Advanced Form Tasks Limiting... Learn about: Microsoft Access...

...Selecting Conditional Data Using the ORDER BY Statement Using Subqueries What is a Subquery? Creating a Subquery Subqueries with Equality Subqueries... 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...

...Access Using Excel With other Programs and Files Using Outlook to Send Excel Data Opening an Excel File in a Different Format Importing Data from a...