Microsoft Excel Training Course at Eident

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 same course. For example, for[…]

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 In many cases, you might[…]

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 operators by typing or pointing;[…]

Excel Developer

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 or a more advanced one,[…]

Excel Power Query

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 Your Data You add your[…]

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[…]

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[…]

Microsoft Excel

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 it were a database table.[…]

Microsoft Excel Date Formulae

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 just don’t get any help[…]