Example spreadsheets and templates in one easy location for you to download and freely use.
Read more »Ultimate Guide to unprotect your Excel spreadsheets.
Read more »Do you often re-type over content in a cell in Excel then realise that you shouldn’t have just done that? Excel’s Undo (Ctrl + Z) feature provides you with a quick way to reverse (i.e. undo) any changes you have made to a worksheet such as accidentally deleting data, applying incorrect formats, or moving formulas. Similarly, if you have reversed back a change, but then realise that the change should […]
Ever had one of those moments when you have been working hard all day on a spreadsheet and your boss/client needs it by close of business and just as you are tidying things up and just about to hit the save button and… whoosh – something totally unexpected happens and your computer loses power or shuts down or (insert multiple other scenarios here…) and “Arghhhhh!!!!” – you have lost all […]
Needing to increase your productivity, don’t take your hands off of the keyboard when you need to copy and paste data within your spreadsheets, simply use Ctrl + C to copy the data in your selected cell(s) and Ctrl + V to paste it to the destination cell. Continue the Discussion Continue the discussion and leave a comment below – Do you have a favourite productivity tip you would […]
Back to the Future. Photo: © http://www.backtothefuture.com/ Wednesday, 21st October, marks the long-awaited day when Marty McFly and Doc Brown traveled to in Back to the Future Part II. While the world may look a little different to that denoted in the 1989 film (why don’t we all have hover boards or cars that can fly??), what do you think the world will look like in another […]
Don’t Wait – The Time will Never be Right. A great quote from Napolean Hill… With a little tweak by us at the end… If you are waiting for that perfect moment, it will never happen and you’ll end up spending all your time waiting… So take action. Don’t put it off any longer. Jump on in and start learning Excel today!! Click here to start […]
Excel formula basics every small to medium business owner should know. One of the most powerful features of Excel is its ability to allow you, the user, to specify relationships between the information you have stored in your worksheets. Having the ability to be able to specify these relationships i.e. using formulas between your information, can significantly enhance and improve the usefulness of your spreadsheets. Formulas allow you […]
The Future of Excel in Business Intelligence Do you use Microsoft Excel in your job/business to analyse and present data? If so, you are not alone. You are among the myriad of other businesses that use this software as their tool of choice to undertake business intelligence analysis and reporting. With Excel 2016 just around the corner and Microsoft’s announcement that it will include built-in Business Intelligence features, ExcelSuperSite and a […]
