In Microsoft Excel we can use IF functions to facilitate decision making formula where we have a test or condition with 2 outcomes - positive and negative. This video gives us a short example of how to use the IF function in Excel 2016. Our colleagues over at Progressive Training offer Excel Training Courses onsite at your Business throughout Ireland: You can visit their … [Read more...]
Guide to Pivot Tables, Slicers and Charts in Microsoft Excel 2016
Anyone who is using Excel to analyse large amounts of data should understand how to use the the Pivot Tables tool and technique. It allows us to quickly compare and contrast data from our spreadsheet to be used in the decision making process. The video below gives us a 12 min guide to the use of Pivot Tables. Our colleagues over at Progressive Training offer Microsoft … [Read more...]
5 ways to use Microsoft Excel within your Business
Microsoft Excel is the leading spreadsheet program used in business today. With its ability to deal with text, numbers or values and formula it is ideally suited to the day to day admin requirements of a business. As an example I have listed 5 key ways you can use Microsoft Excel in business. 1. Inventory management and stock control A practical use of Excel within a … [Read more...]
Adding numbers in Microsoft Excel 2013
We can see in this video how we can use Excel to insert numbers or values and to create basic formula to add these numbers or values. We also see the use the SUM formula or function to perform simple additions. This is one of the basic uses of Microsoft Excel 2013. Our colleagues over at Progressive Training offers Microsoft Excel Training Courses throughout Ireland: … [Read more...]
5 main reasons to use Microsoft Excel in your Business
Microsoft Excel is one of the leading spreadsheet applications used in business today. It has become a key business tool in helping us organise and analyse our key business data to aid in our business decision making and management. Benefit of Microsoft Excel to your business We can see here some of the main reasons why we find using Excel of great benefit and that o … [Read more...]
Follow Us!