Progressive Training & Development courses

...along with getting an introduction to SQL (Structured Query Language), a look at some other Query types and options, and create forms from scratch...

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

...This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access...

...control and creative use of MS Access. The course is aimed at those with little or no previous programming background, although experienced programmers...

...Working with Multiple PDF Documents Organize PDF Documents into a Collection Redact PDF Documents Search Multiple PDF Documents Reviewing a PDF Document...

...blending modes Advanced text animation Using the Puppet tool Working with compositions Nesting comps Pre-rendering comps Pre-composing layers Setting...

...and refine designs Working with text Customising text presets Animating text Antialiased text Using text layers Working with key frames Animating graphic...

...Dashboard Information Management Tools Setting up the Product and Service Items List Using the Product and Service Items List Importing Data Exporting...

...DESCRIPTION This course is for anyone who has to design a newsletter, job ad, flyer, business card, memo, report or whatever, but has no idea what separates...

...Image Adjustment Brightness and contrast Gamma Hue / Saturation Colour balance for shadows, highlights and mid-tones Levels and curves Converting to Black...

...adding content to an existing site, understanding the power of style sheets (CSS), working with buttons and rollovers, integration with applications such as Adobe Photoshop...

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

...Worksheets MORE FORMATTING TECHNIQUES Using Styles Conditional Formatting Using The Format Painter Using Guidelines Hiding And Displaying Cells MORE FORMULAS...

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

...TABLE FUNDAMENTALS What is a Pivot Table Why Should you use a Pivot Table When Should you use a Pivot Table The Anatomy of a Pivot Table Pivot Tables Behind...

...from an Existing Pivot Table USING EXTERNAL DATA SOURCES FOR YOUR PIVOT TABLE External Data Sources Working Around Excel's Data Management Limitations...

...Manager Handle Additional Annoyances Issues with Two or more Data Fields Summarize Date Fields with Grouping Advanced Pivot Table Techniques Control...

...common worksheet operations, convert worksheets into forms and understand Excel VBA code. PREREQUISITES This is a generic VBA course and is suitable...

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

...to a shortcut menu Disabling a shortcut menu Resetting a shortcut...