Desktop
Applications
Training
Unlock the power of desktop applications with our comprehensive range of training programmes.
Return to 
Contact Us
Return to
Contact Us
Unlock the power of desktop applications with our comprehensive range of training programmes.
Brought to you by
This one-day training equips your staff with the practical skills to use Microsoft Copilot across Office 365 effectively.
Course OverviewThis course offers a comprehensive introduction to Generative AI, covering its history, capabilities, applications, and ethical considerations such as online safety, plagiarism, and quality assurance.
Course OverviewGain a deep understanding of the powerful apps and features available with Microsoft 365.
Course OverviewMicrosoft Access 365 is a powerful tool for designing and improving databases.
Course OverviewMicrosoft Excel 365 is a powerful application for the creation and management of workbooks for professional use.
Course OverviewDiscover OneNote notebooks, capable of storing content in an organised structure, that you can share with others and access from anywhere.
Course OverviewPower BI is a robust business intelligence tool developed by Microsoft, designed to help users convert raw data into insightful visualisations and reports.
Course OverviewPowerPoint 365 is a powerful presentations application, which allows the user to create intuitive presentations for paper, screen or web output.
Course OverviewMicrosoft Project 2016 is a suite of tools for efficient project and portfolio management.
Course OverviewEquip yourself with the essential skills and knowledge to effectively use SharePoint for storing, sharing, and collaborating with others.
Course OverviewMicrosoft Word 365 combines a powerful word processing application with the user-friendly atmosphere of Windows.
Course OverviewThis one-day training equips your staff with the practical skills to use Microsoft Copilot across Office 365 effectively. It’s designed for teams who already use Microsoft 365 and want to work smarter, not harder.
Benefits to your organisation
Microsoft Copilot Introduction
This one-day training equips your staff with the practical skills to use Microsoft Copilot across Office 365 effectively. It’s designed for teams who already use Microsoft 365 and want to work smarter, not harder. You will cover:
This course is ideal for office professionals, administrators, marketing and operations staff who want to increase productivity and quality of work using tools they already have. You will need:
This course offers a comprehensive introduction to Generative AI, covering its history, capabilities, applications, and ethical considerations such as online safety, plagiarism, and quality assurance. Through hands-on practice and group collaboration, participants will learn to effectively use AI tools to generate text, images, music, videos, and code.
Fundamentals of AI in business
This course offers an engaging and practical introduction to the world of Generative AI, designed for learners who are curious about how artificial intelligence is shaping creativity, communication, and productivity across industries. Beginning with a brief history of AI, participants will explore how the technology has evolved over time—from early rule-based systems to the advanced generative models we see today. The course will then dive into the capabilities and applications of Generative AI, including how it can be used to create text, images, music, videos, and even code. Participants will gain hands-on experience using a range of cutting-edge AI tools to explore these creative possibilities in real-time.
Throughout the course, learners will be encouraged to think critically about the advantages and potential drawbacks of AI. Topics such as misinformation, bias, and ethical concerns will be discussed alongside the many benefits of AI, such as increased efficiency, innovation, and accessibility. A strong emphasis will also be placed on online safety, with clear guidance on how to avoid plagiarism, check the quality of AI-generated content, and ensure responsible use of these tools. Participants will learn to interact effectively with AI systems by crafting clear and purposeful prompts, refining outputs, and applying Retrieval-Augmented Generation (RAG) techniques to enhance performance.
In addition to individual exploration, the course includes group study sessions where participants collaborate and share ideas while using AI tools in practical, creative ways. By the end of the course, learners will be confident in their ability to use Generative AI across multiple media formats, understand the ethical considerations involved, and participate in discussions and collaborations involving this rapidly evolving technology.
WHAT’S COVERED:
BY THE END OF THE SESSION YOU WILL BE ABLE TO:
COURSE REQUIREMENTS:
With our comprehensive suite of user training courses, your team will gain a deep understanding of the powerful apps and features available with Microsoft 365, and gain the skills to utilise them to boost productivity.
Designed for businesses seeking to maximise their investment, this course will empower you to harness the full potential of your Microsoft 365 subscription.
Microsoft 365 Overview
Learn how to:
Module 1: Introduction to Online Versions of Core Apps
• Excel, Word, PowerPoint, and Outlook.
Module 2: Office 365 App Launcher Overview
• Navigating between applications.
Module 3: OneDrive
• File storage, organisation and sharing
• Managing folders and permissions.
Module 4: SharePoint
• Creating a site, adding web parts
• Managing document libraries and version history.
Module 5: Microsoft Forms
• Creating interactive surveys and quizzes
• Sharing and collecting responses.
Module 6: OneNote
• Creating notebooks, sections and pages
• Attaching files and collaborating in real-time.
Module 7: Microsoft To Do
• Creating personal and shared task lists
• Managing groups and priorities.
Module 8: Planner
• Creating, assigning and sharing plans.
• Switching between Board, Charts, and Schedule view.
Module 9: Microsoft Teams
• Creating Teams and Channels
• Hosting meetings, sharing screens and using chat.
Module 10: Microsoft Lists
• Creating structured lists
• Adding lookups, formulas and conditional formatting
• Linking to Microsoft Access for advanced usage.
This course is suitable for anyone who may need to use Teams as a virtual delivery platform.
Delegates should have an understanding of any of the following operating systems:
• Windows 98/NT/2000/ME/XP/VISTA/7/8/10.
Training participants will learn the essential skills needed to design new databases, improve existing Access databases, and convert databases made in other applications.
Higher level courses are ideal for individuals with experience of database design who are looking to design or improve databases at an advanced level.
Introduction
Learn how to:
Intermediate
Learn how to:
Advanced
Learn how to:
Module 1: Introduction to Databases
• Database Concepts
• Database Layout
• Launching Access
• The Access Menu System
• Dialog Boxes
• Getting Help
• Creating a New Database
• Creating an Access Web App
• Closing a Database (Vs Exit Access)
• Opening a Database.
Module 2: Tables
• Database Design
• Creating Tables Using The Table Wizard
• Creating Tables In The Datasheet View
• Creating Tables In The Design View
• Data Types
• Field Properties
• Data Display Format Vs Input Mask
• The Input Mask
• Data Entry Problems
• Moving And Copying Records.
Module 3: Working with Tables
• Pasting Records
• Sorting The Table
• Deleting a Table
• Table Layout Changes
• Find
• Replace
• Wildcards.
Module 4: Queries
• The Simple Query Wizard
• The Design View
• Modifying The Query
• Using Basic Criteria
• Additional Criteria
• Parameters
• Multiple Object Queries
• Custom Calculations In A Query
• Calculating Fields Continued
• Grouping Fields.
Module 5: Introduction to Reports
• Reports
• The Report Wizard.
Module 6: Introduction to Emailing Database Information
• E-Mailing Database Information.
This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.
Module 1: Action Queries
• Types Of Query
• The Crosstab Query
• The Make Table Query
• The Append Query
• The Delete Query
• The Update Query.
Module 2: 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.
Module 3: Reports
• The Report Wizard
• Creating A Report With Summary Totals
• Using the Label Wizard
• Modifying and Redesigning the Report
• Publishing Access Data on the Web.
Module 4: Protecting Desktop Databases with Backup and Restore Processes
• Why do I need a backup?
• Creating a Database Backup
• Creating a Split Database
• Backing up back-end database and front-end database
• Restoring a Database.
Module 5: Backwords Compatibility
• E-mailing Database Information.
This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access. The course aims to build on some existing database design and/or user experience that may have been gained from the Introduction course.
Module 1: Managing relational databases
• Database Concepts
• Database Design
• Normalisation
• Database Integrity
• Types of Relationship
• Creating Table Links
• Referential Integrity.
Module 2: 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.
Module 3: Optimising and Administering Access
• Optimising Performance
• The Performance Analyzer
• The Add in Manager
• Compacting Your Database
• The Database Documentor
• The Database Splitter
• Recovering Damaged Databases
• Importing and Linking Tables.
Module 4: Backwards Compatibility
• E-mailing Database Information.
Module 5: Introduction to SQL (Fundamentals)
• Introduction
• Data Definition Language
• Data Manipulation Language.
This course assumes a reasonable level of database design principles. The course is designed to build on a reasonable level of database design experience that may have been gained from the Introduction and/or Intermediate course.
Training participants will learn the essential skills needed to confidently navigate Excel, manage data, perform basic calculations, and format workbooks effectively for professional use.
Higher level courses are ideal for individuals who use Excel as a powerful analysis tool, working with advanced functions, automation tools, and data validation techniques, all designed to improve data handling and analysis.
Introduction
Learn how to:
Intermediate
Learn how to:
Advanced
Learn how to:
MACROS
Learn how to:
Module 1: Getting Started with Excel 365
Module 2: Modifying a Workbook
Module 3: Using Formulas and Functions
Module 4: Formatting an Excel Worksheet
Module 5: Managing Worksheets and Workbooks
Module 6: Printing Options
This course is designed for delegates with little or no experience in Microsoft Excel. It provides the essential skills needed to confidently navigate Excel, manage data, perform basic calculations, and format workbooks effectively for professional use.
Module 1: Automating a workbook
• Linking sheets and workbooks using group functions
• Password-protecting sheets, specific sections, and entire workbooks
• Saving workbooks as templates.
Module 2: Working with data and formatting
• Using Paste Special and linking data into Word or PowerPoint
• Naming cells and ranges for improved formula management
• Implementing named ranges in formulae
• Editing array formulas
• Understanding spill error messages.
Module 3: Conditional Formatting
• Applying conditional formatting for cells and ranges
• Editing icon and colour scale formats
• Using formulae within conditional formatting.
Module 4: Excel Functions
• Logical functions: IF, IFS, IFERROR
• Lookup functions: LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP
• Mathematical functions: SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS
• Date functions: TODAY, NOW, DAY, MONTH, YEAR
• Advanced functions: FILTER and TAKE.
Module 5: Advanced Charts
• Creating charts with two axes
• Using map charts for geographical data
• Creating waterfall charts for financial analysis.
This course is designed for professionals who have a basic understanding of Excel and want to develop their skills further. The course builds on foundational Excel knowledge, focusing on automation, data linking, advanced functions, and enhanced data visualisation techniques.
Module 1: Formula Auditing
• What is it?
• Trace Precedents
• Trace Dependents
• Show Formulas
• Error Checking
• Evaluate Formula
• Watch Window.
Module 2: Analysis Tools
• Advanced Filter
• Subtotal
• What – If Analysis: Goal Seek
• What – If Analysis: Data Tables
• What – If Analysis: Scenario Manager
• Analyze Data.
Module 3: Macros
• Overview
• VBA macros.
Module 4: Get Data
• Overview
• From Microsoft Access Database
• From Web.
Module 5: Data Integrity
• Data Validation
• Password Protection.
Module 6: Data Types
• Linked Data Types.
Module 7: Dashboard
• PivotTables
• PivotCharts
• Slicers & Timelines.
This course is ideal for delegates who are very familiar with Microsoft Excel and can use intermediate functions. The course is designed to enhance efficiency with advanced functions, automation tools, and data validation techniques, ensuring users can confidently manipulate and interpret large datasets.
Module 1: Introduction and the Macro Recorder
• Introduction
• Demonstration
• Recording a macro
• Recording a macro with absolute references
• The personal macro workbook
• Assigning shortcut keys
• Deleting macros
• Excel’s New File Format
• Recording a macro with relative references.
Module 2: Creating and Editing Macros with VBA Macro Functions
• Macro storage concepts
• The VBA program (the VB editor)
• The program components
• Storing and handling macros (modules)
• Introduction to editing code
• Copying and pasting procedures
• Linking procedures together
• Create and use a user-defined function
• Auto-executable macros.
Module 3: Objects and Dialog Boxes
• Introduction to objects
• The object browser
• Using the object browser and searching it
• Built-in dialog boxes
• User defined dialog boxes (message boxes and input boxes).
Module 4: Introduction to Controls
• Worksheet controls
• User forms
• Assign Macros to the Ribbon or Quick Access Toolbar
• Accessing Macros in Excel.
Module 5: Selected VBA Procedures
• IF…THEN…ELSE (Conditional Control Structure)
• SELECT CASE (Branching)
• The DO…LOOP control structure
• The FOR…NEXT control structure.
This course is designed for Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users’ work) in the application using macros.
Delegates should have a good grounding in Excel (any version) and be familiar with absolute vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage.
Training participants will learn the essential skills needed to make the most out of the Microsoft OneNote interface.
This course will explain how OneNote has been designed as a tool for note taking, information gathering and multi-user collaboration.
Introduction
Learn how to:
Module 1: What is OneNote?
• The OneNote Environment and exploring the interface
• Getting Help.
Module 2: Getting Started
• Create a New Notebook.
• Enter and format Notes
• Organise Information with Sections and Pages.
Module 3: Customise the OneNote View
• Managing Pages
• Inserting Text and Graphics
• Add images, links and drawing objects to a notebook.
Module 4: Keeps Tracks
• OneNote with other Applications
• Sharing OneNote
• Working with shared Notebooks.
This course will introduce users to OneNote notebooks, capable of storing content in an organised structure, that you can share with others and access from anywhere. The course will also cover how OneNote can be integrated with applications to increase your productivity with Microsoft Office.
Delegates should have an understanding of any of the following operating systems:
• Windows 98/NT/2000/ME/XP/VISTA/7/8/10.
Power BI is a robust business intelligence tool developed by Microsoft, designed to help users convert raw data into insightful visualisations and reports.
Introduction
This one-day course provides entry-level users with the basic skills required to Import, Transform, and Publish data using Power BI Desktop.
This one-day course provides entry-level users with the basic skills required to Import, Transform, and Publish data using Power BI Desktop.
This course also gives a brief overview of the Power BI Service which enables the user to create and share dashboards for use by their organisation.
Module 1: What is Power BI
Module 2: Power BI Building Blocks
Module 3: Connecting to Data
Module 4: Shaping and Transforming Data
Module 5: Creating and Managing Relationships in Power BI Desktop
Module 6: Data Fundamentals
Module 7: Working With Reports
Module 8: Sharing your Work
By the end of the course, delegates will have an understanding of the key features of Power BI, including:
The primary target audience for this course is data analysts who want to a summary of what Power BI can offer them in terms of BI Analysis, and who also may want to go on to the more advanced 20778 course.
The secondary audience for this course are technically proficient data users.
PowerPoint 365 is a powerful presentations application, which allows the user to create intuitive presentations for paper, screen or web output.
Introduction
Learn how to:
Intermediate
Learn how to:
Module 1: PowerPoint Basics
• Foreword
• Getting started with PowerPoint 365
• Starting PowerPoint
• Opening an existing presentation
• Identifying elements of the PowerPoint window
• The ribbon
• Moving between slides
• Using PowerPoint help and the Tell Me box
• Changing PowerPoint views
• Changing the zoom level
• Viewing the presentation in outline view
• Viewing the presentation in slide sorter view
• Ending a PowerPoint session
• Closing a presentation
• Assignment.
Module 2: Creating a Presentation
• Beginning a New Presentation
• Downloading a Microsoft Office Online Template
• Adding Text and Slides
• Adding a New Slides in Normal View
• Entering Text in a Bulleted List
• Adding Slides and Text in Outline View
• Using AutoCorrect
• Editing Text and Slides
• Using the Undo and Redo Commands
• Using Find and Replace
• Deleting Slides
• Assignment.
Module 3: Enhancing a Presentation
• Changing Text Appearance
• Changing the Font Size
• Applying Font Styles and Effects
• Changing Text Colour
• Aligning Text
• Adjusting Line Spacing
• Using the Rulers
• Changing Slide Sequence
• Rearranging Slides in Outline View
• Creating Notes Pages and Handouts
• Formatting Handouts
• Printing Notes Pages and Handouts
• Checking Your Work
• Assignment.
Module 4: Adding Visual Interest
• Illustrations – Shapes
• Drawing Lines, Straight and Curved
• Drawing Other Shapes
• Drawing Shapes in Proportion
• Sizing Shapes
• Selecting and Deselecting Objects
• Duplicating an Object
• Editing Objects
• Changing Line Colours and Applying Shadows
• Moving Objects
• Resizing Objects
• Adding Text to Objects
• Adding Images to Slides
• Assignment.
This course is designed for delegates with little or no experience in Microsoft PowerPoint.
Delegates should have an understanding of any Windows operating system.
Module 1: Customising PowerPoint
• Customising PowerPoint 365
• How to change the default format of the blank presentation
• How to change the Default Language Setting
• How to change the default Display options
• How to change the default Spelling options
• How to change Presentation Properties and Information
• How to change the default Save and changing Default Folder options
• About the Quick Access Toolbar
• How to customize the Quick Access Toolbar:
• Add-in programs
• How to Load an add-in program
• How to unload an add-in program.
Module 2: Working with Objects
• How to insert a Table
• How to insert rows/Columns
• How to delete rows/columns
• How to merge Cells
• How to add Borders
• How to Colour a Table
• Sorting a table in PowerPoint
• Organisation Charts
• How to insert an Organisation Chart
• How to edit an Organisation Chart
• Inserting New SmartArt Elements
• Deleting Shapes
• How to convert a box from one type to another
• How to change shape border and border colour
• How to change the Fill Colour of a Shape
• Creating Charts
• How to insert a Chart
• Editing the Chart
• How to change the Chart Type
• How to change Chart Attributes
• How to insert an Excel Worksheet.
Module 3: Drawing Tools
• Drawing Options
• Drawn objects have attributes, just like other objects.
• Drawing Shapes
• How to draw circles, squares, and Auto Shapes
• How to change the Fill Colour of a shape
• How to change the fill effect of a shape
• How to change the line border and border colour of a shape
• Editing shapes
• How to resize a shape
• How to type text in a shape
• Group and Ungroup Objects
• Group objects
• Ungroup objects.
Module 4: Controlling the Overall Look
• Presentation Designs
• How to apply a Design Theme
• How to apply a Theme and Variant colour scheme to a presentation
• How to create a custom colour scheme for your slides
• How to add a Textured or Picture Background to your slides
• How to add a Patterned Background to your slides
• Working with Slide Masters
• How to view Slide Masters
• Make a slide that differs from the slide master
• Make an object appear on every slide in the presentation
• Templates and Themes
• How to Open an Existing Template
• How to create your own Template
• How to Download a Template.
Module 5: Slide Shows
• Viewing a Presentation
• Normal view
• PowerPoint Example of Normal View
• Outline View
• PowerPoint Example of Outline View
• Slide Sorter View
• PowerPoint Example of Slide Sorter View
• Notes View
• PowerPoint Example of Notes Page View
• Reading View
• PowerPoint Example of Slide Sorter View
• Running Slideshows
• Running the show
• Continuous loop
• Transitions
• Timing
• Hidden slide
• Keyboard control
• Build slide
• Electronic Presentations
• Hints for creating and running slide shows
• Animating slides
• How to apply Transition effects to a Slide
• How to add Animations to a slide
• How to set slide timings while rehearsing
• How to run a slide show
• Write or draw (annotate) on slides during a slide show
• Erase annotations during a slide show
• Magnify areas of slides during a slide show
• How to create a loop Slide Show
• Package for CD
• Prepare a presentation for use on another computer.
Module 6: PowerPoint on the Web
• Remote Presentations
• How to start a Presentation Broadcast
• How to create a Video
• How to publish your presentation as a PDF or XPS
• About hyperlinks in a presentation
• Add, edit, and remove hyperlinks in a presentation
• How to create a hyperlink in a presentation
• How to create an email hyperlink in a presentation
• How to change a hyperlink destination
• How to Change hyperlink text
• How to remove the hyperlink, but not the text or object that represents it
• How to remove a hyperlink and the text or object that represents it
• Set a hyperlink base for a presentation.
Module 7: Using MACROS in PowerPoint
• Automating tasks you perform frequently
• How to Show the Developer Tab
• How to create a new macro
• How to edit a Macro
• How to run a macro
• How to delete a Macro
• How to attach a macro to the Quick Access Toolbar
• How to check presentations for macros that might contain viruses.
Module 8: Sharing and Co-Authoring
• Sharing and Co-authoring
• About OneDrive.
Delegates should have attended the Microsoft PowerPoint 365 Introduction (MSPP365-01).
Training participants will learn the essential skills needed for efficient project and portfolio management.
This course covers the basics of Project Management and gets delegates to the point where they can create and begin to track a Project.
Microsoft Project 365 Overview
Learn how to:
Microsoft Project 365 Masterclass
Learn how to:
Module 1: Creating a Task List
• Getting Started
• What is a Project?
• Ribbon Overview
• Views/Tables/forms
• View bar
• Entry bar
• Auto Schedule/Manual
• Schedule options
• Project information
• Creating a task List
• Summary Tasks
• Indenting
• Recurring tasks
• Milestone Task
• Moving tasks
• Deleting Tasks
• Using the mouse
• Exercise 1.
Module 2: Adjust a Project
• Formatting the Gantt chart
• Task Name
• Line styles/Text styles
• Non-working time colours
• Timescale
• Adjust the timescale.
• One tier/Two tiers/Three tiers
• Filters/Grouping and Highlight
• Project Calendar
• Exceptions
• Work weeks
• Different time zones (summer working)
• New
• Print Preview
• Header and Footers/project fields/Legend page
• Print project range
• Embedding docs in tasks
• Linked/Icon
• New/icon
• Exercise 2.
Module 3: Link Management
• Linking tasks
• FS/SS/FF/SF
• Lead and Lag
• Split Tasks
• Task Constraints
• Deadline Markers
• Exercise 3.
Module 4: Allocating Resources
• Resource sheet
• Work/material/cost
• Assign resources.
• Assign consumables.
• Change a resource availability.
• Change a resource calendar.
• Exercise 4.
Module 5: Baselines and Reports
• Save a baseline.
• Tracking view and table
• Add columns.
• Update tasks
• Run reports
• Project overview
• Cost overview
• Create a new report
• Exercise 5.
Module 6: Final Exercise
Module 7: Appendix A
• What is Project Management?
Microsoft Project 2016 is a suite of tools for efficient project and portfolio management. It is designed to help users set realistic goals for project teams and customers by creating schedules, distributing resources and managing budgets. This course is a good introduction for anyone who wants to learn to use Microsoft Project as the tool for them and their team.
Module 1: Creating a Task List
• Getting Started
• What is a Project?
• Ribbon Overview
• Views/Tables/forms
• View bar
• Entry bar
• Auto Schedule/Manual
• Schedule options
• Project information
• Creating a task List
• Summary Tasks
• Indenting
• Recurring tasks
• Milestone Task
• Moving tasks
• Deleting Tasks
• Using the mouse
• Exercise 1.
Module 2: Adjusting a Project
• Formatting the Gantt chart
• Task Name
• Line styles/Text styles
• Non-working time colours
• Timescale
• Adjust the timescale.
• One tier/Two tiers/Three tiers
• Filters/Grouping and Highlight
• Project Calendar
• Exceptions
• Work weeks
• Different time zones (summer working)
• New
• Print Preview
• Header and Footers/project fields/Legend page
• Print project range
• Embedding docs in tasks
• Linked/Icon
• New/icon
• Exercise 2.
Module 3: Link Management
• Linking tasks
• FS/SS/FF/SF
• Lead and Lag
• Split Tasks
• Task Constraints
• Deadline Markers
• Exercise 3.
Module 4: Allocating Resources
• Resource sheet
• Work/material/cost
• Assign resources.
• Assign consumables.
• Change a resource availability.
• Change a resource calendar.
• Use a resource pool.
• Resource levelling
• Task types
• Exercise 4.
Module 5: Views
• Network View/ New Template
• Task Usage
• Resource usage/ Form
• Timeline
• Team Planner
• Split screen
• Resource Graph
• New Views
• Exercise 5.
Module 6: Baselines and Reports
• Save a baseline.
• Tracking view and table
• Add columns.
• Update tasks
• Run reports
• Project overview
• Cost overview
• Create a new report.
• Using Visual reports
• Exercise 6.
Module 7: Customisations
• Custom Fields
• Drop down list.
• IIF function/Graphical indicators
• DateDiff Function
• New table
• Export to Excel/Using Paste Special and link.
• Export to Excel using the map feature.
• Customise Gantt chart icons using flag fields.
• Master Project file
• Sub project
• Paste link tasks.
Module 8: Final Exercise
Module 9: Appendix A
• What is Project Management?
Microsoft Project 2016 is a suite of tools for efficient project and portfolio management. It is designed to help users set realistic goals for project teams and customers by creating schedules, distributing resources and managing budgets. This course is a good introduction for anyone who wants to learn to use Microsoft Project as the tool for them and their team.
The aim of this SharePoint course is to equip you with the essential skills and knowledge to effectively use SharePoint for storing, sharing, and collaborating with others.
Introduction
Learn how to:
The aim of this SharePoint course is to equip you with the essential skills and knowledge to effectively use SharePoint for storing, sharing, and collaborating with others.
Module one: What is a SharePoint site
Module two: Create a site and manage web parts
Module three: Create News Posts
Module four: Edit navigation pane and site features
Module five: Document Libraries and version Control
Module six: Lists – lookup – linked to Access
Module seven: Permissions
By the end of the course, you will be able to confidently navigate the SharePoint interface, create sites, manage and understand library structures, and use and manage lists.
Delegates should have an understanding of any of the following operating systems:
Training participants will learn the basics of creating, editing, and saving documents in our Fundamentals level class. They will learn to use Online Help and to modify and enhance character appearance.
Participants will format text into tabular columns, create and manage tables, use error-checking tools, and control page layout with margins, indents, and page breaks.
Introduction
Learn how to:
Intermediate
Learn how to:
Advanced
Learn how to:
Module 1: Creating and editing documents
• Starting documents
• Starting Word
• Identifying components of the Word screen
• The Word ribbon
• Creating and opening documents
• Moving the insertion/cursor point
• Building and editing documents
• Selecting text
• Replacing and deleting blocks of text
• Moving and copying text
• Modifying page breaks
• Finishing documents
• Previewing documents
• Printing documents
• Closing documents
• Assignment.
Module 2: Formatting text
• Enhancing text
• Applying text formatting effects
• Removing text formatting
• Using undo and redo
• Using the repeat command to apply formatting
• Viewing and copying formatting
• Using format painter
• Using bullets and numbers
• Applying bullets and numbers as your type
• Assignment.
Module 3: Formatting documents
• Formatting paragraphs
• Changing line or paragraph spacing
• The ruler
• Indenting paragraphs
• Setting tabs using the Tabs Dialogue box
• Setting tabs using the ruler
• Formatting pages and sections
• Setting margins
• Inserting page numbers
• Inserting and deleting sections breaks
• Using the Go To command
• Applying page setup formatting to sections
• Changing a section’s page numbering
• Assignment.
Module 4: Using Advanced Page Setup Techniques
• Using headers and footers
• Creating alternating headers and footers
• Creating section headers and footers
• Using styles and templates
• Managing the quick style gallery
• Templates
• Using templates to create documents
• Generating envelopes and labels
• Creating labels
• Assignment.
Appendix A: New Features in Word 365
• Compatibility
• The Office interface
• The Word screen
• The Ribbon
• Dialogue box launchers
• Contextual tabs
• Customise the ribbon
• The mini toolbar
• The quick access toolbar
• Using the keyboard
• Other new features in Word
• File menu options
• Screen views and document navigation
• New graphics features
• Sharing documents
• Tracking
• Touch access
• Tell me feature
• Working together
• Insights
• Ink equations
• Version history.
Delegates should have an understanding of any of the following operating systems:
• Windows 98/NT/2000/ME/XP/VISTA/7/8/10.
Module 1: Reviewing Documents
• Correcting documents
• Performing a spelling and grammar check
• Using the Thesaurus
• Using autocorrect options
• Setting and deleting autocorrect exceptions
• Hyphenating documents
• Inserting special hyphens
• Using quick part building blocks
• Creating a quick part
• Inserting a quick part
• Deleting quick part entries
• Creating outlines
• Typing outline lists
• Assigning and removing paragraph outline levels
• Using the navigation pane
• File search – to find a file
• Insert a comment
• Insert a picture from a file
• Assignment.
Module 2: Drawing in Word
• Creating drawing objects
• Creating lines and shapes
• Creating text boxes
• Enhancing drawing objects
• Applying line effects
• Applying and modifying 3D effects
• Manipulating drawing objects
• Sizing and rotating drawing objects
• Grouping and ungrouping drawing objects
• Placing drawings within document text
• Assignment.
Module 3: Using Tables
• Creating tables
• Typing text into tables
• Editing and formatting text in cells
• Modifying table structures
• Adjusting row height in a table
• Inserting, deleting and moving table columns
• Inserting, deleting and moving table rows
• Enhancing tables
• Merging cells
• Adding table borders
• Table design styles and applying shading to a table
• Aligning tables
• Rotating text in tables
• Convert text to a table or vice versa
• Autofit in the table
• Assignment.
Module 4: Working with Columns
• Creating and editing newspaper columns
• Selecting and editing column text
• Formatting newspaper columns
• Forcing a new column
• Setting text flow options
• Inserting nonbreaking spaces
• Change case
• Change a background
• Drop cap
• Assignment.
Appendix A: New Features in Word 365
• Compatibility
• The Office interface
• The Word screen
• The Ribbon
• Dialogue box launchers
• Contextual tabs
• Customise the ribbon
• The mini toolbar
• The quick access toolbar
• Using the keyboard
• Other new features in Word
• File menu options
• Screen views and document navigation
• New graphics features
• Sharing documents
• Tracking
• Touch access
• Tell me feature
• Working together
• Insights
• Ink equations
• Version history.
Delegates should have an understanding of any of the following operating systems:
• Windows 98/NT/2000/ME/XP/VISTA/7/8/10.
Module 1: Sorting and Merging Text and Data
• Sorting
• Merging
• Protecting a document.
Module 2: Working with Formulas, Worksheets and Charts
• Calculating in tables
• Using formulas
• Using worksheets
• Creating and modifying worksheets
• Embedding existing Excel worksheets
• Working with charts
• Importing and copying data into a datasheet.
Module 3: Introduction to Macros
• Recording and running Macros
• Managing Macros
• Deleting Macros.
Module 4: Enhancing Documents
• Working with graphics
• Modifying graphics
• Positioning and deleting graphics
• Using advanced enhancement techniques
• Inserting special characters
• Inserting watermarks
• Formatting first pages.
Module 5: Reviewing Documents
• About saving versions of a document
• Document compare
• Tracking changes
• Shared workspace
• WordArt.
Appendix A: New Features in Word 365
• Compatibility
• The Office interface
• The Word screen
• The Ribbon
• Dialogue box launchers
• Contextual tabs
• Customise the ribbon
• The mini toolbar
• The quick access toolbar
• Using the keyboard
• Other new features in Word
• File menu options
• Screen views and document navigation
• New graphics features
• Sharing documents
• Tracking
• Touch access
• Tell me feature
• Working together
• Insights
• Ink equations
• Version history.
Delegates should have an understanding of any of the following operating systems:
• Windows 98/NT/2000/ME/XP/VISTA/7/8/10.
Face to Face Learning
Unlike online providers, our classroom-based training in Team Valley, Gateshead and St Peter’s Gate, Sunderland, ensures hands-on support, real-time interaction, and a learning experience that truly engages.
40 Years’ Experience
With four decades of expertise, we’ve helped thousands of finance professionals gain industry-recognised qualifications and advance their careers.
Achievement Rates
Our learner achievement rates are consistently higher than the national average.
Award Winning Training
Recognised for excellence, our expert trainers and tailored approach ensure the highest quality training, setting you up for success in IT and Digital.
Read more about the benefits of choosing Access Training here.
“It was well structured and took us through the steps logically. It was good to learn – and to understand – the data source, transforming the data and finally to build live dashboards. I liked that it was friendly and interactive and I was not afraid to ask questions.”
“I’m grateful for the support and resources provided, and I encourage anyone seeking to upskill in cloud technology to take advantage of the fantastic programs offered by these institutions.”
“Since attending the course, staff have gained skills and knowledge that has already helped them in their roles.
Those on the Excel courses has vastly improved their skills and have utilised their newfound knowledge to tailor workbooks to better suit our needs as a business and modernised our system.”