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 and covers a range of[…]

Eident Training

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 finite or infinite resources. The[…]

Royal Mail PostCode Analysis in 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 mix of letters and numbers[…]