PPi Learning Services courses

...Tables Entering Data Into Tables Moving around the table Finding and replacing data Sorting columns in tables Applying and removing filters Calculating...

...to display table data with One-To-Many relationships, add and work with form controls such as combo boxes and command buttons, use Events for these controls...

...query totals and crosstab queries, using action queries to enable repetitive updates or deletions in tables. Using name autocorrect to track and manage...

...Forms Main/Subforms Split Forms Stacked and Tabular Layouts Customising the Navigation Pane Startup options Synchronising forms Macros Creating standalone...

...using the In-line If function. Concatenate text fields for display purposes. Use Domain Aggregate functions such as Dlookup to retrieve and filter records...

...Use the command button wizard to create buttons to perform actions such as closing, opening forms, saving records, running reports. Display data from tables...

...This course is designed to familiarise current Excel users with the advanced concepts of Excel. Course content Using string formulas Customising number...

...using help and the Office assistant, toolbars and dialog boxes, smart tags and task panes Creating and saving workbooks, opening and closing files...

...This course is designed to enhance the knowledge of existing Excel users and improve their skills. Course content Freezing and splitting worksheets...

...Database Using Data Forms Adding, Editing And Deleting Records Sorting Records Searching For Records Removing Duplicates AutoFilter And Advanced Filter...

...Building Formulas. Basic calculations and priorities. Inserting functions. Using AutoSum. AutoCalc. Calculating across Worksheets. Formatting...

...Manual And Automatic Outline Hiding And Displaying Outline Working With Visible Data...

...This course is designed to familiarise current Excel users with the advanced concepts of Excel 97/2000. Course content Using string formulas Amending number...

...fonts and colour, format painter Previewing worksheets, changing the margins and orientation, setting the print area, print titles, page breaks and page break preview...

...This course is designed to enhance the knowledge of existing Excel users and improve their skills. Course content Naming cells and creating 3D names Relative...

...This 2-day course is aimed at experienced Excel users, preferably with some awareness or experience of computer programming. This 2-day course is aimed...

...Creating and formatting layout tables Cell formatting Managing Webs Tasks view Reports Source control Designing and promoting Webs Designing Webs Promoting...

...This course teaches the basic functions and features of FrontPage 2003. Students will learn how to create and format Web pages, work with lists and tables...

...Creating views Page Setup Managing Form Templates Previewing form designs Protecting form designs Managing form versions Saving form designs Publishing...

...and sort, group, and set rules for messages. They'll also learn how to work with notes, the Journal, advanced Calendar features, message templates...