PPi Learning Services courses

...Quick Access Toolbar, Tabbed Documents, * Status bar and Mini toolbar Database objects Creating Tables Using Table Templates and manually creating tables...

...This course enables existing Access users to create database applications using Access forms and macros. Course content Create table relationships and default joins...

...adding search criteria to restrict the records that are retrieved, using parameter queries to allow the user to input query criteria. Changing the joins...

...Integrity Cascade Updates and Cascade Deletes Linking to other databases Advanced Queries Updating a table via a query Querying queries IIFstatements Advanced...

...Link to tables in other databases. Import from, or export to other data sources, such as text files or Excel spreadsheets. Create conditional expressions...

...using the expression builder. Sort and group data and print a report...

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

...functions and the formula palette, using AutoCalc and AutoSum Changing column widths / row heights, changing value and date display, changing cell alignment...

...hiding and un-hiding files, rows and columns Conditional formatting Creating 2D and 3D charts Formatting charts Inserting and clearing data Naming cells...

...and working with Databases and PivotTables. You will also learn how to customise the Excel menus and toolbars as well as create your own templates. Course...

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

...This course is designed to provide an existing Excel user with further knowledge about building formulas and functions, outlining worksheets...

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

...entering, editing and erasing cell contents, copying and moving cell contents, undo and redo Simple calculations and priorities, functions and the formula palette...

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

...The InputBox Function Creating UserForms Working with Form Controls and the Control Toolbox Adding Code to Forms Displaying Forms with Module-Based...

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

...Lists Proofing tools Hyperlinks Internal links External links Navigation bars and shared borders Renaming pages Images Images Photo galleries Image links...

...forms Form layouts Adding form controls Linking controls to data source elements Setting control properties Linking controls to databases Using colour...

...forms, public folders, newsgroups, and Outlook's security features. This course is approved courseware for Microsoft Office Specialist certification...