The skills and knowledge acquired in Microsoft Access Level 3 are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access. Course Content Relational database design: Designing a relational database; Scoping the system; Determining the inputs; Normalising a database; First normal form (1nf); Second normal form; Second normal form – case study; Third normal form (3nf); Database indexin... [More]

The skills and knowledge acquired in Microsoft PowerPoint Level 2 are sufficient to be able to build and enhance powerful, real-world presentations for sales, budgets, clubs and more. In this course you will learn how to enhance text in a presentation, add media features, setup a slide show and more. Course Content Text techniques Text pointers Adding text directly to a slide Formatting text Formatting paragraphs Changing bullet and numbering styles Editing text Applying simple word... [More]

Microsoft Word Level 2 extends the learner’s basic skills and knowledge of Microsoft Word and helps them create more intricate and varied documents. Existing skills and knowledge are enhanced by covering more advanced aspects of key topics such as formatting, tables, and lists, and new features such as merging, envelopes, sections, clip art and graphics are introduced. This course is ideal for people who work in an environment where there is a requirement to produce more intricate d... [More]

The skills and knowledge acquired in Microsoft Access Level 1 are sufficient to create robust relational database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data Course Content Access orientation: Understanding Microsoft Access; Starting Access; Understanding the getting started screen; Opening an existing database file; Understanding the access screen; Working with the navigation pane; Working with a ... [More]

Improve the way you manage and present information and take the legwork out of calculations and data manipulation with this powerful software. This course provides the learner with the skills and knowledge necessary to create workbooks in Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting. Course Content Getting to know Excel Starting Excel The Excel screen Using the ribbon Using keytip badges Minimising the ri... [More]

Microsoft Excel Level 3 focuses on the more advanced features of Excel. Advanced analysis tools, especially pivot tables, solver, outlining and summarising are covered, as are some key automation features such as macros. Course Content Lookup functions: Understanding data lookup functions; Using CHOOSE; Using VLOOKUP; Using VLOOKUP for Exact Matches; Using HLOOKUP; Using INDEX; Using MATCH; Understanding reference functions; Using ROW and ROWS; Using COLUMN and COLUMNS; Using ADDRES... [More]

The aim of this course is to build on the introductory skills of Level 1. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries and will be introduced to some basic automation techniques involving macros. Course Content Data validation: Assigning default values; Validation rules and text; Validating numbers; Setting required fields; Working with validations Querying techniques: Modifying a saved query; Creating and queries;... [More]

Become productive in just two days by acquiring a basic understanding of Word, Excel, PowerPoint, and Outlook and learn to share data between these applications. This course represents excellent value for money! Course Content AT HOME IN OFFICE: Understanding Microsoft Office; Starting Microsoft Office Applications; A Typical Application Screen; Working With Screen Features; Understanding Dialog Boxes; Launching Dialog Boxes; The Office Button; Understanding How Help Works; Accessin... [More]

Microsoft Excel Level 2 is the second of a 3-Level study program for Microsoft Excel. This level extends the learner’s basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features and working more effectively with existing worksheets and workbooks. Course Content Filling data: Fil... [More]

Learn how to use a combination of Excel and VBA to improve your productivity, adding power and flexibility to spreadsheets by creating user-defined functions. Basic knowledge of Excel is assumed but no programming knowledge is required. Course Content Recorded Macros: Understanding excel macros; Setting macro security; Saving a document as macro enabled; Recording a simple macro; Running a recorded macro; Relative cell references; Running a macro with relative references; Viewing a ... [More]