| For more info call 0208 559 8097 |  |
 |
 |
Category Archives: IT Training |
Using Multiple Worksheets and Workbooks Using Multiple Worksheets Inserting New Worksheets Renaming Worksheets Deleting Worksheets Creating Multiple Views Freezing Panes   Viewing and Arranging Multiple Worksheet Windows Navigating in Multiple Workbooks Selecting and Viewing Multiple Workbooks Managing Multiple Worksheets and Workbooks Selecting Multiple Worksheets Moving and Copying Data between Worksheets Linking Data Between Worksheets Creating a 3-D Formula Assignment Charting Using Charts Creating a Chart Changing Chart Type, Style…
Managing Relational Databases Database Concepts Database Design Normalisation Database Integrity Types of Relationship Creating Table Links Referential Integrity Advanced Forms Customising List And Combo Boxes Check Boxes, Option & Toggle Buttons. Option Groups Command Buttons Calculated Fields. Using Form’s Input Values Create A Form With Multiple Pages Or Tabs Tab Order Inserting Graphics in Forms or Reports AutoFormat Optimising and Administering Access Optimising Performance The Performance Analyzer The Add in…
Action Queries Types Of Query The Crosstab Query The Make Table Query The Append Query The Delete Query The Update Query Customising Forms Manipulating Data in the Form Creating A New Form Using the Form Wizard Creating a Form With a Subform Modifying and Redesigning the Form Reports The Report Wizard Creating a Report With Summary Totals Using the Label Wizard Modifying and Redesigning the Report. Publishing Access Data on…
Explore the Word Environment Screen overview Explore the ribbon Working with backstage view Customise the Word environment Open a document Navigate in a document Create a Microsoft account Connect to OneDrive or OneDrive for Business Use help Turn on the reading view Tell me what you want to do (new) Creating a Document Enter text Save a document Viewing the document version history (new) Creating folders Preview a document Modify…
Introduction to Desktop Publishing Working with Publisher Drawing objects Cut, Copy and Paste Working with the clipboard Selecting Objects The Format tab Undo Create a Publication Save a publication Print a Publication Print preview and print options Photo centre Printing Using Help Page Setup Using Guides and Rulers Create and use a Background Page Manage Pages Set Custom Page Types Create and use Headers and Footers Use Page Numbering Set…
Exploring the PowerPoint Environment Customise the Quick Access Toolbar Working with the Ribbon Backstage view Opening and closing a presentation Connect to OneDrive or Business Drive Perform a Smart Lookup (new) Tell me what you want to do (new) Creating a New Presentation Using a new presentation Using wide screen themes Saving the presentation Adding a new slide to a presentation Adding text to a slide Editing text on a…
Getting Started with Outlook Starting Outlook The Outlook interface, toolbars and menu Outlook Ribbon Backstage view Tell me Navigation Pane and Folder List To – Do bar Working with folder views Zoom control Creating mail folders Exiting Outlook Mail: The Basics Creating a new email message To, CC and BCC Addressing an email Sending an email Receiving an email Working with the Reading Pane Previewing messages in message list Replying…
Getting Started Setting up a Microsoft account Connect to OneDrive or Business Drive Tell me what you want to do (new) Starting and exiting from Excel Using the Excel ribbon Customize the ribbon Displaying help information Changing the file type and converting to PDF Using and creating Custom Lists Creating and Modifying Existing Worksheets Using Excel 2016 sample templates (new) Creating and opening workbooks Adding data to a worksheet Selecting…
Introduction to MS Access What is an Access Table? What is an Access Query? What is an Access Form? What is an Access Report? What is Tell Me (new)? Working with MS Access Starting Access Exploring backstage view Using the Access ribbon Opening an existing Access database Navigating Access Quitting Access Launch Access from a modern template (new) Working with Tables Opening an existing Access table Adding, editing and deleting…
Resource Techniques What are over-allocations Identifying over-allocated tasks Task inspector Viewing resource assignments and finding over-allocations Viewing the project critical path Resource levelling explained Levelling options Applying levelling  Uses of the levelling Gantt Applying the levelling Gantt Clear levelling Baselines Why save a baseline Saving, removing and revising the baseline Adding new tasks to an existing baseline Multiple baselines Multiple Project Plans Why use multiple project plans Creating a…