00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Blog Posts

To view some of our older tips and tricks please visit the Archived Tips & Tricks section.

Business Objects Upgrades

Over the last few years we have been involved in a number of successful projects upgrading Business Objects. The majority of our customers are now looking at moving from XI 3.1 to the current version (BI 4.1). There are many reasons for upgrading your version of Business Objects such as improved data access, usability and […]Read More

Utilising Maps to Chart your Data

In the last article we mentioned how we would be showing you how to use maps to represent your data within your reports. Now we will show you how to achieve this. Over the last year, more and more of our clients have been asking us how they can plot their data on a map […]Read More

Develop your Developers

Fundamentals of Web Dynpro for ABAP: Much of the latest SAP software development has been carried out in Web Dynpro rather than traditional ABAP e.g. CRM, HCM. To help prepare your developers, it is crucial to gain an understanding of this topic in advance of working with developments which have been coded in Web Dynpro. […]Read More


PINNING WORKBOOKS AND PLACES More efficient file and folder location is now found in the Recent option in the File ribbon. Each file and location is listed here and has a Pin icon to the right of it. Click on the pin icon (it turns blue) and the file/folder will remain permanently on your list. […]Read More

Microsoft Office 2013 – Quick Reference Guide (part 1)

The New Fluent Interface The arrow at the top of the File tab returns you to your open file.  WHAT IS NEW IN MICROSOFT OFFICE 2013 New features in Microsoft Office 2013, compared to 2003 and earlier versions, include • Live View • Backstage • Collaboration facilities • New Template Library • Improved Graphics and […]Read More

Global Training, Tailored to Specific Needs

Company Background Set up in 1975, our client is headquartered in USA and has 2 locations in Ireland and many other locations across the world. They have approximately 95,000 people currently employed worldwide. Project Background In 2013, our client engaged Olas to document a process and deliver training to managers on this process and the […]Read More

Slicers in Microsoft Excel

Slicers in Microsoft Excel   Microsoft Excel 2010 and 2013 introduces Slicers which helps the user to quickly and simply filter their data dynamically on a pivot table or chart. Slicers will appear on the users screen as a floating box which can be moved around the screen to suit the user.   • Create or […]Read More

Multiple Slide Masters in PowerPoint

Creating and Customizing Slide Layouts Layouts are like templates right inside the presentation. Each new blank presentation contains one slide master and eleven layout slides. Below you can see an example of an opened Slide Master ribbon, where the title slide is selected. If we add a background to this slide layout, the changes will […]Read More

Olas FIFA World Cup 2014 Competition

Kick off the Summer Samba Spirit with the Olas . Predict the winner of the 2014 FIFA World Cup to be in with a chance of winning 2 tickets to Blood Brothers at the Bord Gáis Energy Theater, in October 2014. Complete the entry form below, with your forecasted winner of the 2014 FIFA World […]Read More

Filtering in Excel

AutoFilter Filtering allows you to show only the records in a list that meet certain criteria. The AutoFilter feature creates a drop-down list for each field that displays all the options in that field. The list can be filtered by selecting any one of these options. Only the matching records will be displayed. • Click […]Read More

Sorting in Excel

Sorting a Database It is possible to organise information in a database by using the Sort feature. This feature can sort any field in the database alphabetically, by number or by date. It is possible to sort in ascending and descending order. It is also possible to sort by up to sixty four columns.   […]Read More

Croí Sales Planning Tool

Situation Our client, the Irish office for a large Multi-National beverage producer, importer and distributor needed a solution that would assist their staff in planning their annual base, promotional price and volume forecasts and to compare these forecasts against actual sales figures. This solution would also need to be capable of managing Annual Operating Plan […]Read More

Goldberg Promotional Planning Tool

Situation Our client, a large Irish FMCG distributor were in a position whereby they had no oversight on annual promotional spend. As a result, they were unable to keep to promotional budgets often causing large over-spends. This left the organisation in a vulnerable financial position, committed to large promotion spends but with limited funds available […]Read More

Performance issue in MS Excel 2013

Performance issue in MS Excel 2013 Recently, a client whom Olas developed a customised MS Excel 2010 application a couple of years ago for, reached out looking for help with an issue surrounding performance of the application in Office 2013. The developed application is sold to customers in the construction industry. In Olas’ experience of […]Read More

SAP Certification In 5 Steps

SAP Certification in 5 Steps If you are thinking of becoming SAP Certified follow the 5 step process: 1. Identify the right level of Certification for you 2. Ascertain the right exam to take 3. Do you need some training before sitting your exam? 4. Use the information on the SAP website to familiarise yourself […]Read More

Microsoft Office Tip – Naming Cells in Excel

Cell/Range Names In Excel 2010, the Name Manager is used to name cells or cell ranges.The Name Manager can be found on the Formulas Tab. It is possible to name a single cell or range of cells. These names can then be used in formulas to make them easier to create and understand. Cell names […]Read More
page 3 of 5
Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.