PC Applications courses Southwark

...vs task panes Custom layouts Slide Libraries ACCESS 2007 Access 2007 new features The new interface system Predefined database solutions OUTLOOK 2007 Outlook...

...Numbered Lists Borders And Shading Editing Find and replace, and GoTo Finding Text Replacing Text Searching Items Go To Printing Previewing Documents Printing... Learn about: Microsoft Office...

...Folder Creating New Accounts Editing an Account Account Views Business Contacts Opening the Business Contacts Folder Business Contact Views Skill Sharpener...

...Text Formatting Numbers Manipulating Data Formatting Columns And Rows Formatting With Colours And Patterns Adding And Editing Borders Using Autoformat...

...Date & Time Functions Math & Trig Functions Statistical Functions Lookup & Reference Functions Database Functions Text Functions Logical Functions Information...

...This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets. DESCRIPTION...

...Reference Macro Assigning a Keystroke to a Macro Copying a Macro from a Workbook or Template Visual Basic and Macros Opening the Visual Basic Editor Adding...

...Formatting a Pivot Table CONTROLLING THE WAY YOU VIEW YOUR PIVOT DATA Showing and Hiding Options Sorting in a Pivot table Producing Top 10 Reports Group...

...Data Warehouses and OLAP Cubes Connecting to an OLAP Cube Working with an OLAP Pivot Table Comparing OLAP Cube' Pivot Tables to Excel Data Other Considerations...

...basic for Applications (VBA) PREREQUISITES You need to have Intermediate to Advanced Pivot Table knowledge. You should have attended Excel VBA Level 1 at a minimum...

...Standard Workspace Creating a Standard Workspace Sending and Accepting Workspace Invitations Working in the Workspace Members Pane Changing the Role...

...and Responses Using Pictures and Drawings Adding Pictures to a Workspace Editing a Picture Managing Picture Files Creating a Basic Sketch Adding Colour...

...or Windows Messenger Contacts in Groove Sending an Instant Message Displaying and Replying to an Instant Message Working with Your Instant Message History...

...Menus Resetting Toolbars and Menus Working with Files Saving Files Opening Files Switching Between Open Files Window Controls Closing Files Getting Started...

...Effects Changing Text Colour Changing Font Type and Size Aligning Text Applying a Background Colour Using Colour Schemes Finishing your Form Adding Controls...

...Print Preview Printing a Form Print Commands Using the Print Dialogue Setting Printer Options Setting Copies and Page Ranges DOING MORE WITH FORMS Working...

...Site Using Forms with SharePoint Workflows Forms and Workflows Publishing the Form Adding a Workflow Adding a Data Connection to Receive Workflow Information...

...Notes ADVANCED ONENOTE FEATURES Setting OneNote Options Advanced File Options Sharing a Notebook Using a Live Sharing Session...

...PREREQUISITES None STARTING OUT Getting Started Interacting with Outlook Working with Toolbars Using the Outlook Panes Getting Help in Outlook RECEIVING...

...Search Menu Performing an Instant Search Using the Query Builder Search Folders About Search Folders Creating Search Folders Customizing Search Folders...