Progressive Training & Development courses

...Using Text Functions Forms Creating from scratch Using Combo Boxes and List Boxes Changing the source of a text box Adding in a company logo Creating...

...(or Switchboard), and learn how to use macros in Access. Please note that macros are not VBA. DESCRIPTION This course looks at setting databases up for other people to...

...of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence...

...database concepts gained from practical experience or by prior attendance on an "Access Advanced User" course is essential . More on Forms and VBA Export Reports to...

...Accessing a PDF Document Open a PDF Document Explore the Adobe Acrobat 9 Pro Interface Browse Through a PDF Document Creating PDF Documents Create a...

...proxy An introduction to Particle playground A guide to effects in After Effects 3D channel effects Using sound in After Effects Adding and previewing...

...look at transitions Using the Comp window Creating text effects Animating text More about key frames Further principles of key framing Copying and pasting...

...It is included with the Ultimate, Professional, and Small Business editions as a separate CD. (Other editions of Microsoft Office are not licensed for this product...

...This course will explain how, by sticking to four basic design principals - contrast, repetition, alignment and proximity - you can eliminate design gremlins from your...

...This course gives photographers a thorough introduction to the theory and practice of digital photography. You will also get hands-on experience with Adobe Photoshop...

...Dreamweaver interface basics Creating a local site Creating a new HTML page Using development views Previewing pages Setting document properties The Related...

...PREREQUISITES Basic PC knowledge required INTRODUCTION TO MICROSOFT EXCEL What Is Excel? Excel File Types Excel Environment Toolbars Office Assistant WORKBOOKS...

...Another Application Embedding And Linking Objects Hyperlinks Managing Links...

...WhatIf Analysis Goal Seek Data Tables Scenario Manager Solver Using Pivot Tables MACROS AND CUSTOM CONTROLS Working With Macros Running Macros Adding Custom...

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

...A further look at the power of Pivot tables and Pivot Charts, introducing getting your data from multiple sources, and opening the door to OLAP Cubes!...

...USING VBA TO CREATE PIVOT TABLES Introduction to VBA Tricks of the trade Versions Build a Pivot Table in Excel VBA Revenue by Model for a Product...

...the macro results Understanding Code Formatting (Indents, etc) Reading from and writing to a cell Absolute vs Relative Referencing Playing back VBA Stepping...

...a browse for a file box Providing a GetSaveAsFileName box to save a file Using Select Case vs using If statement Expanding on Conditional Formatting limitations...

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