PC Applications courses Southwark

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

...with VAT added to it Returning a country based on a provided city Returning the last cell address in a range Returning the last row in a range Returning...

...for macros Customising the button Attaching a toolbar to a workbook Using VBA Why? Creating / deleting a toolbar Showing the toolbar Placing the toolbar...

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

...field options Protecting forms Save forms data only Printing a form Macros and form fields Example form macros INTRODUCTION TO MACROS What is a Macro?...

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

...and Repeat Smart Tags and Options Buttons What Are Smart Tags? The Error Option Button The AutoFill Option Button The Paste Option Button Setting Smart...

...Working with Array Formulas What are Array Formulas? Using Basic Array Formulas MANAGING TABLES Working with Records and Fields Working with Records...

...External Data Exploring Scenarios What is a Scenario? Creating a Scenario Creating a Scenario Summary Report Saving Multiple Scenarios What If Analysis...

...2003 What Is Outlook 2003? Outlook 2003 Workspace Customise Outlook Today The Navigation Pane THE TOOLBARS The Standard Toolbar The Outlook Today Toolbar...

...Managing Slides ADDING EFFECTS Formatting Text Using the Home tab Formatting Text from the Fonts Dialog Box Creating a Bulleted or Numbered List from... Learn about: PowerPoint 2007...

...Working with Tables Formatting a Table Working with Charts and Graphs Working with SmartArt ADDING GRAPHICS Customizing Your Diagrams Working with... Learn about: PowerPoint 2007...

...and using the Slide Master to create a standard look to you presentations. DESCRIPTION This course deals with using and sharing your presentations... Learn about: PowerPoint 2007...

...and Views Using Print Layout Using Full Screen Reading Using Web Layout Using Outline View Using Draft View BASIC VIEWING TOOLS Using Minimize... Learn about: Word 2007...

...Converting Documents in Word 97-2003 Format Running the Compatibility Checker Saving Documents in Word 97-2003 Format Setting Compatibility Options Compatibility... Learn about: Word 2007...

...Chart Data Using the Format Chart Dialogs Adding Captions USING STYLES Using the Quick Style Gallery Changing Your Styles Using the Styles Pane Doing... Learn about: Word 2007...

...Basic Financial Statements Income Statement Balance Sheet Cash Flow Statement Compounding Capitalization A Few Essential tools of the Trade Keyboard shortcuts...

...all Advanced Filters Applying an Advanced Filter Working with Filtered Data Manipulating Filtered Data Totalling fields within a filtered database...