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

...so that forms can be opened or closed and to synchronise the display of data across forms. Create macros to automate operations in a database...

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

...to command buttons Requery macros SendKeys and SetValue macro actions Exporting data using a macro...

...to these objects so that forms can be opened/closed and synchronised to display related records. Create macros, macro actions, group macros...

...This course is designed to give course participants a good working knowledge of Access. Participants will learn how an Access database works and gain...

...tables Creating pivot tables Calculating in pivot tables Creating a pivot table chart Customising toolbars and menus Creating a template and protecting worksheets...

...applying borders, fonts and colour, format painter Previewing worksheets, changing the margins and orientation, setting the print area, print titles...

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

...Course content Utilities Using String Formulas Amending Number Formats Shared Lists Auditing Scenario Manager Goal Seeking Solver Databases Creating...

...Managing workbooks. Setting Up / Editing Worksheets. Entering, editing and erasing cell contents. Copying and moving cell contents. Undo and...

...Using IF and Nested IF Functions Naming Cells And Creating 3D Names Applying Names To Formulas LOOKUPfunctions Formatting Conditional formatting Customising...

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

...using AutoCalc and AutoSum Changing column widths / row heights, changing value and date display, changing cell alignment, applying borders...

...Automatic Outline Hiding and Displaying Outline Working With Visible Data Only Linking Worksheets Consolidating Worksheets Creating Hyperlinks...

...write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions.All the Open Scheduled...

...effects Templates and components Style sheets Creating style sheets External style sheets Forms Creating a form Collecting form results Frames Applying...

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

...schemes Managing data Data validation Conditional formatting Tables Creating tables Optional Tables/Sections Repeating Tables/Sections Data Sources Creating...

...This course teaches advanced-level functions and features of Outlook 2003. Students will learn how to create custom toolbars, customize the menu bar and Navigation...