Eident Training - News, articles and cooperation

News

New Microsoft Office 2016 Courses now available!

04/05/2016

Our new range of Microsoft Office 2016 training courses are now scheduled for Glasgow and Edinburgh.

  • Please check out schedule at www.eident.co.uk/events

Articles

Microsoft Excel Training Courses in Glasgow and Edinburgh

04/05/2016

Microsoft Excel Introduction Training Course

– Overview

On this Introduction to Microsoft Excel training course, students will learn how to create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Target Audience: Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course in the new interface.

Microsoft Excel Introduction – Objectives

Create basic worksheets using Microsoft Excel 2016.

Perform calculations in an Excel worksheet.

Modify an Excel worksheet.

Modify the appearance of data within a worksheet.

Manage Excel workbooks.

Print the content of an Excel worksheet.

Learn how to use handy features new in 2016.

Outline

Creating a Microsoft Excel Workbook

Starting Microsoft Excel

Creating a Workbook

Saving a Workbook

The Status Bar

Adding and Deleting Worksheets

Copying and Moving Worksheets

Changing the Order of Worksheets

Splitting the Worksheet Window

Closing a Workbook

Exercise: Creating a Microsoft Excel Workbook

The Ribbon

Tabs

Groups

Commands

Exercise: Exploring the Ribbon

The Backstage View (The File Menu)

Introduction to the Backstage View

Opening a Workbook

Exercise: Open a Workbook

New Workbooks and Excel Templates

Exercise: Select, Open and Save a Template Agenda

Printing Worksheets

Exercise: Print a Worksheet

Adding Your Name to Microsoft Excel

Managing Workbook Versions

The Quick Access Toolbar

Adding Common Commands

Adding Additional Commands with the Customize Dialog Box

Adding Ribbon Commands or Groups

Placement

Exercise: Customize the Quick Access Toolbar

Entering Data in Microsoft Excel Worksheets

Entering Text

Expand Data across Columns

Adding and Deleting Cells

Adding an Outline

Adding a Hyperlink

Add WordArt to a Worksheet

Using AutoComplete

Exercise: Entering Text and Using AutoComplete

Entering Numbers and Dates

Using the Fill Handle

Exercise: Entering Numbers and Dates

Formatting Microsoft Excel Worksheets

Selecting Ranges of Cells

Hiding Worksheets

Adding Color to Worksheet Tabs

Adding Themes to Workbooks

Exercise: Customize a Workbook Using Tab Colors and Themes

Adding a Watermark

The Font Group

Exercise: Working with Font Group Commands

The Alignment Group

Exercise: Working with Alignment Group Commands

The Number Group

Exercise: Working with Number Group Commands

Using Formulas in Microsoft Excel

Math Operators and the Order of Operations

Entering Formulas

AutoSum (and Other Common Auto-Formulas)

Copying Formulas and Functions

Displaying Formulas

Relative, Absolute, and Mixed Cell References

Exercise: Working with Formulas

Working with Rows and Columns

Inserting Rows and Columns

Deleting Rows and Columns

Transposing Rows and Columns

Setting Row Height and Column Width

Hiding and Unhiding Rows and Columns

Freezing Panes

Exercise: Working with Rows and Columns

Editing Worksheets

Find

Find and Replace

Exercise: Using Find and Replace

Managing Comments

Adding Comments

Working with Comments

Finalizing Microsoft Excel Worksheets

Setting Margins

Setting Page Orientation

Setting the Print Area

Print Scaling (Fit Sheet on One Page)

Printing Headings on Each Page/Repeating Headers and Footers

Headers and Footers

Microsoft Excel Features that Were New in 2013

One Workbook Per Window Feature

Using Flash Fill

Exercise: Using Flash Fill

Features New in 2016

Tell Me

Smart Lookup

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Excel Intermediate Training Course – Overview

This Intermediate Microsoft Excel training course is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Target Audience: Students who have basic skills with Microsoft Excel who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the new interface.

Microsoft Excel Intermediate – Objectives

Learn to use formulas and functions.

Create and modify charts.

Convert, sort, filter, and manage lists.

Insert and modify illustrations in a worksheet.

Learn to work with tables.

Learn to use conditional formatting and styles.

Class Outline

Advanced FormulasUsing Named Ranges in Formulas

Naming a Single Cell

Naming a Range of Cells

Naming Multiple Single Cells Quickly

Exercise: Using Named Ranges in Formulas

Using Formulas That Span Multiple Worksheets

Exercise: Entering a Formula Using Data in Multiple Worksheets

Using the IF Function

Using AND/OR Functions

Using the SUMIF, AVERAGEIF, and COUNTIF Functions

Exercise: Using the IF Function

Using the PMT Function

Exercise: Using the PMT Function

Using the LOOKUP Function

Using the VLOOKUP Function

Exercise: Using the VLOOKUP Function

Using the HLOOKUP Function

Using the CONCATENATE Function

Exercise: Using the CONCATENATE Function

Using the TRANSPOSE Function

Using the PROPER, UPPER, and LOWER Functions

The UPPER Function

The LOWER function

The TRIM Function

Exercise: Using the PROPER Function

Using the LEFT, RIGHT, and MID Functions

The MID Function

Exercise: Using the LEFT and RIGHT Functions

Using Date Functions

Using the NOW and TODAY Functions

Exercise: Using the YEAR, MONTH, and DAY Functions

Creating Scenarios

Utilize the Watch Window

Consolidate Data

Enable Iterative Calculations

What-If Analyses

Use the Scenario Manager

Use Financial Functions

Working with Lists

Converting a List to a Table

Exercise: Converting a List to a Table

Removing Duplicates from a List

Exercise: Removing Duplicates from a List

Sorting Data in a List

Exercise: Sorting Data in a List

Filtering Data in a List

Exercise: Filtering Data in a List

Adding Subtotals to a List

Grouping and Ungrouping Data in a List

Exercise: Adding Subtotals to a List

Working with Illustrations

Working with Clip Art

Exercise: Working with Clip Art

Using Shapes

Exercise: Adding Shapes

Working with SmartArt

Visualizing Your Data

Creating a Custom Chart Template

Inserting Charts

Exercise: Inserting Charts

Exercise: Editing Charts

Add and Format Objects

Insert a Text Box

Create a Custom Chart Template

Working with Tables

Format Data as a Table

Move between Tables and Ranges

Modify Tables

Add and Remove Cells within a Table

Define Titles

Band Rows and Columns

Remove Styles from Tables

Exercise: Creating and Modifying a Table in Excel

Advanced Formatting

Applying Conditional Formatting

Exercise: Using Conditional Formatting

Working with Styles

Applying Styles to Tables

Applying Styles to Cells

Exercise: Working with Styles

Creating and Modifying Templates

Modify a Custom Template

Microsoft Excel Features that Were New in 2013

New Functions in Excel 2013

Exercise: Using the New Excel Functions

Using New Chart Tools

Exercise: Using the New Excel 2013 Chart Tools

Using the Quick Analysis Tool

Exercise: Using the Quick Analysis Tool

Using the Chart Recommendation Feature

Features New in 2016New Charts

Treemap

Sunburst

Histogram

Waterfall

Box and Whisker

Pareto

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Excel Advanced Training Course – Overview

This Advanced Microsoft Excel training course is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Target Audience: Students who have intermediate skills with Microsoft Excel who want to learn more advanced skills or students who want to learn the topics covered in this course in the new interface.

Microsoft Excel Advanced – Objectives

Create pivot tables and charts.

Learn to trace precedents and dependents.

Convert text and validate and consolidate data.

Collaborate with others by protecting worksheets and workbooks.

Create, use, edit, and manage macros.

Import and export data.

Class Outline

Using Pivot TablesCreating Pivot Tables

Preparing Your Data

Inserting a Pivot Table

Inserting Slicers

Working with Pivot Tables

Grouping Data

Using PowerPivot

Managing Relationships

Inserting Pivot Charts

More Pivot Table Functionality

Exercise: Working with Pivot Tables

Auditing Worksheets

Tracing Precedents

Exercise: Tracing Precedents

Tracing Dependents

Exercise: Tracing Dependents

Showing Formulas

Data Tools

Converting Text to Columns

Exercise: Converting Text to Columns

Linking to External Data

Controlling Calculation Options

Data Validation

Exercise: Using Data Validation

Consolidating Data

Exercise: Consolidating Data

Goal Seek

Exercise: Using Goal Seek

Working with OthersProtecting Worksheets and Workbooks

Password Protecting a Workbook

Removing Workbook Metadata

Exercise: Password Protecting a Workbook

Password Protecting a Worksheet

Exercise: Password Protecting a Worksheet

Password Protecting Ranges in a Worksheet

Exercise: Password Protecting Ranges in a Worksheet

Tracking Changes

Accepting or Rejecting Changes

Setting Tracking Options

Merging Multiple Workbooks

Marking a Workbook as Final

Exercise: Tracking Changes

Recording and Using MacrosRecording Macros

Copy a Macro from Workbook to Workbook

Exercise: Recording a Macro

Running Macros

Editing Macros

Adding Macros to the Quick Access Toolbar

Managing Macro Security

Exercise: Adding a Macro to the Quick Access Toolbar

Random Useful ItemsSparklines

Inserting Sparklines

Customizing Sparklines

Exercise: Inserting and Customizing Sparklines

Preparing a Workbook for Internationalization and Accessibility

Display Data in Multiple International Formats

Modify Worksheets for Use with Accessibility Tools

Use International Symbols

Manage Multiple Options for +Body and +Heading Fonts

Importing and Exporting Files

Importing Text Files

Exercise: Importing Text Files

Exporting Worksheet Data to Microsoft Word

Exercise: Copying Data from Excel to Word

Exporting Excel Charts to Microsoft Word

Exercise: Copying Charts from Excel to Word

Microsoft Excel Features that Were New in 2013

Using Slicers to Filter Data

Exercise: Filtering Data with Slicers

Creating a PivotTable Timeline

Exercise: Creating a Timeline

Creating a Standalone PivotChart

Workspaces in Excel 2013

Features New in 2016

PivotTable Updates

Ink Equations

Multi-Select Option in Slicers

Quick Shape Formatting

Sharing with SharePoint or OneDrive

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Excel Visual Basic / Macros Training Course

One Day Introduction

This Introduction to Excel VBA training course covers:

Introduction to Macros

What is a Macro?

Recording a Macro

Running a Macro

Relative References

Assigning a Macro to a Button on a Worksheet

Assigning a Macro to a Button on a Toolbar

Button Image Editor

Editing Macros

The Visual Basic Editor

The Project Explorer

The Code Window

Procedures

Inserting Comments

Printing a Visual Basic Module

The Range Object

What is the Range Object?

The Cells Property

The Range Property

Flexible Ranges

Range Contents

Workbooks and Sheets

Activating a Workbook

Activating a Worksheet

Debugging and Error Trapping

What are Errors?

Types of Error

Break Mode

Instant Watch

Objects, Properties and Methods

Controlling Objects with their Properties

Performing Actions with Methods

Performing Multiple Actions on an Object

Variables and Constants Control Structures

Conditional Control Structures

Looping Control Structures

Non-Structured Statements

Subprocedures

Controls, Dialogue Boxes and Forms

Built-In Dialogue Boxes

Predefined Dialogue Boxes

Toolbars and Display

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Excel Macros / Visual Basic for Applications Training Course

Two Day Introduction

This full two day training course covers:

Introduction to Macros

What is a Macro?

Recording a Macro

Running a Macro

Relative References

Assigning a Macro to a Button on a Worksheet

Assigning a Macro to a Button on a Toolbar

Button Image Editor

Editing Macros

The Visual Basic Editor

The Project Explorer

The Code Window

Procedures

Inserting Comments

Printing a Visual Basic Module

The Range Object

What is the Range Object?

The Cells Property

The Range Property

Flexible Ranges

Range Contents

Workbooks and Sheets

Activating a Workbook

Activating a Worksheet

ThisWorkBook

Calling Worksheet Events

Calling Workbook Events

Debugging and Error Trapping

What are Errors?

Types of Error

Break Mode

Instant Watch

Stepping Through Code

Error Handling Worksheet and Workbook Events

Creating Line Labels for Error Handling

Writing Error Handling Code to Trap Errors

Error Handling to Resolve Errors

Resuming after Resolved Errors

Objects, Properties and Methods

Controlling Objects with their Properties

Performing Actions with Methods

Performing Multiple Actions on an Object

Variables and Constants Control Structures

Conditional Control Structures

Looping Control Structures

Non-Structured Statements

Subprocedures

Controls, Dialogue Boxes and Forms

Built-In Dialogue Boxes

Predefined Dialogue Boxes

Custom Forms

Worksheet Forms

Setting the Properties of a Control

User-Defined Forms

Adding Form Controls

Form Control Properties

Control and Dialogue Box Events

Displaying and Dismissing a User Form

Handling Form Controls

Toolbars and Display

Customising the Quick Access Toolbar

Customising the Ribbon

Using Worksheet Buttons

Function Procedures

Function Procedures

User-Defined Functions

Function Wizard

Excel Functions

Add-in Applications

What is an Add-in?

Creating an Add-In

Working with Excel Add-Ins

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Access Training in Glasgow and Edinburgh

04/05/2016

Microsoft Access Introduction Training Course – Overview

The Microsoft Access Introduction training course starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

Target Audience: Students who have little or no familiarity with Microsoft Access.

Course Duration: 1 day

Microsoft Access Introduction – Objectives

Gain an understanding of database concepts and terminology.

Learn about the Access interface.

Learn to work with table views, queries, forms, reports, and macros and modules.

Learn to plan a database.

Learn database design fundamentals.

Learn to work with forms and the Form Wizard.

Learn to work with reports and the Report Wizard.

Class Outline

Quick Overview of the Access User Interface

Access Ribbon

Quick Access Toolbar

Object Navigation Pane

Access Work Surface

Access Options Dialog Box

Object Overview

Tables

Queries

Forms

Reports

Macros and Modules

Process Overview

Exercise: Getting Around the Access Environment

Create a Database Using a Wizard

FundamentalsIdentifying Requirements

What is the purpose of the database?

Who will use the database?

What kind of output is needed from the database?

What process is the database replacing or improving?

Exercise: Asking Questions

Gather Information

Data Mapping

Sample Data Map

Naming Conventions

Exercise: Gathering Information

Data Normalization

Table Relationships

Relationship Types

Exercise: Normalizing Data

Tables and Their Views

Definition and Purpose

Datasheet View

Selection Tools

Table Layout Tools

Sorting and Filtering Tools

Print Records

Record Navigation

Working in Datasheet View

Exercise:Working with Tables in Datasheet View

Design View

Open a Table in Design View

Design View Layout

Tables

Creating an Access Database

Exercise: Creating a New Database

Data Types

Exercise: Determining Data Types

Create a Table in Design View

Delete a Field

Rename a Table

Exercise: Creating a Table in Design View

QueriesQueries

Definition and Purpose

Types

Views

Select Queries

Select Queries with Criteria

Logical Operators

Group and Total with Queries

Totals Row with Group By

Exercise: Creating Select Queries

FormsForms

Definition and Purpose

Views

Alter a Form

Exercise: Adding Data Records in Form View

Form Record Navigation

Layout View and Design View

One-Click Forms

Basic Data Entry Form

Basic Multi-Record Form

Datasheet Form

Split Form

Form Wizard

Create a Form with the Form Wizard

Exercise: Creating a Form with the Form Wizard

ReportsReports

Definition and Purpose

Views

One-Click Report

Report Wizard

Create a Report Using the Report Wizard

Exercise: Creating a Report with the Report Wizard

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Access Intermediate Training Course

Audience: This course is ideal for those who wish to interrogate existing Access databases, create queries and reports as well as gaining an insight into the fundamentals of database design using Tables and Relationships.

Course Duration: 1 day

Module 1: Table Design

Setting advanced field properties in tables

Input masks

Validation rules

Default values

Lookup fields

Creating Calculated Fields on Tables

Relating Tables and the different types of Relationships

Module 2: Creating Relationships between Tables

Creating Relationships

Different Relationship types

Viewing subdatasheets

Setting referential integrity

Cascade options

Module 3: Select Queries

Select queries explained

Creating select queries

Working with query views

Adding and deleting fields

Sorting records in the Design View

Using query criteria

Adding calculated fields

Module 4: Designing Advanced Queries

Setting join types between tables and queries

Setting top values in a query

Creating Calculated fields

Creating Summary queries

Grouping queries

Creating Parameter queries

Module 5: Action Queries

Update Query

Make Table Query

Delete Query

Append Query

Union Query

Module 6: Working in Form Design View

Manipulating controls in form design view

Changing form and control properties

Adding controls to a form

List boxes, Check boxes and Option buttons etc.

Using calculations on forms

Module 7: Working in Report Design View

Manipulating controls in a report

Changing report control properties

Managing sorting and grouping in reports

Adding calculations to a report

Controlling pagination

Module 8: Using Sub forms and Sub reports

Creating Sub forms

Creating Sub reports

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Access Advanced Training Course

Audience: This course is designed for existing Access users who need to start automating database tasks or simplify complex database sequences.

Course Duration: 1 day

Module 1: Creating Forms

Working in Form design view

Applying Form controls

Date Picker control

Adding Combo, List and Check Boxes to the Form

Creating forms using Mainform – Subform

Tabular forms

Using Conditional formatting

Additional Form topics

Module 2: Advanced Reports

Using the Report Wizard

Working with Report properties

Grouping Reports

Applying calculations in Reports

Additional topics

Module 3: Advanced Query Techniques

Working with Join properties

Unmatched data

Crosstab queries

Union queries

Action Queries

Find duplicates query

Find unmatched query

Module 4: Importing and Exporting Access Data

Importing a spreadsheet from Excel

Linking data tables to an Access database

Export a table to Excel and text files

Exporting reports

Export to HTML format

Export linked data source information to Excel (new)

Module 5: Access Macros

Developing macros with Macro Designer

Triggering data macros

Running a macro

Attaching a macro to a command button

Running a macro from field properties

Creating conditional macros

Using sub macros

Module 6: Customising Access databases

Database tools and utilities

Compacting a database

Hiding database objects

Start-up options

Create a user Switchboard

Module 7: Discussion Only (new)

Access Web App features in Access Services (coming for SharePoint 2016)

Cascading controls

Datasheet filter improvements

Related item control enhancements

Image storage and performance improvements

Office Add-ins integration with Access Web Apps

Additional packaging and upgrade functionality for Access Web App packages

On Deploy macro action for upgrade scenarios

Lock tables from editing functionality

Download in Excel feature for datasheet views

See our upcoming schedule for this course in Glasgow  or  Edinburgh

Microsoft Access Visual Basic for Applications (VBA) Training Course

This training course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming capabilities of Visual Basic for Applications (VBA). The course is designed to give delegates a thorough overview of programming within the Access environment, enabling them to improve the functionality of their Access databases, whilst providing a useful introduction to VB programming.

Course Aims to enable delegates to:

Work with objects, use the Object Browser, identify collection objects, and use the Controls collection. Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another. Use decision structures and loop structures. Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code.

Duration: 2 Days

Course Content

Visual Basic For Applications Overview·       The VBA Editor

Program Structure

Customising The VBA environment

Create powerful applications

·       Objects, Properties and Methods

Synchronising Forms

Storing Return Values

Learn basic programming structures

·       Working with Modules

Creating Sub Procedures

Calling Sub Procedures

Work with conditional statements and loops

·       The If Statement

The Do Command

Looping

Create custom message boxes

·       Evaluating a Message box

Responding to User Selections

Create Custom functions·       Using Built-in Functions

Creating Custom Functions

Calling Function Procedures

Interact with Excel or Word

·       Opening Other Applications

Destroying Object Variables

Adding Data

Write error-handling code

·       Stepping Through Code

Using the Intermediate Window

Setting a Watch on a Variable

Validating User Input

·       Checking for Null Values

Offering Choices

 

Requirements before booking this course:

This is a generic course and is suitable for users of any version of Microsoft Access. This course is particularly beneficial for those with a sound knowledge of Access who are familiar with other features available such as tables, queries, forms, reports, macros and relationships.

See our upcoming schedule for this course in Glasgow  or  Edinburgh