Blog

21/07/2017
  • Plugins now supported in WordPress.com Business Plan

    Plugins now supported in WordPress.com Business Plan

    Through a major update just announced to the WordPress Business Plan option (currently priced around £20 per month – see WordPress.com pricing options), you will be able to access and add third-party plugins and themes built by the WordPress community. With support for plugins and third-party themes, WordPress.com Business users will …Read More »
  • Places Remaining on Microsoft Project Training Course in Glasgow on 16/08/2017

    Places Remaining on Microsoft Project Training Course in Glasgow on 16/08/2017

    Due to late cancellations we now have places available on our Microsoft Project training course in Glasgow on 16th August 2017. Check out the full course outline, and book online, at our event page or register through our EventBrite listing.  Read More »
  • Understanding Mircosoft Project’s Global Template

    Understanding Mircosoft Project’s Global Template

    The Global Template When Microsoft Project is started it creates a new blank project file which, although it contains no Tasks or Resources, has all the standard Views, Tables and Calendars etc. This is all provided from Mircosoft Project’s Global Template, a file called Global.mpt. The first time a view, …Read More »
  • Using Stencils in Microsoft Visio

    Using Stencils in Microsoft Visio

    Microsoft Visio enables you to create a variety of different drawings from organizational charts and flowcharts, web site maps and network drawings to office plans and timelines. When you begin a new diagram, you can start with one of the Visio solution templates, which contain all the shapes, styles and …Read More »
  • Tips for Microsoft Word VBA Macros – from Eident Training

    Tips for Microsoft Word VBA Macros – from Eident Training

    The Basics of VBA You can automate many routine tasks with Microsoft Word VBA Macros (actually, Macros are Visual Basic Sub Procedures; there are also Visual Basic Function Procedures). Microsoft Office applications, such as Word, Excel, PowerPoint, Outlook, Access and Project share a common programming language called Visual Basic for …Read More »
  • Training Course Discounts

    Training Course Discounts

    At Eident we offer substantial discounts to multiple attendees booked on any of our standard public training courses.  For every additional attendee an organisation sends on one of our training courses in Glasgow or Edinburgh the percentage discount increases. Discounts from 25% to 85% apply for multiple bookings on the …Read More »
  • Controlling how you view your data in Microsoft Excel

    Controlling how you view your data in Microsoft Excel

    In this post we highlight many of the common options of controlling how you view your data in Microsoft Excel.  From dealing with multiple views on the same data sheet, freezing panes to make your headings always visible, to managing and working with mutiple sheets and workbooks. Creating Multiple Views …Read More »
  • InfoPath can streamline the collection and storage of user generated data

    InfoPath can streamline the collection and storage of user generated data

    With InfoPath Training courses from Eident you will learn how InfoPath Designer & InfoPath Filler can help you record data in electronic forms, export data to other programs, import data from other programs, modify and customise the built in sample forms.  Our one day introduction course consists of 3 modules.  …Read More »
  • Microsoft Publisher – fine tune the handling of text

    Microsoft Publisher – fine tune the handling of text

    In Microsoft Publisher you can fine tune the handling of text – control the position and flow of text by adjusting tracking, kerning and vertical spacing. Additionally, you can place objects with great precision by nudging or snapping them into place.  Book onto one of our highly rated Microsoft Publisher …Read More »
  • Learn Simple HTML

    Learn Simple HTML

    At Eident we not only deliver standard Microsoft Office training courses – we adapt and integrate training programmes to incorporate the tools and software people need to use every day.  Quite often people face a gap in their skill set – they need to know a little bit about a …Read More »
  • Using Simple Functions in Microsoft Excel

    Using Simple Functions in Microsoft Excel

    Functions are built-in formulas that you can use to make your worksheet computations easier. For example, the SUM function adds all cells within a given range. For instance, if you wanted to add cells B8, B9, B10, B11, B12, B13, and B14, you wouldn’t need to enter cell references and …Read More »
  • How to optimise the performance of Microsoft Access Databases

    How to optimise the performance of Microsoft Access Databases

    Is your Microsoft Access Database running slowly? Do Queries take for ever to load? Read on for our great tips on optimising the performance of your Microsoft Access Database. Optimising General Table Performance To achieve the best performance results, apply the following guidelines for table design in your Microsoft Access …Read More »
  • Microsoft Excel VBA Function Procedures

    Microsoft Excel VBA Function Procedures

    User-Defined Functions Microsoft Excel VBA Function Procedures can be used to standardise and simplify any type of calculation in Excel spreadsheets. As a user of Excel you will be aware that the application already comes with a vast library of functions. In Excel, whether you use a simple SUM() function …Read More »
  • Crystal Reports Linking Main and Sub Report Data

    Crystal Reports Linking Main and Sub Report Data

    Linking a subreport to the data in the primary report Frequently, the data in a subreport supplements the data in the primary report. You might, for example, have customer data in a primary report and then use subreports to show the orders for each customer. In such cases, you will …Read More »
  • Use Microsoft Excel Power Query To Transform Your Data

    Use Microsoft Excel Power Query To Transform Your Data

    With Microsoft Excel Power Query you can share and manage queries as well as search data within your organization. Users can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. Power Query Transforms …Read More »
  • New Glasgow Training Venue

    New Glasgow Training Venue

    We are pleased to announce the opening of our new Glasgow training venue, right in the heart of Glasgow city centre.  With the increase in the volume of courses we offer, and the continued growth in popularity of our highly rated training delivery, we had outgrown our previous site. From …Read More »
  • Project Planning with Microsoft Project

    Project Planning with Microsoft Project

    Microsoft Project is a great tool to help you to plan projects, manage and update project information, and communicate the status once the project is under way. Planning with Microsoft Project help provides a good structure to help ensure project success. Getting Started The details of the project Tasks and …Read More »
  • Plan for the New Year – Understanding Project Planning

    Plan for the New Year – Understanding Project Planning

    Understanding Project Planning & Management At the heart of every project planning and management system is a scheduling algorithm. An algorithm is a mathematical or logical equation that solves a complex problem by breaking down the problem into simple steps. When scheduling resources and parameters are entered into it, the …Read More »
  • Take our Quick Microsoft Project Crossword!

    Take our Quick Microsoft Project Crossword!

    If you know Microsoft Project well, or have been on one of our highly rated Microsoft Project training courses, this quick Microsoft Project crossword quiz should take you just a few minutes to complete. There are clues a few key words and some crucial Project terminology that every Microsoft Project …Read More »
  • Some Visual Basic Programming Design Standards

    Some Visual Basic Programming Design Standards

    Visual Basic Programming Design Standards Visual Basic Programming Design Standards for coding aren’t about rules that have been set in stone, they’re about practical guidelines that in the end will make your life as a programmer easier and your programs better. The intent in presenting this content isn’t to hand …Read More »
  • Eident  – new partnership brings high spec Lenovo PCs and laptops

    Eident – new partnership brings high spec Lenovo PCs and laptops

    Eident have confirmed a new deal bringing high spec Lenovo PCs and Laptops to our computer classrooms.  Starting with the replacement of our mobile training suite of laptops, Eident will be upgrading all training room equipment over the coming months. This investment underlines Eident’s commitment to ensuring everyone attending one …Read More »
  • Prezi – a modern twist on PowerPoint

    Prezi – a modern twist on PowerPoint

    What is Prezi? Prezi is a visual “storytelling” alternative to traditional slide-based presentation formats like Microsoft PowerPoint. Prezi presentations feature a map-like, schematic overview that lets users pan between topics at will, zoom in on desired details, and pull back to reveal context. This freedom of movement enables “conversational presenting,” …Read More »
  • New Course – BI Dashboard Design using Microsoft Excel

    New Course – BI Dashboard Design using Microsoft Excel

    On recent advanced Microsoft Excel training courses we have been asked to tailor content to include good Business Intelligence (BI) reports, commonly dashboard design.  When designed well BI Dashboards help to engage the power of visual perception to communicate information efficiently. BI Dashboard design using Microsoft Excel is increasing popular …Read More »
  • Project Overview

    Project Overview

    Here is a very brief project overview introducing basic concepts of project planning, management and critical path analysis. Definition of a Project The Project Management Institute defines a project as follows: A Project is a unique undertaking with a defined starting point and duration directed at achieving defined objectives, utilizing …Read More »
  • Breaking Down PostCodes with Microsoft Excel

    Breaking Down PostCodes with Microsoft Excel

    During the recent Microsoft Excel training program we delivered for the national Citizens Advice service we tailored the content to respond to relevant data issues.  One of these, breaking down postcodes with Microsoft Excel to allow for better location analysis, we thought we whould share here: UK PostCodes are a …Read More »
  • Training Needs Analysis (TNA)

    Training Needs Analysis (TNA)

    A Training Needs Analysis (TNA) is a method of identifying a gap between a Job Description (skills required for a job) and an Individual (skills that person has to do the job). This skill can be assessed by the individuals own judgement or by them completing a skills assessment. The …Read More »
  • Handy Shortcuts and Tips for Microsoft Visio

    Handy Shortcuts and Tips for Microsoft Visio

    We’ve got lots of Microsoft Visio Tips, Shortcuts, Training options to suit all users… there are also places available on our Microsoft Visio courses in Glasgow and Edinburgh later this month!   If you can’t wait, here is a great short video clip highlighting the key components of the Ribbon elements …Read More »
  • 5 Key Tips on Delivering Successful Projects

    5 Key Tips on Delivering Successful Projects

    Our highly rated Microsoft Project training courses in Glasgow and Edinburgh cover not just the technical features and functions of the powerful planning and management tool but how to apply standard methodologies and best practice guidelines when using the software.  Richard Spires of Learning Tree International has identified 5 key tips …Read More »
  • Agile Microsoft Project

    Agile Microsoft Project

    Many people find it difficult to work out how to use Microsoft Project outside the traditional PRINCE2 lifecycle stages or waterfall schedule approach. Iterative activities such as Scrum or agile planning and dynamic schedules are becoming increasingly popular and, of course, can be implemented with the help of Microsoft Project. …Read More »
  • Microsoft Visio ScreenTips

    Microsoft Visio ScreenTips

    ScreenTips are just like ToolTips that you see in Microsoft Windows software applications when you hover your mouse over a key element of the user interface. If you pause your mouse over a Visio shape that has a ScreenTip, a little window pops up, displaying informational text for your enlightenment. …Read More »
  • New Features in Microsoft PowerPoint 2016

    New Features in Microsoft PowerPoint 2016

    Microsoft PowerPoint 2016 for Windows has all the functionality and features you’re used to, with some added enhancements and the best new features from Microsoft Office 2016. Text Highlighter PowerPoint now has a Text Highlighter similar to the one in Word, by popular demand! You can use it to pick …Read More »
  • Microsoft Office 2016 Quick Guides

    Microsoft Office 2016 Quick Guides

    Microsoft Office 2016 Quick Guides have been created for the new versions of Word, Excel, PowerPoint and Outlook for your Windows PC. Download free Quick Start Guides for an introduction to the basics in each of these apps. - Click on the images below for links to the download files. …Read More »
  • Customising Microsoft Project Tables and Filters

    Customising Microsoft Project Tables and Filters

    Building Custom Tables and Filters in Microsoft Project Most people using Microsoft Project have the requirement to store additional information which may not be an option in Microsoft’s standard tables.  Storing additional data in custom table fields then creates the requirement to build customised filters to help find and extract …Read More »
  • A Quick Guide to Timelines in Microsoft Project

    A Quick Guide to Timelines in Microsoft Project

    On the View tab in the Microsoft Project Ribbon there is an option to show or hide the Project Timeline.  The Timeline allows you to easily create a high level view of your project plan that you can then share through other Office applications such as PowerPoint and Outlook. Viewing …Read More »
  • New Features in Crystal Reports 2016

    New Features in Crystal Reports 2016

    After a few minor upgrades in previous editions, the new version of Crystal Reports coming out now actually has some useful new features: Conditional formatting of lines and boxes – a nice, simple formatting attribute, removing the need to create multiple sections with a different lines and each section conditionally …Read More »
  • Microsoft Excel Match Index Functions

    Microsoft Excel Match Index Functions

    Use Match Index instead of VLookup Our Microsoft Excel training courses take your through many of the program’s built-in functions, including the combined use of Match Index. One of the most popular is the VLOOKUP function, which lets you search for and return values in an Excel worksheet as if …Read More »
  • New Microsoft Project Reports Features

    New Microsoft Project Reports Features

    Microsoft Project’s New Report Tools Everyone’s reporting needs are different, and for years Mircosoft Project’s reporting options were very limited and looked outdated. Now however Microsoft have built impressive new reporting features into the Project software application. Building off familiar Microsoft Office components, you can now create reports with charts …Read More »
  • Recording when Edits are made in Microsoft Access

    Recording when Edits are made in Microsoft Access

    A common question we get from people working with Microsoft Access databases is How can I record & audit when changes were made? To create a detailed audit trail you would need to set up a one-to-many relationship for each table involved so that each table has a related table …Read More »
  • Microsoft Excel Date Calculations, Formulae & Functions

    Microsoft Excel Date Calculations, Formulae & Functions

    Date Calculations in Excel With Microsoft Excel Date Calculations, is there an easy way to work out current age using an Excel formula? Yes!   a function called DATEDIF used to work really well. Unfortunately Microsoft no longer supports this function in Excel – you can still use it, but you …Read More »
  • Learning At Work Week 2016

    Learning At Work Week 2016

    Learning at Work 2016 This year’s Learning at Work Week is nearly here! There is still time to take part in one of our Quick Learn events in Glasgow and Edinburgh. Contact us for details: info@eident.co.uk We deliver IT skills training courses on Microsoft Excel, Access, Project, Visio, Word, Crystal …Read More »
  • Sharing your Microsoft Outlook Calendar

    Sharing your Microsoft Outlook Calendar

    You can share Microsoft Outlook calendar information with other people by using Microsoft Outlook in three ways: By email With Microsoft Exchange Server accounts By publishing a calendar online Share Microsoft Outlook calendars by email Calendars shared by email arrive in the recipient’s Inbox as email message attachments, with a …Read More »
  • Troubleshooting VLOOKUP functions in Microsoft Excel

    Troubleshooting VLOOKUP functions in Microsoft Excel

    Microsoft Excel VLOOKUP troubleshooting tips APPLIES TO: Excel 2016 , Excel 2013 , Excel 2010 , Excel 2007 , Excel 2016 for Mac How to Fix Common Excel VLookup Problems Quickly If you use the VLOOKUP function to look up values in a list or table, it’s possible to end …Read More »
  • Three Crucial Points for Proper Resource Assignments in Microsoft Project

    Three Crucial Points for Proper Resource Assignments in Microsoft Project

    Know the Basic Scheduling Formula Duration = Work/Units Understanding  of  the  meaning  of  these  three  terms (See Project Help), as well as the formula itself, is key to  understanding  how  Project  schedules  a  task.    To anyone who has changed any of these three parameters on  a  task,  without  understanding  this  …Read More »
  • Microsoft Excel VLOOKUP Quick Guide

    Microsoft Excel VLOOKUP Quick Guide

    Here is a quick guide to the Microsoft Excel VLOOKUP Function APPLIES TO: Excel 2016 , Excel 2010 , Excel 2007 VLOOKUP is one of the most popular, useful functions in Excel, but it can be hard to remember the formula if you don’t use it that often. If all …Read More »
  • Five More Useful Ideas for Microsoft PowerPoint

    Five More Useful Ideas for Microsoft PowerPoint

    Following on from our recent PowerPoint Top Tips, we’ve added these five simple ideas, to help make the most of your use of Microsoft PowerPoint presentations. 1.  Display Information Clearly Think about the effect of the design of your slide. You may choose one of the existing design themes that come …Read More »
  • Five Quick Tips for Working in Microsoft Access

    Five Quick Tips for Working in Microsoft Access

    Need some help with your Microsoft Access databases? Here are 5 quick tips to help you achieve great results! 1. How to create an autonumber field that begins with a number greater than 1 In the Microsoft Access tables the AutoNumber field type allows you to assign a unique sequential …Read More »
  • Top Ten Tips For Microsoft Project

    Top Ten Tips For Microsoft Project

    In our experience training, mentoring and consulting with users of Microsoft Project, we have found that with the proper training and understanding of a few simple rules that govern the tool’s behaviour, users’ frustration levels can be drastically reduced. In our training courses we demonstrate how to apply those rules …Read More »
  • Five Top Tips to Working Smarter In Excel

    Five Top Tips to Working Smarter In Excel

    Here are 5 great tips for working smarter in Microsoft Excel 1. Sticky format painter. Double-clicking on the Format Painter icon will cause it to stick, so that you can continue to apply the desired format to multiple cells, ranges, columns or worksheets. To turn off this effect, either press …Read More »
  • COPFS Guidelines on Social Media

    COPFS Guidelines on Social Media

    The Crown Office and Procurator Fiscal Service (COPFS) has launched written policy guidance on communications sent via social media, to provide clarity on when such communications will amount to criminal conduct. While the Lord Advocate has previously explained where the legal boundary lies, particularly in the run up to the …Read More »
  • Five Top Tips to Work Better with Microsoft Word

    Five Top Tips to Work Better with Microsoft Word

    Here are 5 great Microsoft Word tips to improve your productivity Find your Way Home How much time do you spend scrolling around Word documents? I bet it’s a lot. You can do this much more efficiently if you turn on the Navigation Pane. Go to the View Tab and …Read More »
  • Developing a Learning Plan

    Developing a Learning Plan

    A guide to developing a learning plan Meeting needs in a challenging climate — smaller budgets, greater needs Organisations need to ensure realistic returns on their investment in employee training programs. For many, identifying benefits from training such as improved performance, increased efficiency and reduced time on everyday tasks are …Read More »
  • Using the Bang (!) or Dot (.) in Microsoft Access

    Using the Bang (!) or Dot (.) in Microsoft Access

    The Bang! (Exclamation Operator) in VBA In Visual Basic for Applications the ! operator, called the “bang” can often be confused with the . operator, called the “dot”. It is particularly common in code for Microsoft Access, where you may see things like this: 1 2 3 4 5 6 …Read More »
  • Our Top Five Tips to Improve Your Presentations with Microsoft PowerPoint

    Our Top Five Tips to Improve Your Presentations with Microsoft PowerPoint

    PowerPoint has dramatically changed the way people make presentations. PowerPoint takes advantage of the fact that most of us learn best visually. PowerPoint adds visual interest to our presentations, organizes our points and allows us to present to people in ways that enhance our ability to connect with and persuade …Read More »
  • Crystal Reports Formulae Editor

    Crystal Reports Formulae Editor

    Working with the Formula Editor The formula shown at the bottom of the Select Expert is not just for informational purposes: It can be edited in-place. However, a much better editor exists for formulas. It’s called the Formula Editor, and it can be accessed by clicking the Formula Editor button …Read More »
  • Top Ten Tips To Speed Up Your VBA Code

    Top Ten Tips To Speed Up Your VBA Code

    1. Turn off Screen Updating This will stop the screen flickering and updating while executing or running macros, and that will greatly speed up your code. Sub Stop_ScreenUpdating () Application.ScreenUpdating = False '... (Your Code) Application.ScreenUpdating = True End Sub Tip: Use Application.ScreenUpdating = False at the beginning of your …Read More »
  • Crystal Reports: Record Selection Formula

    Crystal Reports: Record Selection Formula

    The Record Selection Formula Although the Select Expert is quite powerful, there are certain situations where you need to define a filter that is more complex than the Select Expert allows. Fortunately, Crystal Reports has a built-in formula language that enables custom expressions to be defined as a filter. In …Read More »
  • Social Media Skills Training

    Social Media Skills Training

    Social Media Skills Training Courses New Social Media Skills Training Courses now scheduled! Internet, Web design & Social Media courses – click on the title below for full course outline  Course running in Glasgow & Edinburgh – click on the city for dates in either location WordPress website & blog …Read More »
  • A History Of Microsoft Office

    A History Of Microsoft Office

    How has Microsoft Office evovled? Its easy to forget how we used to work, even a short time ago. Here is a short history of Microsoft’s Office suite… Scroll through the box below or click here for full size versionRead More »
  • Create an Email Signature in Outlook

    Create an Email Signature in Outlook

    Create a new email Click on the Signature button, then click on “Signatures” Check the email account you wish to change, then choose “New” Type a description for the signature Now edit the signature in the large box, formatting the font/size, use of bold/italics where appropriate. Ensure New Messages and …Read More »
  • How robust are your Excel Spreadsheets?

    How robust are your Excel Spreadsheets?

    Most businesses use Excel, it is an essential tool in the modern business world. But many people admit to knowing only a small amount of what it can do. Do you have Excel questions you’ve always been afraid to ask? Are you perplexed by IF Statements, VLOOKUP and INDEX MATCH? …Read More »
  • Can’t find a Microsoft Project feature in the new interface?

    Can’t find a Microsoft Project feature in the new interface?

    Ribbons replace Menus In the new Microsoft Project interface you access commands and features through Ribbons instead of the older style Menus and Toolbars.  These are far more intuitive if you are a new user, but can be frustrating if you’ve been using older versions for a long time – …Read More »
  • New Microsoft Office 2016 Courses now available

    New Microsoft Office 2016 Courses now available

    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/eventsRead More »