Microsoft Outlook

Organise your Microsoft Outlook Contacts

How much time is wasted searching for the correct email addresses when composing a message in Microsoft Outlook?  Here we will help you to organise your Microsoft Outlook Contacts and Address Book to make life simpler and save you time. Creating a Microsoft Outlook Contact List When you open the Microsoft Outlook Contacts folder, Outlook[…]

Microsoft Word

Envelopes and Labels in Microsoft Word – a Quick Guide

Generating Envelopes and Labels in Microsoft Word There are quick and easy ways to work with Envelopes and Labels in Microsoft Word.  You can create and print envelopes, single labels, and pages of labels starting with the Create group on the Mailings ribbon tab. In the Envelopes and Labels dialog box (launched by either the[…]

Eident Project

Microsoft Project Work Breakdown Structure

In project management, a Work Breakdown Structure (WBS) is a method for analysing a project’s activities. Many organizations apply a WBS numbering standard to define projects, because it’s an important planning tool that serves as a basis for project scheduling, reporting, staffing, and budgeting. It can also help establish clear project goals. Microsoft Project Work[…]

Microsoft Access

Microsoft Access Database Design

Microsoft Access Database Design Concepts A database is a collection of information organised and presented in a structured way.  There are many popular software applications which can be used to build databases from the humble spreadsheet to proper relational database management systems. Data                           = Pieces of information. Database                   = Information Source. Reasons for using a[…]

Microsoft Excel

Scenarios and What If Analysis in Microsoft Excel

What If Analysis in Excel Microsoft Excel’s “What If” analysis features provide answers to a variety of mathematical problems. For example, you can use Goal Seek to find what principal amount, based on a specific interest rate, will require you to make a £1,000 mortgage payment. You can use a data table to determine how[…]

Eident initiate plan manage

A Project Planning and Management Road Map

A Project Planning and Management Road Map Building the right plan and managing projects effectively can be very challenging. At Eident Training we can help you understand key project management principles which are crucial for Microsoft Project, building a Project Planning and Management Road Map. Each link below goes to an official Microsoft support page[…]

Microsoft Office

Microsoft Innovations for the Classroom

New innovations in Office 365 for Education Microsoft’s Office 365 empowers individuals, teams and entire organizations to communicate and collaborate. Office 365 for Education builds on this foundation and adds education-specific innovations like the OneNote Class Notebook and Learning Tools—creating the most complete, intelligent and secure service for teaching and learning. It offers the broadest[…]

Eident Scotland IT Training Skills

Custom Functions in Excel VBA

You can write Visual Basic For Applications (VBA) code to create your own custom functions in Excel VBA, known as Used Defined Functions. Working With User‑Defined Functions Although Excel includes many built‑in functions, you will often need to create your own user‑defined functions to perform calculations for which no Excel function exists. For example, you[…]