PPi Learning Services courses

...Report Wizard Using Design and Layout views Automatic summary reports Creating a report manually Sorting and grouping data Adding Controls To Forms And Reports Combo...

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

...Creating rules and input masks to validate data input, navigating through the data in a table, finding and replacing data, sorting columns in tables...

...to develop a front-end application, and to design and use macros. Course Content Table Relationships Setting table relationships Multivalued Fields Referential...

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

...Create forms by using the form wizard, enhancing the design of a form. Retrieve records from a table or from several tables by writing queries...

...and date formats Auditing tools Scenario manager Creating views Goal seeking Working with lists Creating a database Using data forms Adding...

...page breaks and page break preview, headers and footers...

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

...UsingXMLdata sources Customising Excel Customising the Quick Access Toolbar Creating Templates...

...Page breaks, Page Break Preview and Page Layout view. Headers and footers...

...and linking and grouping data. Course content Formulas and Functions Data series 3D formulas Naming cells Relative and Absolute cell referencing Subtotals...

...sorting records, searching for records AutoFilter and advanced filter, database functions, data tables Creating pivot tables, calculating pivot tables...

...This course is designed to provide new users with a good understanding of the basic concepts of Excel 97 or 2000. Course content Understanding screen features...

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

...The Properties Window Visual Basic Modules Editor Options Editor Views Editing Visual Basic Code Creating Toggle Macros The Concepts of Object-Oriented...

...frames Modifying frame pages Layers and behaviours Applying layers Applying behaviours Data-driven pages Database wizards Web Parts Data Views Layout tables...

...and security Publishing a Web site Managing Web security...

...data sources Modifying data sources Creating data connections (Access,SQLServer, SharePoint) Using predefined Schemas Editing Schemas in InfoPath Views...

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