Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

EBITDA spreadsheet error increases cannabis company loss by almost US$50 million

Recent spreadsheet error showing how a spreadsheet error can change the information reported and relied on with investments. In this case a big player in the Canadian cannabis industry found a formula error which altered the reported adjusted EBITDA loss calculation.

The explanation behind the error is not disclosed, but it is a reminder that you need to be careful with spreadsheets, especially when relying on human intervention for the calculation. Unfortunately due to IFRS and other accounting standards it is difficult to take information straight off accounting systems and spreadsheets inevitably need to be used.

The only way to address human error ( 99.9% of spreadsheet errors are human errors) is by improved training and sticking to the normal best practices of checks and balances in any spreadsheet.

To see the level and topics you need to learn more about in MS Excel, look at the free MS Excel skill and needs assessments we offer.

See Yahoo FinanceĀ ReportĀ on the issue