Microsoft Excel

Introduction to the Excel 365 App

12am

• Get to know Excel
• Shortcuts
• Making a start

Register

Microsoft Excel

Create and edit simple formulas

12am

• Understanding formulas
• Alternative techniques to create formulas
• Edit and check formula results for accuracy

Register

Microsoft Excel

Manage and update lists of business data

12am

• Understanding how lists should be constructed
• Add new data and edit existing data using shortcuts
• General list management

Register

Microsoft Excel

Use Filters and Subtotals to quickly analyse data

12am

• Understand how to use the many filter options to question your data
• Understand how to use the subtotal tool to question your data

Register

Microsoft Excel

Use Pivot Tables to analyse and report business data

12am

• Set up and edit a Pivot Table in order to analyse and report findings

Register

Microsoft Excel

Create and edit essential business charts

12am

• Use shortcuts to quickly create professional business charts
• Learn how to use different types of charts

Register

Microsoft Excel

Use IF statements to quickly question data

12am

• Understand the true value of IF statements in a spreadsheet
• Understand the basic structure of IF statements and how you can use them

Register

Microsoft Excel

Use Conditional Formatting to improve your performance

12am

• Improve your performance using Conditional Formatting techniques
• Set up Conditional Formatting to work with Numbers, Dates and Text

Register

Microsoft Excel

Control data using Validation and Protection techniques

12am

• Control user options using Data Validation techniques
• Protect spreadsheets using a range of protection techniques

Register

Microsoft Word

Introduction to the Word 365 App

12am

• Get to know Word
• Shortcuts to improve your efficiency
• Making a start

Register

Microsoft Word

Layout and format a business document

12am

• Orientation, Margins, Font, Formatting, Editing
• Paragraphs, Tables, Graphics
• Format tools

Register

Microsoft Word

Improve your performance using Word tools

12am

• Set up and use AutoText
• Set up and use AutoCorrect
• Set up and use Word Templates

Register

Microsoft Word

Create Multi level lists

12am

• Create and edit bulleted and numbered lists
• Create and edit multi level numbered lists

Register

Microsoft Word

Styles and Table of Contents to create reports

12am

• Set up the format of your Styles
• Create a document structure using Headings
• Create a table of contents based on your styles and structure

Register

Microsoft Word

Share and Collaborate on the same document

12am

• Set up document collaboration
• Manage document reviews and track changes
• Compare documents

Register

Microsoft PowerPoint

Introduction to PowerPoint 365 App

12am

• Get to know PowerPoint
• Shortcuts and techniques to improve efficiency
• Making a start

Register

Microsoft PowerPoint

Using the Masters

12am

• Control your slides from the Slide Master
• Control your handouts from the Handout Master

Register

Microsoft Project

Introduction to Project 365 App

12am

• Get to know the Project environment
• Shortcuts and techniques to improve efficiency
• Making a start

Register

Microsoft Project

Critical settings

12am

• Set up and understand the critical settings
• Update the critical settings

Register

Microsoft Project

Create a simple schedule

12am

• Add Tasks, dependencies, leads and lags, delays, milestones
• Using the Gantt and Network diagram

Register

Microsoft Project

Work with Resources

12am

• Add human resources (work), Materials, Costs.
• Make changes and update the schedule

Register

Microsoft Project

Use key Visual elements

2pm

• Work with Baselines
• Work with a Critical Path
• Work with delays, slack and slippage

Register

Microsoft Project

Work with Reports

12am

• Create and edit a selection of standard Project Reports

Register

Dealing with Change

Register

Resilience and  Stress Management

Register

Managing remote Teams

Register

About an Adobe Connect meeting

About a Zoom meeting

About a Teams meeting