Blue Pecan Computer Training Ltd

18/12/2020

Ever struggled with percentage increase or decrease calculations?Need to add VAT or markup or apply a discount?

This video demonstrates how to calculate percentage increase or decrease in Excel. You may need to add tax, for example VAT, to a product's price or you may...

16/12/2020

Discover some of the capabilities of XLOOKUP in Excel 365 - it really does put its predecessor VLOOKUP to shame!

Download the featured file on our website https://www.bluepecantraining.com/create-a-multi-column-non-contiguous-return-array-using-xlookup/

https://youtu.be/PnGlEQFniBU

Download the featured file here: https://www.bluepecantraining.com/create-a-multi-column-non-contiguous-return-array-using-xlookup/In this video I demonstrat...

13/12/2017

http://www.bluepecantraining.com/countdown-christmas-excel-christmas-tree-lights/

A few years’ ago I created a video showing you how to create an animated Christmas tree. See the video here http://www.bluepecantraining.com/portfolio/created-a-christmas-tree-with-sparkling-lights-in-excel/ It’s Christmas time again and I thought it was time to create version 2.0 to include an ...

28/11/2013

Another free video tutorial that you will find useful if you need a reminder on the TRIM function. If you need to get rid of leading or trailing spaces before you can perform a lookup - then this tutorial will help you!

http://www.bluepecantraining.com/portfolio/1692excel-trim-function-remove-superfluous-spaces-in-text/

28/11/2013

Here's a free Excel video tutorial for you... "How to create cascading drop down list". This is where you have two drop down lists - the value you select in the first defines the values that will appear in the second.

http://www.bluepecantraining.com/portfolio/cascading-drop-down-lists-in-excel/