Courses in Southwark

...This course is directed at experienced Excel users who are wanting to take their spreadsheets to a new level. You will learn how to create robust and professional...

...This PRINCE2 Foundation training course prepares delegates to sit the PRINCE2 Foundation Exam which is set by APMG. The PRINCE2 Foundation paper is a closed...

...PRINCE2 Practitioner Conversion Day 1 PRINCE2 Practitioner Exam guidelines Time Management Types of questions Using the answer booklet The PRINCE2 manual...

...Authorisation process Risk Management Risk managementRisk analysisRisk management considerations Controlling a Stage (CS) Authorising workUpdating & reviewing...

...Deadlines SCHEDULING A PROJECT Creating the Project Calendar Calendar Types Setting up the Calendar Creating a New Calendar Using Calendar View Adjusting...

...Unhiding a Window Splitting a Window Advanced Views Using Multiple Views Viewing Tables Sorting Information Using Filters Using AutoFilter USING RESOURCES...

...Options Advanced Contact Management Options Showing Additional Fields Marking a Contact as Private Using the Communicate Group Sending a Contact as a Business...

...Project Elements Renaming Elements with the Organizer Deleting Elements Using Project with other Applications Inserting Objects Importing Data from Outlook...

...WRITING CODE What is a sub procedure What is a function Formatting Objects Cut / Copy / Paste Deleting rows / columns / ranges / cells Using Msgbox Using...

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

...Adding Buttons Customising the buttons Resetting all in-built toolbars Preventing any design changes to your toolbar Creating a Menu using VBA Creating...

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

...Structures Looping Control Structures Performing Multiple Actions on an Object Non-Structured Statements Sub Procedures CONTROLS, DIALOG BOXES AND USER-DEFINED...

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

...Advanced Form Controls Formatting Your Form Formatting Gridlines Modifying the Font Adding Logos Changing the Layout Formatting Controls Formatting Records... Learn about: Microsoft Access...

...PivotChart Fields Completing Your PivotChart Using PivotTables and PivotCharts Using a PivotTable Using a PivotChart Editing a PivotTable or a PivotChart... Learn about: Microsoft Access...

...You are familiar with the concepts of Levels 1-3 and would like to start automating your databases. ADD-ONS TO ACCESS COM Add-Ins Digital Signatures Smart... Learn about: Microsoft Access...

...Painter Cell Merging and AutoFit Find and Replace Formatting Enhancing a Worksheet's Appearance Adding Patterns and Colours Adding Borders Working...

...ADVANCED FILE TASKS Using My Computer within Excel Saving your Files Using Templates WORKING WITH FUNCTIONS AND FORMULAS Using Formulas in Excel Understanding...