EXCEL / VBA BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on General in Excel
Showing blogs 1-12 (out of 12)
Posted by Andy Brown on 13 September 2019
Microsoft have finally recognised the limitations of the VLOOKUP function, and are rolling out the XLOOKUP function to supersede it, as well as the useful (if less significant) XMATCH function.
Posted by Andy Brown on 17 June 2019
This month it's Shaun's turn to nominate the five best short-cut tips in Excel.
Posted by Andy Brown on 09 May 2019
All trainers live for that moment when someone's face lights up, as they learn something new which will change their working life for the better. This blog lists my 5 biggest such OOH moments from our Excel training courses. How many of these tips do you know?
Posted by Andy Brown on 25 April 2018
This blog shows options for creating a webcam focused on one particular area of an Excel workbook! You can do this either by pasting the Excel range into PowerPoint or Word as a linked picture, or by using the Excel camera tool.
Posted by Andy Brown on 15 January 2018
We've revamped our Excel course offerings, to include a new one-day Intermediate Excel course to sit between our introduction and advanced courses.
Posted by Andy Brown on 26 January 2017
This short blog explains how you can customise your quick access toolbar to display the path of the file that you are currently working on.
Posted by Andy Brown on 07 September 2015
The latest incarnation of Microsoft Office (2016) should be released on 22nd September 2015 (Microsoft are always a bit ahead of themselves with versions). This blog gives a detailed guide to what's new, the biggest changes being in Excel and Outlook.
Posted by Andy Brown on 16 May 2014
Did you know that Excel workbooks are really just a collection of XML files, all zipped together? We didn’t either, so we thought we'd tell the world.
Posted by Andy Brown on 13 August 2013
A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!
Posted by Andy Brown on 12 August 2013
Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!
Posted by Andy Brown on 30 January 2013
Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013