8 training courses found
This course introduces user to the process of writing and editing MACROS. No previosu experience is assumed.
This course will provide the skills needed to create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. It covers: looking at the excel environment, working with an excel worksheet, modifying a worksheet, performing calculations, formatting a worksheet, developing a workbook and customizing layout.
This 1 day course builds on the topics covered in part 1. In part 2 we look at topics scuh as Forms, Erroe Handling and Office Automation.
In this course, participants will have the basic skills within Microsoft Office Access 2013 databases, including creating and working with Access tables, relationships, queries, forms, and reports. It covers: cover data, queries, reports and sharing, controlling data entry, joining tables, manipulating flexible queries, form design and enhancement, customizing reports and sharing data across applications.
In this course, participants will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access relational database application. It covers: access environment, database design, building a database, managing data in a table, querying a database, designing forms and creating reports.
During this Intermediate/Advanced training day we concentrate on Macros, Database Utilities, Security and create a Switchboard. Topics we cover include MACROS - creating, editing and deleting submacros.
In this training course we look at all of the aspects of creating and manipulating Pivot Tables. A Pivot table is an interactive table that quickly summarizes large amounts of numeric data so you can analyse it in detail.
In this course, participants will develop their skills to streamline, enhance spreadsheets by using template, charts and graphics. It covers: enhancing workbooks, creating workbooks using templates, presenting data using charts, pivot tables and pivot charts, calculating data with advanced formulas, sorting and filtering data.